Re: [GENERAL] Dumping/Restoring with constraints?

Thanks Bill for this recommendation:


> *) In the early step dump the data only with pg_dumpall --disable-triggers -a


Dumb question. Will this kind of pg_dumpall lead to downtime, I mean
is there a database lock during this time?

Thanks!

--
Sent via pgsql-general mailing list (pgsql-general-at-postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

On Wed, Aug 27, 2008 at 10:40:41PM +0800, Phoenix Kiula wrote:

> Thanks. But there seems to be a tangible slowdown of Database operations
> during the time that pg_dump is running.

Yes. Pg_dump copies all the data out, so it puts load on your
database and disks.

A
--
Andrew Sullivan
ajs-at-commandprompt.com
+1 503 667 4564 x104
http://www.commandprompt.com/

--
Sent via pgsql-general mailing list (pgsql-general-at-postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general