psql doesn't reuse -p after backend fail - Mailing list pgsql-bugs

From hubert depesz lubaczewski
Subject psql doesn't reuse -p after backend fail
Date
Msg-id 20110905174633.GA7752@depesz.com
Whole thread Raw
Responses Re: psql doesn't reuse -p after backend fail  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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/

pgsql-bugs by date:

Previous
From: Pradeep Dharmavarapu
Date:
Subject: Re: BUG #6194: Cannot install any of the installers
Next
From: Ashesh Vashi
Date:
Subject: Re: BUG #6194: Cannot install any of the installers