Re: [HACKERS] Streaming replication - unable to stop the standby

2010-05-03 Thread Robert Haas
On Mon, May 3, 2010 at 2:47 PM, Tom Lane wrote: > Robert Haas writes: >> Hmm.  When I committed that patch to fix smart shutdown on the >> standby, we discussed the fact that the startup process can't simply >> release its locks and die at shutdown time because the locks it holds >> prevent other

Re: [HACKERS] Streaming replication - unable to stop the standby

2010-05-03 Thread Tom Lane
Robert Haas writes: > Hmm. When I committed that patch to fix smart shutdown on the > standby, we discussed the fact that the startup process can't simply > release its locks and die at shutdown time because the locks it holds > prevent other backends from seeing the database in an inconsistent >

Re: [HACKERS] Streaming replication - unable to stop the standby

2010-05-03 Thread Stefan Kaltenbrunner
Robert Haas wrote: On Mon, May 3, 2010 at 2:22 PM, Stefan Kaltenbrunner wrote: Tom Lane wrote: Stefan Kaltenbrunner 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 54

Re: [HACKERS] Streaming replication - unable to stop the standby

2010-05-03 Thread Robert Haas
On Mon, May 3, 2010 at 2:22 PM, Stefan Kaltenbrunner wrote: > Tom Lane wrote: >> >> Stefan Kaltenbrunner 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: >> >>> $ psq

Re: [HACKERS] Streaming replication - unable to stop the standby

2010-05-03 Thread Stefan Kaltenbrunner
Robert Haas wrote: On Mon, May 3, 2010 at 2:04 PM, Stefan Kaltenbrunner 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 shuttin

Re: [HACKERS] Streaming replication - unable to stop the standby

2010-05-03 Thread Stefan Kaltenbrunner
Tom Lane wrote: Stefan Kaltenbrunner 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 s

Re: [HACKERS] Streaming replication - unable to stop the standby

2010-05-03 Thread Robert Haas
On Mon, May 3, 2010 at 2:04 PM, Stefan Kaltenbrunner 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 > >

Re: [HACKERS] Streaming replication - unable to stop the standby

2010-05-03 Thread Tom Lane
Stefan Kaltenbrunner 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 do

[HACKERS] Streaming replication - unable to stop the standby

2010-05-03 Thread Stefan Kaltenbrunner
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