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 | Autobase
CRM division of Dominion Dealer Solutions
95D Ashley Ave.
West Springfield, MA 01089
t: 413.327-3045
f: 413.383-9567
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
www.fb.com/DominionDealerSolutions
www.twitter.com/DominionDealer
www.drivedominion.com
Attachment:
cluster.listing
Description: Binary data
Attachment:
recovery.conf
Description: Binary data
Attachment:
pg_hba.conf
Description: Binary data
Attachment:
postgresql.conf
Description: Binary data