Skip site navigation (1) Skip section navigation (2)

Re: Any reason to use pg_dumpall on an idle database

From: Andreas Zeugswetter <andreas(dot)zeugswetter(at)telecom(dot)at>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Any reason to use pg_dumpall on an idle database
Date: 2000-05-26 06:20:50
Message-ID: 00052608225400.00143@zeus (view raw or flat)
Thread:
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

In response to

Responses

pgsql-hackers by date

Next:From: Andreas ZeugswetterDate: 2000-05-26 06:27:40
Subject: Re: parser oddity (t.count)
Previous:From: Mike MascariDate: 2000-05-26 06:12:32
Subject: Re: Berkeley DB...

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group