From: | Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk> |
---|---|
To: | davidburcaa(at)gmail(dot)com |
Cc: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
Subject: | Re: BUG #16017: Postgres does not respond non-local connections |
Date: | 2019-09-22 20:14:50 |
Message-ID: | 87y2ygnlbu.fsf@news-spur.riddles.org.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
>>>>> "PG" == PG Bug reporting form <noreply(at)postgresql(dot)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)
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2019-09-22 21:47:49 | Re: BUG #16013: Unexpected results from bit field query |
Previous Message | Jeff Janes | 2019-09-22 19:53:08 | Re: citext LIKE search bug |