psql doesn't reuse -p after backend fail

From: hubert depesz lubaczewski <depesz(at)depesz(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: psql doesn't reuse -p after backend fail
Date: 2011-09-05 17:46:33
Message-ID: 20110905174633.GA7752@depesz.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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 \c some_database now, I got:

!> \c some_database
could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
!>

Clearly it is looking for socket on port 5432, which is bad, because I
explicitly specified the port to be 4329.

before backend crash, \c works normally.

Best regards,

depesz

--
The best thing about modern society is how easy it is to avoid contact with it.
http://depesz.com/

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Ashesh Vashi 2011-09-05 18:10:52 Re: BUG #6194: Cannot install any of the installers
Previous Message Pradeep Dharmavarapu 2011-09-05 14:56:59 Re: BUG #6194: Cannot install any of the installers