Dear Mark,
 
When you specify server name with -h parameter, psql uses TCP socket to connect PostgreSQL server. Due to being changed default unix socket directory, you should give socket directory path with -h parameter to psql if you want to create connection via Unix socket. Please try following parameters.
 
psql -p 5433 -h /database/prime_data/PSQL_94/tmp -U postgres prime_production
 
Best regards.
İyi çalışmalar.
Samed YILDIRIM
 
02.10.2018, 14:13, "Mark Steben" <mark.steben@drivedominion.com>:
 
---------- Forwarded message ---------
From: Mark Steben <mark.steben@drivedominion.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 | 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