Re: Error on pg_dumpall

Поиск
Список
Период
Сортировка
От bock@openit.de (Julian v. Bock)
Тема Re: Error on pg_dumpall
Дата
Msg-id lpwsmgg219.fsf@warpcore.i.openit.de
обсуждение исходный текст
Ответ на Error on pg_dumpall  (Carol Walter <walterc@indiana.edu>)
Список pgsql-admin
Hi

>>>>> "CW" == Carol Walter <walterc@indiana.edu> writes:

CW> postgres@machine1:~$ /usr/local/pgsql/bin/pg_dumpall pg_dumpall:
CW> could not connect to database "template1": could not connect to
CW> server: No such file or directory Is the server running locally
CW> and accepting connections on Unix domain socket
CW> "/tmp/.s.PGSQL.5432"?

CW> If I run the command "psql template1", I can connect to template1
CW> just fine.  It looks like pg_dumpall may be looking for template1
CW> in the wrong place.

Debian uses /var/run/postgresql instead of /tmp as directory for unix
domain sockets. Try
/usr/local/pgsql/bin/pg_dumpall -h /var/run/postgresql

--
Julian v. Bock               Projektleitung Software-Entwicklung
OpenIT GmbH                  Tel +49 211 239 577-0
Jahnstr. 18                  Fax +49 211 239 577-10
D-40215 Düsseldorf           http://www.openit.de
________________________________________________________________
HRB 38815 Amtsgericht Düsseldorf    USt-Id DE 812951861
Geschäftsführer:
Susanne Schultz, Oliver Haakert, Maurice Kemmann

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Error on pg_dumpall
Следующее
От: "Balaji Kasthurirangan"
Дата:
Сообщение: could not bind IPv4 socket