Postgres Pro
Downloads
Home   >   mailing lists

Re: Any reason to use pg_dumpall on an idle database - Mailing list pgsql-hackers

From Andreas Zeugswetter
Subject Re: Any reason to use pg_dumpall on an idle database
Date
Msg-id 00052608225400.00143@zeus
Whole thread Raw
In response to Any reason to use pg_dumpall on an idle database  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
Tree view 
On Fri, 26 May 2000, Bruce Momjian wrote:
> Seems a typical file system backup is fine on an idle database, right?

I think it is a good idea to backup pg_log first, then the rest.
Then you should imho be safe even if load is heavy.
No vacuum until finished of course.

Andreas

pgsql-hackers by date:

Previous
From: Andreas Zeugswetter
Date:
Subject: Re: AW: Performance (was: The New Slashdot Setup (includes MySqlserver))
Next
From: Gunnar R|nning
Date:
Subject: Re: [INTERFACES] Postgresql 7.0 JDBC exceptions - broken connecti ons ?