Fwd: cannot login to psql without specifying host

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>

<http://autobasedigital.net/marketing/DD12_sig.jpg>

--
<https://www.drivedominion.com/transform-your-vision/>

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

Responses

Browse pgsql-admin by date

  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