Re: Shell Script for Vacuum

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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 Officer
eMolecules, Inc.
---------------------------------

[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux