On 30 Oct 2001 at 15:27, Leong, Fushan wrote:
> I am working on a shell script to backup my postgres database. Compared
> with pg_dump and pg_dumpall, I would like to backup the file system
> instead of dump the database because I can shutdown the database server
> in midnight for a few hours. I also can sure I will have a stable backup.
> ( No user is doing anything at the same time )
Personally, I'd rather use pg_dump. That way I'm guaranteed to have a
file which will work with a future version of PostgreSQL.
Why do you want to back up the file system instead of using pg_dump?
SIDE ISSUE: A possible benefit of using pg_dump instead of backing up the
file system: all parts of the database are excerised/explored; any bad parts of the file system will
be identified then.
The FreeBSD Diary - http://freebsddiary.org/ - practical examples
In response to
pgsql-admin by date
|Next:||From: Leong, Fushan||Date: 2001-10-31 00:26:43|
|Subject: file under data|
|Previous:||From: Laurette Cisneros||Date: 2001-10-30 23:30:56|
|Subject: Re: fmgr_info ERROR |