Re: backup file system - Mailing list pgsql-admin

From Jeremy Buchmann
Subject Re: backup file system
Date
Msg-id 2646BAB0-CE5F-11D5-A44B-000502E740BA@wellsgaming.com
Whole thread Raw
In response to Re: backup file system  ("Dan Langille" <dan@langille.org>)
Responses Re: backup file system
List pgsql-admin
Or, you can backup both...

We backup the filesystem every night with plain old dump and then run
pg_dump and copy that file onto the backup, too.  Makes for some nice
redundancy.

--Jeremy

On Tuesday, October 30, 2001, at 04:05 PM, Dan Langille wrote:

> 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.
> --
> Dan Langille
> The FreeBSD Diary - http://freebsddiary.org/ - practical examples
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>


pgsql-admin by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: file under data
Next
From: Tom Lane
Date:
Subject: Re: FreeBSD upgrade causes performance degredation