On Wed, 2006-05-04 at 22:29 +0100, Simon Riggs wrote: > On Wed, 2006-04-05 at 15:42 -0400, Bob Powell wrote: > > > I have a systems admin that is backing up our Linux computers > > (postgres) by backing up the directory structure. This of course > > includes all the files that pertain to my postgres databases. I > > maintain that using pgdump and creating a file of SQL commands for > > restore is a better method by allowing the restore on any linux box that > > is running postgress as opposed to having to reconstruct the directory > > on another server. > > > > Does anyone have any thoughts on this matter. Is one way better than > > the other? Thanks in advance. > > If you want to do this quickly then you should use PITR. The base backup > is faster, plus you're covered if you crash between backups. > > Archivelogmode is standard for Oracle/DB2 etc installations; PITR should > be your standard if you run PostgreSQL too. Here's why: > > pg_dump produces portable backups, but that won't help you if you took > the backup at 04:00 and your server crashes at 14:15 - you'll still lose > *all* the transactions your business performed in the last 10+ hours. > You'll also have to explain that away to your boss and remember she/he's > the one handing out the raises at the end of the year... > > PITR takes more thought, but then is the purpose of a backup to make > your life easier or to recover the data for the person paying you? > > Best Regards, Simon Riggs How do you suggest one does PITR ? It has been a while since I read the Docs, but do not recall any tools that allow one to do such a thing.
