Re: [PERFORM] doubt with pg_dump and high concurrent used databases

2007-11-26 Thread Peter Childs
On 25/11/2007, Pablo Alcaraz <[EMAIL PROTECTED]> wrote: > > Tom Lane wrote: > > "Peter Childs" <[EMAIL PROTECTED]> writes: > > > >> On 25/11/2007, Erik Jones <[EMAIL PROTECTED]> wrote: > >> > Does the pg_dump create this kind of "consistent backups"? Or do I > need to do the backups using

Re: [PERFORM] doubt with pg_dump and high concurrent used databases

2007-11-25 Thread Pablo Alcaraz
Tom Lane wrote: "Peter Childs" <[EMAIL PROTECTED]> writes: On 25/11/2007, Erik Jones <[EMAIL PROTECTED]> wrote: Does the pg_dump create this kind of "consistent backups"? Or do I need to do the backups using another program? Yes, that is exactly what pg_dump does. Yes

Re: [PERFORM] doubt with pg_dump and high concurrent used databases

2007-11-25 Thread Tom Lane
"Peter Childs" <[EMAIL PROTECTED]> writes: > On 25/11/2007, Erik Jones <[EMAIL PROTECTED]> wrote: >>> Does the pg_dump create this kind of "consistent backups"? Or do I >>> need to do the backups using another program? >> >> Yes, that is exactly what pg_dump does. >> > Yes so long as you are usin

Re: [PERFORM] doubt with pg_dump and high concurrent used databases

2007-11-25 Thread Peter Childs
On 25/11/2007, Erik Jones <[EMAIL PROTECTED]> wrote: > > On Nov 25, 2007, at 10:46 AM, Pablo Alcaraz wrote: > > > Hi all, > > > > I read that pg_dump can run while the database is being used and makes > > "consistent backups". > > > > I have a huge and *heavy* selected, inserted and updated databas

Re: [PERFORM] doubt with pg_dump and high concurrent used databases

2007-11-25 Thread Erik Jones
On Nov 25, 2007, at 10:46 AM, Pablo Alcaraz wrote: Hi all, I read that pg_dump can run while the database is being used and makes "consistent backups". I have a huge and *heavy* selected, inserted and updated database. Currently I have a cron task that disconnect the database users, make a b

Re: [PERFORM] doubt with pg_dump and high concurrent used databases

2007-11-25 Thread Heikki Linnakangas
Pablo Alcaraz wrote: I read that pg_dump can run while the database is being used and makes "consistent backups". I have a huge and *heavy* selected, inserted and updated database. Currently I have a cron task that disconnect the database users, make a backup using pg_dump and put the database o

[PERFORM] doubt with pg_dump and high concurrent used databases

2007-11-25 Thread Pablo Alcaraz
Hi all, I read that pg_dump can run while the database is being used and makes "consistent backups". I have a huge and *heavy* selected, inserted and updated database. Currently I have a cron task that disconnect the database users, make a backup using pg_dump and put the database online again.