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

2012-08-15 Thread Bruce Momjian
On Wed, Sep 14, 2011 at 10:52:50PM -0500, Robert Haas wrote: > On Thu, Sep 8, 2011 at 5:09 AM, Peter Eisentraut wrote: > > On tis, 2011-09-06 at 17:12 +0200, hubert depesz lubaczewski wrote: > >> On Mon, Sep 05, 2011 at 02:27:23PM -0400, Tom Lane wrote: > >> > It's not just the port, it's all the

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

2011-09-14 Thread Robert Haas
On Thu, Sep 8, 2011 at 5:09 AM, Peter Eisentraut wrote: > On tis, 2011-09-06 at 17:12 +0200, hubert depesz lubaczewski wrote: >> 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

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

2011-09-08 Thread Peter Eisentraut
On tis, 2011-09-06 at 17:12 +0200, hubert depesz lubaczewski wrote: > 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

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

2011-09-06 Thread Denish Patel
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 tryin

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

2011-09-06 Thread Bruce Momjian
Tom Lane wrote: > hubert depesz lubaczewski 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 obj

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

2011-09-06 Thread hubert depesz lubaczewski
On Tue, Sep 06, 2011 at 11:35:43AM -0400, Tom Lane wrote: > hubert depesz lubaczewski 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

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

2011-09-06 Thread Tom Lane
hubert depesz lubaczewski 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

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

2011-09-06 Thread hubert depesz lubaczewski
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

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

2011-09-05 Thread Stefan Kaltenbrunner
On 09/05/2011 08:27 PM, Tom Lane wrote: > hubert depesz lubaczewski writes: >> ran psql with specyfying port: >> psql -p 4329 -U postgres -d some_database > >> then I run query which breaks backend: > >> =# select * from categories limit 1; >> The connection to the server was lost. Attempting re

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

2011-09-05 Thread Tom Lane
hubert depesz lubaczewski writes: > ran psql with specyfying port: > psql -p 4329 -U postgres -d some_database > then I run query which breaks backend: > =# select * from categories limit 1; > The connection to the server was lost. Attempting reset: Failed. > !> > When I'll try to re-issue \c s

[BUGS] psql doesn't reuse -p after backend fail

2011-09-05 Thread hubert depesz lubaczewski
hi, pg version: 9.0.5 - head from 9.0 branch in git. ran psql with specyfying port: psql -p 4329 -U postgres -d some_database then I run query which breaks backend: =# select * from categories limit 1; The connection to the server was lost. Attempting reset: Failed. !> When I'll try to re-issue