Re: [Fwd: Re: pgaccess connection problems] - Mailing list pgsql-novice

From Tom Lane
Subject Re: [Fwd: Re: pgaccess connection problems]
Date
Msg-id 19436.1012348646@sss.pgh.pa.us
Whole thread Raw
In response to Re: [Fwd: Re: pgaccess connection problems]  ("Josh Berkus" <josh@agliodbs.com>)
Responses Re: [Fwd: Re: pgaccess connection problems]  (Oliver Elphick <olly@lfix.co.uk>)
List 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 by date:

Previous
From: "Josh Berkus"
Date:
Subject: Re: [Fwd: Re: pgaccess connection problems]
Next
From: Frank Bax
Date:
Subject: Re: text field