Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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


pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group