On Fri, Nov 21, 2014 at 5:23 AM, rajivmehta0201 <rajivmehta0201@xxxxxxxxx> wrote:
Hi,
I am running this script but it giving error.
vacuumdb: could not connect to database postgres: 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.5432"?
Can you please help me on this?
Try using the server's name rather than "localhost" or the default, for example:
psql -U postgres -h myservername
If that works, it means your pg_hba.conf isn't configured correctly for "localhost".
Craig
--
View this message in context: http://postgresql.nabble.com/Shell-Script-for-Vacuum-tp5765414p5827854.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
--
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
---------------------------------
Craig A. James
Chief Technology OfficerCraig A. James