Hot Standby Not So Hot Anymore

From: Ian Harding <harding(dot)ian(at)gmail(dot)com>
To: General PostgreSQL List <pgsql-general(at)postgresql(dot)org>
Subject: Hot Standby Not So Hot Anymore
Date: 2012-11-06 03:40:50
Message-ID: CAMR4UwG7kJ+XHpRwvfRP9hVBYVShWO+gKOP-5g9cYb-9xizBCw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I had a 9.0.8 hot standby setup, one master, two slaves, working great.
Then, I tried to re-initialize by making a base backup, the way I've done
it many times before, but for some reason I can't get the standby to accept
connections. I copied the postgresql.conf and recorvery.conf out of the
way, cleaned the data directory and extracted the backup files, then
replaced the conf files. Everything works perfectly, but I keep getting
:FATAL: the database system is starting up

I know I'm an idiot and that I did something wrong but I can't find it.

[root(at)db03 data]# grep standby postgresql.conf
wal_level = hot_standby # minimal, archive, or hot_standby
hot_standby = on # "on" allows queries during recovery
max_standby_archive_delay = -1 # max delay before canceling queries
max_standby_streaming_delay = -1 # max delay before canceling queries

[root(at)db03 data]# grep standby recovery.conf
# Specifies whether to start the server as a standby. In streaming
replication,
standby_mode = 'on'
# Specifies a connection string which is used for the standby server to
connect

[root(at)db03 data]# ps aux | grep stream
postgres 62127 0.1 0.0 34554356 3724 ? Ss 16:22 0:16 postgres:
wal receiver process streaming BA7/12B87818

[root(at)db03 data]# ps aux | grep startup
postgres 62122 0.5 0.9 34545900 1223708 ? Ss 16:22 1:03 postgres:
startup process recovering 0000000100000BA700000012

Any suggestions appreciated!!!

- Ian

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Lonni J Friedman 2012-11-06 03:46:05 Re: Hot Standby Not So Hot Anymore
Previous Message Scott Marlowe 2012-11-06 03:10:42 Re: Unexpectedly high disk space usage