Re: [GENERAL] pg_ctl reload breaks our client

2005-09-19 Thread Marc Munro
Tom, Thanks for this. I am going to push for reproducing the problem in a test environment. If I have any success, I will follow up with results and more details. __ Marc On Sat, 2005-09-17 at 01:23 -0400, Tom Lane wrote: > Michael Fuhr <[EMAIL PROTECTED]> writes: > > On Fri, Sep 16, 2005 at 04

Re: [GENERAL] pg_ctl reload breaks our client

2005-09-16 Thread Tom Lane
Michael Fuhr <[EMAIL PROTECTED]> writes: > On Fri, Sep 16, 2005 at 04:34:46PM -0700, Marc Munro wrote: >> On Fri, 2005-09-16 at 17:10 -0600, Michael Fuhr wrote: >> This is not currently seen as a priority (the work-around of "don't do >> that" is seen as sufficient). I'm simply hoping to get someo

Re: [GENERAL] pg_ctl reload breaks our client

2005-09-16 Thread brew
Marc > Yesterday a client application broke immediately after we issued a > pg_ctl reload command. The only change we had made was to pg_hba.conf > to enable trusted connections from localhost. Can you change pg_hba.conf back to what it had been prior and do a reload again and check if the

Re: [GENERAL] pg_ctl reload breaks our client

2005-09-16 Thread Michael Fuhr
On Fri, Sep 16, 2005 at 04:34:46PM -0700, Marc Munro wrote: > On Fri, 2005-09-16 at 17:10 -0600, Michael Fuhr wrote: > > Can you reproduce the problem with a reload? A stop and start will > > terminate client connections, but a reload shouldn't. > > This is not currently seen as a priority (the w

Re: [GENERAL] pg_ctl reload breaks our client

2005-09-16 Thread Marc Munro
Michael, Many thanks for your response; it is much appreciated. My responses are embedded below: On Fri, 2005-09-16 at 17:10 -0600, Michael Fuhr wrote: > On Fri, Sep 16, 2005 at 02:16:29PM -0700, Marc Munro wrote: > > It is Postgres 7.3.6. The client is a multi-threaded C++ client. The > > brea

Re: [GENERAL] pg_ctl reload breaks our client

2005-09-16 Thread Michael Fuhr
On Fri, Sep 16, 2005 at 02:16:29PM -0700, Marc Munro wrote: > It is Postgres 7.3.6. The client is a multi-threaded C++ client. The > breakage was that one group of connections simply stopped. Others > contined without problem. It is not clear exactly what was going on. How did the connections

Re: [GENERAL] pg_ctl reload breaks our client

2005-09-16 Thread Marc Munro
Michael, It is Postgres 7.3.6. The client is a multi-threaded C++ client. The breakage was that one group of connections simply stopped. Others contined without problem. It is not clear exactly what was going on. Nothing in our application logs gives us any clue to this. As for reproducibilit

Re: [GENERAL] pg_ctl reload breaks our client

2005-09-16 Thread Michael Fuhr
On Fri, Sep 16, 2005 at 01:28:13PM -0700, Marc Munro wrote: > Yesterday a client application broke immediately after we issued a > pg_ctl reload command. How did the client break? What behavior did it exhibit? Were there any errors in the server's logs? Can you duplicate the problem? What versi