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: 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 = '*'
I didn't see your attached postgresql.conf, which already has this. Ignore my suggestion, there's something else that others probably know more about than me.
Craig
Craig
Thank you
--
Mark Steben Database Administrator @utoRevenue|Autobase CRM division of Dominion Dealer Solutions 95D Ashley Ave. West Springfield, MA 01089 t: 413.327-3045 f: 413.383-9567