From: | Mark Steben <mark(dot)steben(at)drivedominion(dot)com> |
---|---|
To: | pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
Subject: | Fwd: cannot login to psql without specifying host |
Date: | 2018-10-02 11:12:19 |
Message-ID: | CADyzmyw66x_SgxR=gX+RddQaBgHWVVW=eyNO2w_iygewF+piDw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
---------- Forwarded message ---------
From: Mark Steben <mark(dot)steben(at)drivedominion(dot)com>
Good morning,
I run a postgres 9.4.8 standby server, replicating our production server.
I can login using our pguser linux login if I specify the host on the
command line but cannot login if I leave the host off:
* psql -U postgres prime_production -p 5433 -h arprodpsqlreplication01*
*Password for user postgres: *
*psql (9.4.8)*
*Type "help" for help.*
*psql -U postgres prime_production -p 5433 *
*psql: 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.5433"?*
I have changed the UNIX_SOCKET_DIRECTORIES to something other than /tmp
because we have another instance pointing to that directory. I restarted
postgres. Didn't help. I have attached our 3 config files along with an
ls -la listing of our database cluster directory. Any insights welcome.
Thank you
--
*Mark Steben*
Database Administrator
@utoRevenue <http://www.autorevenue.com/> | Autobase
<http://www.autobase.net/>
CRM division of Dominion Dealer Solutions
95D Ashley Ave.
West Springfield, MA 01089
t: 413.327-3045
f: 413.383-9567
www.fb.com/DominionDealerSolutions
www.twitter.com/DominionDealer
www.drivedominion.com <http://www.autorevenue.com/>
<http://autobasedigital.net/marketing/DD12_sig.jpg>
Attachment | Content-Type | Size |
---|---|---|
cluster.listing | application/octet-stream | 2.3 KB |
recovery.conf | application/octet-stream | 2.9 KB |
pg_hba.conf | application/octet-stream | 5.9 KB |
postgresql.conf | application/octet-stream | 22.6 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Christoph Berg | 2018-10-02 11:30:07 | Re: Fwd: cannot login to psql without specifying host |
Previous Message | Anjul Tyagi | 2018-10-01 11:52:14 | Re: Blocking Alert |