Re: Any reason to use pg_dumpall on an idle database

Zeugswetter Andreas <andreas.zeugswetter@telecom.at>

From: Andreas Zeugswetter <andreas.zeugswetter@telecom.at>

To: Bruce Momjian <pgman@candle.pha.pa.us>, PostgreSQL-development <pgsql-hackers@postgresql.org>

Date: 2000-05-26T06:20:50Z

Lists: pgsql-hackers

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