Streaming replication - unable to stop the standby - Mailing list pgsql-hackers

From Stefan Kaltenbrunner
Subject Streaming replication - unable to stop the standby
Date
Msg-id 4BDF1042.302@kaltenbrunner.cc
Whole thread Raw
Responses Re: Streaming replication - unable to stop the standby
Re: Streaming replication - unable to stop the standby
List 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


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Show schema in COPY error CONTEXT strings
Next
From: Tom Lane
Date:
Subject: Re: Streaming replication - unable to stop the standby