Re: Fastest way to restore a database - Mailing list pgsql-general

From Tom Lane
Subject Re: Fastest way to restore a database
Date
Msg-id 14884.1221246427@sss.pgh.pa.us
Whole thread Raw
In response to Re: Fastest way to restore a database  (William Garrison <postgres@mobydisk.com>)
Responses Re: Fastest way to restore a database  (Scott Ribe <scott_ribe@killerbytes.com>)
List pgsql-general
William Garrison <postgres@mobydisk.com> writes:
> So... if I am using pg_dump and pg_restore with a compressed backup,
> then it is using COPY, correct?  And I think that would follow a CREATE
> TABLE statement as mentioned in the first link... so no WAL files written?

Only if you use --single-transaction.

The worry expressed upthread about the transaction being "too large" is
unfounded, btw.  Unlike some other DBs, PG doesn't have a finite-size
undo log.

            regards, tom lane

pgsql-general by date:

Previous
From: William Garrison
Date:
Subject: Re: Fastest way to restore a database
Next
From: Robert Treat
Date:
Subject: Re: Fastest way to restore a database