Postgres Pro
Downloads
Home   >   mailing lists

Re: Shell Script for Vacuum - Mailing list pgsql-admin

From Raghavendra
Subject Re: Shell Script for Vacuum
Date
Msg-id CA+h6AhhhCqFpVp1PKo-C1NutTCMABFpWMfaLjOTAYdNo_eLqNg@mail.gmail.com
Whole thread Raw
In response to Re: Shell Script for Vacuum  (rajivmehta0201 <rajivmehta0201@gmail.com>)
List pgsql-admin
Tree view
On Fri, Nov 21, 2014 at 4:23 PM, rajivmehta0201 <rajivmehta0201@gmail.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?

​
Check Postgres Server running or not ?   
If running, check on which port its running  ?

Accordingly edit the script and place below environment variables, then call the script.

PGUSER=postgres
PGPORT=5432        ## Give the port on which your server running

---
Regards,
Raghavendra
EnterpriseDB Corporation

pgsql-admin by date:

Previous
From: rajivmehta0201
Date:
Subject: Re: Shell Script for Vacuum
Next
From: Craig James
Date:
Subject: Re: Shell Script for Vacuum