Answering my own question .... hot_standby = off by default.. Dave Cramer dave.cramer(at)credativ(dot)ca http://www.credativ.ca On Mon, Dec 5, 2011 at 6:43 AM, Dave Cramer <pg@xxxxxxxxxxxxx> wrote: > 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
