On Tue, Aug 26, 2008 at 6:53 PM, Richard Broersma <richard.broersma@xxxxxxxxx> wrote: > From the following link: > http://www.postgresql.org/docs/8.3/interactive/continuous-archiving.html#BACKUP-BASE-BACKUP > > Step 3 says to perform the back up. > > Does this mean a File System Backup of the Data directory? > OR > Does this mean performing a pg_dumpall and backing up the dump file? File system backup. You tar up the database folder except pg_xlog (and maybe pg_log). You then expand it on the other side (making sure to set up pg_xlog properly). If you ever want to mess around with log shipping I strongly suggest you go through the motions of setting up a warm standby vi the pg_standby utility and practice popping the standby out of recovery. It will give you a good understanding of the process. merlin
