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