Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_restore and transaction id wraparound - Mailing list pgsql-admin

From Tom Lane
Subject Re: pg_restore and transaction id wraparound
Date
Msg-id 1691.1070057835@sss.pgh.pa.us
Whole thread Raw
In response to pg_restore and transaction id wraparound  (ow <oneway_111@yahoo.com>)
List pgsql-admin
Tree view 
ow <oneway_111@yahoo.com> writes:
> Hypothetical situation: a table containing, say, 10 billion rows is backed up
> and then restored with pg_restore. Would this lead to the transaction id
> wraparound issue since 10B rows are imported in one "batch"?

No, because it'd only be one transaction.

            regards, tom lane

pgsql-admin by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Misplaced modifier in Postgresql license
Next
From: "Mark Carew"
Date:
Subject: Re: Problem with pg_dump / pg_restore