Re: Shell Script for Vacuum

Поиск
Список
Период
Сортировка
От Raghavendra
Тема Re: Shell Script for Vacuum
Дата
Msg-id CA+h6AhhhCqFpVp1PKo-C1NutTCMABFpWMfaLjOTAYdNo_eLqNg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Shell Script for Vacuum  (rajivmehta0201 <rajivmehta0201@gmail.com>)
Список pgsql-admin
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 по дате отправления:

Предыдущее
От: rajivmehta0201
Дата:
Сообщение: Re: Shell Script for Vacuum
Следующее
От: Craig James
Дата:
Сообщение: Re: Shell Script for Vacuum