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