Re: Streaming replication - unable to stop the standby

On Mon, May 3, 2010 at 2:04 PM, Stefan Kaltenbrunner
<stefan@kaltenbrunner.cc> wrote:
> 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?

Yes - I thought it was too.  Specifically, I thought I fixed it.  The
default mode is 'smart' shutdown, just as it is on the primary, so it
won't shut down until all clients have disconnected, but it should
work provided you don't leave a session somewhere.  Can you describe
steps to reproduce?

...Robert