Re: Shell Script for Vacuum

Поиск
Список
Период
Сортировка
От Craig James
Тема Re: Shell Script for Vacuum
Дата
Msg-id CAFwQ8revD9W1nzpma7DwUh_7iPUADRJoLcMFXZpFdxLfx9X5UQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Shell Script for Vacuum  (rajivmehta0201 <rajivmehta0201@gmail.com>)
Список pgsql-admin
Дерево обсуждения
On Fri, Nov 21, 2014 at 5:23 AM, 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?


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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin



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

В списке pgsql-admin по дате отправления:

Предыдущее
От: Raghavendra
Дата:
Сообщение: Re: Shell Script for Vacuum
Следующее
От: fahad basheer
Дата:
Сообщение: Postgresql connection Error