From: | Uwe Schroeder <uwe(at)oss4u(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org, bret_stern(at)machinemanagement(dot)com |
Subject: | Re: Backups |
Date: | 2009-11-08 08:39:23 |
Message-ID: | 200911080039.23915.uwe@oss4u.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Personally I prefer multiple stages of backups off-site.
So for my production webserver database, I have slony replicating the database
to a different location. In addition I run full dumps every 12 hours which in
turn I replicate using rdist to a remote system. That way, whatever happens,
the max data loss in the worst case scenario is about 12 hours - which for my
application is acceptable.
Oh, yes, forgot to mention: the replicated database also gets dumped and goes
onto a tape every day.
On Saturday 07 November 2009 11:41:55 pm Bret wrote:
> I need to back up a production database every night
> on FreeBSD 7.2, running Postgresql 8.3.
>
> Any good backup tips I should be aware of.
>
> Typically, I make a backup based on the current day,
> and rotate the seven days in the backup file name
> (eg; sat_backup, sun_backup etc).
>
> Thanks for all the chatter.
>
> Bret Stern
From | Date | Subject | |
---|---|---|---|
Next Message | Tomas Simonaitis | 2009-11-08 08:55:26 | Re: WAL shipping to two machines (PITR) |
Previous Message | Bret | 2009-11-08 07:41:55 | Backups |