Re: cannot login to psql without specifying host

On Tue, Oct 2, 2018 at 4:12 AM Mark Steben <mark(dot)steben(at)drivedominion(dot)com>
wrote:

>
>
> ---------- 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.
>

I've seen this when your postgresql.com "listen_address" isn't sent
properly. It's probably something like this:

listen_addresses = '192.168.58.13'

The error message is telling you that Postgres is not listening on
localhost. Instead, you may want something like this:

listen_addresses = 'localhost,192.168.58.13'

or this:

listen_addresses = '*'

Craig

> 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/>

--
---------------------------------
Craig A. James
Chief Technology Officer
eMolecules, Inc.
---------------------------------