Streaming replication - unable to stop the standby

From: Stefan Kaltenbrunner <stefan(at)kaltenbrunner(dot)cc>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Streaming replication - unable to stop the standby
Date: 2010-05-03 18:04:50
Message-ID: 4BDF1042.302@kaltenbrunner.cc
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I'm currently testing SR/HS in 9.0beta1 and I noticed that it seems
quite easy to end up in a situation where you have a standby that seems
to be stuck in:

$ psql -p 5433
psql: FATAL: the database system is shutting down

but not not actually shuting down ever. I ran into that a few times now
(mostly because I'm trying to chase a recovery issue I hit during
earlier testing) by simply having the master iterate between a pgbench
run and "idle" while simple doing pg_ctl restart in a loop on the standby.
I do vaguely recall some discussions of that but I thought the issue git
settled somehow?

Stefan

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2010-05-03 18:15:12 Re: Streaming replication - unable to stop the standby
Previous Message Tom Lane 2010-05-03 17:46:05 Re: Show schema in COPY error CONTEXT strings