Thread

Re: Any reason to use pg_dumpall on an idle database

Zeugswetter Andreas <andreas.zeugswetter@telecom.at> — 2000-05-26T06:20:50Z

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