| From: | Raghavendra <raghavendra(dot)rao(at)enterprisedb(dot)com> |
|---|---|
| To: | rajivmehta0201 <rajivmehta0201(at)gmail(dot)com> |
| Cc: | pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Shell Script for Vacuum |
| Date: | 2014-11-22 11:49:25 |
| Message-ID: | CA+h6AhhhCqFpVp1PKo-C1NutTCMABFpWMfaLjOTAYdNo_eLqNg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Fri, Nov 21, 2014 at 4:23 PM, 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?
>
>
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
Blog: http://raghavt.blogspot.com/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Craig James | 2014-11-22 17:51:11 | Re: Shell Script for Vacuum |
| Previous Message | rajivmehta0201 | 2014-11-21 13:23:57 | Re: Shell Script for Vacuum |