Re: BUG #16017: Postgres does not respond non-local connections - Mailing list pgsql-bugs

From Andrew Gierth
Subject Re: BUG #16017: Postgres does not respond non-local connections
Date
Msg-id 87y2ygnlbu.fsf@news-spur.riddles.org.uk
Whole thread Raw
In response to BUG #16017: Postgres does not respond non-local connections  (PG Bug reporting form <noreply@postgresql.org>)
List pgsql-bugs
>>>>> "PG" == PG Bug reporting form <noreply@postgresql.org> writes:

 PG> (Note that I have already looked through the pg_hba.conf.sample and
 PG> the postgres.conf.sample (I'm not exactly sure why they're named
 PG> .sample, Ill just leave is as-is for now) and changed the settings
 PG> so that they would accept non-local connections.

The .sample files are badly named. They aren't samples, and you're not
expected to edit them (though you can if you know what you're doing);
what they really are is _templates_, which initdb uses to create the
real postgresql.conf and pg_hba.conf files. Nothing reads them except
initdb.

To actually enable remote connections, you need to edit the
listen_addresses setting in postgresql.conf (not .sample) for the
running server and restart it. Connecting locally and doing
"SHOW config_file;" should tell you where to find it.

-- 
Andrew (irc:RhodiumToad)



pgsql-bugs by date:

Previous
From: Jeff Janes
Date:
Subject: Re: citext LIKE search bug
Next
From: Tom Lane
Date:
Subject: Re: BUG #16013: Unexpected results from bit field query