<div xmlns="http://www.w3.org/1999/xhtml">Dear Mark,</div><div xmlns="http://www.w3.org/1999/xhtml"> </div><div xmlns="http://www.w3.org/1999/xhtml">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.</div><div xmlns="http://www.w3.org/1999/xhtml"> </div><div xmlns="http://www.w3.org/1999/xhtml">psql -p 5433 -h /database/prime_data/PSQL_94/tmp -U postgres prime_production</div><div xmlns="http://www.w3.org/1999/xhtml"> </div><div xmlns="http://www.w3.org/1999/xhtml">Best regards.</div><div xmlns="http://www.w3.org/1999/xhtml">İyi çalışmalar.</div><div xmlns="http://www.w3.org/1999/xhtml">Samed YILDIRIM</div><div xmlns="http://www.w3.org/1999/xhtml"> </div><div xmlns="http://www.w3.org/1999/xhtml">02.10.2018, 14:13, "Mark Steben" <mark(dot)steben(at)drivedominion(dot)com>:</div><blockquote xmlns="http://www.w3.org/1999/xhtml" type="cite"><div> <div>---------- Forwarded message ---------<br />From: <strong>Mark Steben</strong> <span><<a href="mailto:mark(dot)steben(at)drivedominion(dot)com">mark(dot)steben(at)drivedominion(dot)com</a>></span><br /> </div> <div>Good morning,<div>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:</div><div> </div><div><strong> psql -U postgres prime_production -p 5433 -h arprodpsqlreplication01</strong></div><div><strong>Password for user postgres: </strong></div><div><strong>psql (9.4.8)</strong></div><div><strong>Type "help" for help.</strong></div><div> </div><div><strong>psql -U postgres prime_production -p 5433 </strong></div><div><strong>psql: could not connect to server: No such file or directory</strong></div><div><strong> Is the server running locally and accepting</strong></div><div><strong> connections on Unix domain socket "/tmp/.s.PGSQL.5433"?</strong></div><div> </div><div>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.</div><div> </div><div>Thank you</div><div> </div>--<div><span><font color="#888888"><span style="font-family:calibri;font-size:11pt;"><span style="color:#333333;"><strong>Mark Steben</strong></span> </span><br /> Database Administrator<br /><span style="font-family:century gothic;font-size:8pt;"><a target="_blank" style="color:rgb(79,129,189);font-size:8pt;font-weight:bold;text-decoration:none;" href="http://www.autorevenue.com/">@utoRevenue</a> <span style="color:#4f81bd;font-size:10pt;">|</span> <a target="_blank" style="color:rgb(79,129,189);font-size:8pt;font-weight:bold;text-decoration:none;" href="http://www.autobase.net/">Autobase</a> <br /> <strong style="color:#4f81bd;font-size:8pt;font-weight:bold;text-decoration:none;">CRM division of Dominion Dealer Solutions</strong> <br /><span style="color:gray;font-size:8pt;">95D Ashley Ave.<br />West Springfield, MA 01089</span><br /><span style="color:gray;font-size:8pt;">t: <a>413.327-3045</a></span><br /><span style="color:gray;font-size:8pt;">f: <a>413.383-9567</a></span> </span></font></span></div><p><span><font color="#888888"><span style="font-family:century gothic;font-size:8pt;"><a target="_blank" href="http://www.fb.com/DominionDealerSolutions">www.fb.com/DominionDealerSolutions</a><br /><a target="_blank" href="http://www.twitter.com/DominionDealer">www.twitter.com/DominionDealer</a><br /><span style="color:gray;font-size:8pt;"> <a target="_blank" href="http://www.autorevenue.com/">www.drivedominion.com</a></span></span></font></span><br /><br /><br /><br /><br /> </p></div> <div> </div> <div> </div><p><br /><br /><br /> </p></div><br /><a target="_blank" href="https://www.drivedominion.com/transform-your-vision/"><img src="https://drive.google.com/uc?export=download&id=11-V6G0v_RMn85a0Fq4XYXxOHHkcJH6pi" /></a></blockquote>