Re: Shell Script for Vacuum

On Fri, Nov 21, 2014 at 5:23 AM, rajivmehta0201 <rajivmehta0201(at)gmail(dot)com>
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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>

--
---------------------------------
Craig A. James
Chief Technology Officer
eMolecules, Inc.
---------------------------------