This is the second hot_standby server that I have setup for this
particular master server. The logs look good
2011-12-05 06:27:36 EST user=,db= [2065] LOG: database system was
interrupted; last known up at 2011-12-05 06:16:22 EST
2011-12-05 06:27:36 EST user=,db= [2065] LOG: entering standby mode
2011-12-05 06:27:43 EST user=,db= [2065] LOG: restored log file
"00000001000000120000003C" from archive
2011-12-05 06:27:43 EST user=,db= [2065] LOG: redo starts at 12/3C000020
2011-12-05 06:27:43 EST user=,db= [2065] LOG: consistent recovery
state reached at 12/3D000000
scp: walfiles/ca05db01/00000001000000120000003D: No such file or directory
2011-12-05 06:27:45 EST user=,db= [2077] LOG: streaming replication
successfully connected to primary
2011-12-05 06:28:38 EST user=postgres,db=postgres [2089] FATAL: the
database system is starting up
It never gets to the point where it says it is ready to accept connections ?
pg_control data is identical to the other slave
pg_control version number: 903
Catalog version number: 201008051
Database system identifier: 5673024330384732158
Database cluster state: in archive recovery
pg_control last modified: Mon Dec 5 06:37:43 2011
Latest checkpoint location: 12/3E000058
Prior checkpoint location: 12/3D008628
Latest checkpoint's REDO location: 12/3E000020
Latest checkpoint's TimeLineID: 1
Latest checkpoint's NextXID: 0/34511
Latest checkpoint's NextOID: 23996630
Latest checkpoint's NextMultiXactId: 1
Latest checkpoint's NextMultiOffset: 0
Latest checkpoint's oldestXID: 654
Latest checkpoint's oldestXID's DB: 1
Latest checkpoint's oldestActiveXID: 34511
Time of latest checkpoint: Mon Dec 5 06:36:22 2011
Minimum recovery ending location: 12/3D008680
Backup start location: 0/0
Current wal_level setting: hot_standby
Current max_connections setting: 210
Current max_prepared_xacts setting: 0
Current max_locks_per_xact setting: 64
Maximum data alignment: 8
Database block size: 8192
Blocks per segment of large relation: 131072
WAL block size: 8192
Bytes per WAL segment: 16777216
Maximum length of identifiers: 64
Maximum columns in an index: 32
Maximum size of a TOAST chunk: 1996
Date/time type storage: 64-bit integers
Float4 argument passing: by value
Float8 argument passing: by value
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca