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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
