Warm standby system - FATAL: the database system is starting up

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