Hi people, I've set up a warm standby system using WAL shipping, partially following the guide here (My setup ios on two physically separate servers) http://archives.postgresql.org/sydpug/2006-10/msg00001.php I'm using an NFS share on the main server that is then mounted in fstab on the backup. I see in my log on the backup machine: FATAL: the database system is starting up Does this mean the backup is not working? I've left autovacuum on in postgresql.conf - could anythign like this be causing it? Or could I be missing part of the backup in some way? If I create lots of records on the main server, then the log on the backup looks like this: FATAL: the database system is starting up FATAL: the database system is starting up FATAL: the database system is starting up `/mnt/archive/000000010000001A00000080' -> `pg_xlog/RECOVERYXLOG' LOG: restored log file "000000010000001A00000080" from archive `/mnt/archive/000000010000001A00000081' -> `pg_xlog/RECOVERYXLOG' LOG: restored log file "000000010000001A00000081" from archive `/mnt/archive/000000010000001A00000082' -> `pg_xlog/RECOVERYXLOG' LOG: restored log file "000000010000001A00000082" from archive `/mnt/archive/000000010000001A00000083' -> `pg_xlog/RECOVERYXLOG' LOG: restored log file "000000010000001A00000083" from archive `/mnt/archive/000000010000001A00000084' -> `pg_xlog/RECOVERYXLOG' LOG: restored log file "000000010000001A00000084" from archive `/mnt/archive/000000010000001A00000085' -> `pg_xlog/RECOVERYXLOG' LOG: restored log file "000000010000001A00000085" from archive FATAL: the database system is starting up `/mnt/archive/000000010000001A00000086' -> `pg_xlog/RECOVERYXLOG' LOG: restored log file "000000010000001A00000086" from archive FATAL: the database system is starting up FATAL: the database system is starting up FATAL: the database system is starting up As far as I know theres nothing else trying to connect. Thanks Glyn __________________________________________________________ Sent from Yahoo! Mail - a smarter inbox http://uk.mail.yahoo.com ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
