Skip site navigation (1) Skip section navigation (2)

Re: psql doesn't reuse -p after backend fail

From: Denish Patel <denish(at)omniti(dot)com>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, depesz(at)depesz(dot)com, pgsql-bugs(at)postgresql(dot)org
Subject: Re: psql doesn't reuse -p after backend fail
Date: 2011-09-06 16:31:58
Message-ID: CAFddxvNENK_m=gPGy+_E0UEPg-iqt_fa9dGhqF7AYLCtVfXauw@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-bugs
Yeah, Definitely it's not *expected* behavior so documentation is the good
starting point unless we fix the code soon. I don't agree with Tom's comment
on we should find out the reason for crash instead. In most of the cases,
reason for the crash is because someone restarted database and user trying
to get connection back.

my 2 cents!


On Tue, Sep 6, 2011 at 11:49 AM, Bruce Momjian <bruce(at)momjian(dot)us> wrote:

> Tom Lane wrote:
> > hubert depesz lubaczewski <depesz(at)depesz(dot)com> writes:
> > > On Mon, Sep 05, 2011 at 02:27:23PM -0400, Tom Lane wrote:
> > >> It's not just the port, it's all the connection parameters ---
> > >> do_connect relies on the PGconn object to remember those, and in this
> > >> case there no longer is a PGconn object.
> > >>
> > >> We could have psql keep that information separately, but I'm not sure
> > >> it's really worth the trouble.
> >
> > > well, I think it's definitely worth the trouble.
> >
> > [ shrug.. ]  So submit a patch.  Personally I don't think the case comes
> > up often enough to be worth the trouble, and I'd much rather spend
> > development time on preventing the server from crashing in the first
> > place.
>
> Should we document this somewhere?
>
> --
>  Bruce Momjian  <bruce(at)momjian(dot)us>        http://momjian.us
>  EnterpriseDB                             http://enterprisedb.com
>
>  + It's impossible for everything to be true. +
>
> --
> Sent via pgsql-bugs mailing list (pgsql-bugs(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-bugs
>



-- 
Denish Patel,
OmniTi Computer Consulting Inc.
Database Administrator,
Phone: 443.325.1357 x 232

In response to

pgsql-bugs by date

Next:From: Bruce MomjianDate: 2011-09-06 16:48:55
Subject: Re: BUG #5944: COPY FROM doesn't work with international characters
Previous:From: Tom LaneDate: 2011-09-06 16:26:47
Subject: Re: BUG #6199: Can't install datatype hstore

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group