Re: [Fwd: Re: pgaccess connection problems]

"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