William Garrison <[EMAIL PROTECTED]> 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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
