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

From Bill Moran
Subject Re: Dumping/Restoring with constraints?
Date
Msg-id 20080827103429.081e93a1.wmoran@collaborativefusion.com
Whole thread Raw
In response to Re: Dumping/Restoring with constraints?  ("Phoenix Kiula" <phoenix.kiula@gmail.com>)
Responses Re: Dumping/Restoring with constraints?
List pgsql-general
In response to "Phoenix Kiula" <phoenix.kiula@gmail.com>:

> 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?

No.

--
Bill Moran
Collaborative Fusion Inc.
http://people.collaborativefusion.com/~wmoran/

wmoran@collaborativefusion.com
Phone: 412-422-3463x4023

pgsql-general by date:

Previous
From: "Phoenix Kiula"
Date:
Subject: Re: Dumping/Restoring with constraints?
Next
From: "Phoenix Kiula"
Date:
Subject: Re: Dumping/Restoring with constraints?