Re: [Fwd: Re: pgaccess connection problems]

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Josh Berkus" <josh(at)agliodbs(dot)com>
Cc: rnathan_tg(at)bigfoot(dot)com, pgsql novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: [Fwd: Re: pgaccess connection problems]
Date: 2002-01-29 23:57:26
Message-ID: 19436.1012348646@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

"Josh Berkus" <josh(at)agliodbs(dot)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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Frank Bax 2002-01-30 01:21:04 Re: text field
Previous Message Josh Berkus 2002-01-29 22:47:39 Re: [Fwd: Re: pgaccess connection problems]