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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
