From: | Thom Brown <thom(at)linux(dot)com> |
---|---|
To: | PGSQL Mailing List <pgsql-general(at)postgresql(dot)org> |
Subject: | Database not starting up for hot standby |
Date: | 2010-09-19 11:49:15 |
Message-ID: | AANLkTinNaA0yOfpsWS347CYydghJq47Qy2kC+g8kR3Qe@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I'm using PostgreSQL 9.0rc1 and can't fathom what I've missed here. I
ran pg_start_backup() on my primary, did a filesystem backup and
restore to the standby, configured the conf files on both
appropriately and issued a pg_stop_backup() on the primary again. I
brought the standby up but I'm getting the following in the log:
2010-09-19 12:32:35 BST LOG: entering standby mode
2010-09-19 12:32:35 BST LOG: redo starts at 1/2F000020
2010-09-19 12:32:35 BST LOG: record with zero length at 1/2F0000B0
2010-09-19 12:32:35 BST LOG: streaming replication successfully
connected to primary
2010-09-19 12:32:36 BST LOG: incomplete startup packet
2010-09-19 12:32:36 BST FATAL: the database system is starting up
2010-09-19 12:32:37 BST FATAL: the database system is starting up
2010-09-19 12:32:37 BST FATAL: the database system is starting up
2010-09-19 12:32:38 BST FATAL: the database system is starting up
2010-09-19 12:32:38 BST FATAL: the database system is starting up
2010-09-19 12:32:39 BST FATAL: the database system is starting up
2010-09-19 12:32:39 BST FATAL: the database system is starting up
2010-09-19 12:32:40 BST FATAL: the database system is starting up
2010-09-19 12:32:40 BST FATAL: the database system is starting up
2010-09-19 12:32:41 BST FATAL: the database system is starting up
2010-09-19 12:32:41 BST LOG: consistent recovery state reached at 1/30000000
2010-09-19 12:32:41 BST FATAL: the database system is starting up
2010-09-19 12:32:41 BST LOG: incomplete startup packet
2010-09-19 12:32:54 BST FATAL: the database system is starting up
2010-09-19 12:35:26 BST FATAL: the database system is starting up
2010-09-19 12:38:44 BST FATAL: the database system is starting up
Got these appearing in the process list too:
postgres: startup process recovering 000000010000000100000030
postgres: wal receiver process streaming 1/300001D0
That last one changed to its current value after I issued a checkpoint
on the primary, but the first one doesn't change.
But I cannot connect to the standby as it's stuck in recovery.
The standby's recovery.conf has hot_standby set to "on" (set before
bringing online of course).
What am I not doing?
--
Thom Brown
Twitter: @darkixion
IRC (freenode): dark_ixion
Registered Linux user: #516935
From | Date | Subject | |
---|---|---|---|
Next Message | Francisco Reyes | 2010-09-19 12:46:04 | Tables with autovacuum_enabled=false still getting vacuumed |
Previous Message | Bret Green | 2010-09-19 01:43:49 | how to insert multiple rows and get the ids back in a temp table (pgplsql)? |