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

From Tom Lane
Subject Re: Streaming replication - unable to stop the standby
Date
Msg-id 19880.1272910512@sss.pgh.pa.us
Whole thread Raw
In response to Streaming replication - unable to stop the standby  (Stefan Kaltenbrunner <stefan@kaltenbrunner.cc>)
Responses Re: Streaming replication - unable to stop the standby
List pgsql-hackers
Stefan Kaltenbrunner <stefan@kaltenbrunner.cc> writes:
> 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?

Hm, I haven't pushed this hard but "pg_ctl stop" seems to stop the
standby for me.  Which subprocesses of the slave postmaster are still
around?  Could you attach to them with gdb and get stack traces?
        regards, tom lane


pgsql-hackers by date:

Previous
From: Stefan Kaltenbrunner
Date:
Subject: Streaming replication - unable to stop the standby
Next
From: Robert Haas
Date:
Subject: Re: Streaming replication - unable to stop the standby