Re: [Fwd: Re: pgaccess connection problems]

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [Fwd: Re: pgaccess connection problems]
Дата
Msg-id 19436.1012348646@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [Fwd: Re: pgaccess connection problems]  ("Josh Berkus" <josh@agliodbs.com>)
Ответы Re: [Fwd: Re: pgaccess connection problems]  (Oliver Elphick <olly@lfix.co.uk>)
Список pgsql-novice
"Josh Berkus" <josh@agliodbs.com> writes:
> All programs that need to connect to Postgres except for the postgres
>  utilities must use the TCP/IP interface to connect.  Thus, while psql
>  and pg_dump will work without "-i", pgaccess and pgadmin will not.

Not sure that that's 100% true.  If you tell any of these programs to
connect to host "localhost", they will certainly go via TCP --- and
hence fail if the postmaster hasn't got -i.  But on at least some of
the GUI interfaces, putting an empty entry in the "host" dialog box
will result in a Unix-socket connection not a TCP connection to
localhost.  (The Unix-socket method is what psql and pgdump use by
default.)  For that, you don't need -i.

Dunno if that applies to pgaccess, but try it.

            regards, tom lane

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

Предыдущее
От: "Josh Berkus"
Дата:
Сообщение: Re: [Fwd: Re: pgaccess connection problems]
Следующее
От: Frank Bax
Дата:
Сообщение: Re: text field