Re: [QUESTIONS] cannot remote connect to DB

Hope a mention of -i can be added to the error message.

On Wed, 6 May 1998, Klaus Fink wrote:

Hi there,

I have actually a problem with DBD:Pg when connecting to the Postgres
Server. But probably it is mainly a problem with postgres.

I set up pg_hba.conf as
host all 0.0.0.0 0.0.0.0 trust
but still it tells me that the postmaster (which is running) is not
listening.

'netstat -an | grep 5432' returns something weird:
f5b84b78 stream-ord 13 0 /tmp/.s.PGSQL.5432

Has anyone an idea what may be wrong?

Yep, you haven't started the postmaster with -i (which is needed for
tcp/ip networking). the above file is the unix domain socket.

--
Peter T Mount peter@retep.org.uk or petermount@earthling.net
Main Homepage: http://www.retep.org.uk
************ Someday I may rebuild this signature completely ;-) ************
Work Homepage: http://www.maidstone.gov.uk Work EMail: peter@maidstone.gov.uk

--
Official WWW Site: http://www.postgresql.org
Online Docs & FAQ: http://www.postgresql.org/docs
Searchable Lists: http://www.postgresql.org/mhonarc

-- 
Bruce Momjian                          |  830 Blythe Avenue
maillist@candle.pha.pa.us              |  Drexel Hill, Pennsylvania 19026
  +  If your life is a hard drive,     |  (610) 353-9879(w)
  +  Christ can be your backup.        |  (610) 853-3000(h)