Re: Dumping/Restoring with constraints? - Mailing list pgsql-general

From Phoenix Kiula
Subject Re: Dumping/Restoring with constraints?
Date
Msg-id e373d31e0808270726x2deb251an5d875ebbadc6149f@mail.gmail.com
Whole thread Raw
In response to Re: Dumping/Restoring with constraints?  (Bill Moran <wmoran@collaborativefusion.com>)
Responses Re: Dumping/Restoring with constraints?  (Bill Moran <wmoran@collaborativefusion.com>)
List pgsql-general
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!

pgsql-general by date:

Previous
From: Bill Moran
Date:
Subject: Re: Dumping/Restoring with constraints?
Next
From: Bill Moran
Date:
Subject: Re: Dumping/Restoring with constraints?