Re: Streaming replication - unable to stop the standby

Stefan Kaltenbrunner <stefan(at)kaltenbrunner(dot)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