<div>look at the pg_hba.conf file. http://www.postgresql.org/docs/8.1/static/client-authentication.html</div>
<div> </div>
<div> </div>
<div>
<br>
<br>
<br>
<br>
----- Original Message -----<br>
Subject: Re: Get postgres to accept network connections<br>
From: "Mark Haney" <mhaney@ercbroadband.org><br>
Date: Fri, July 28, 2006 9:54<br>
<table><tbody><tr><td width="1" bgcolor="#f1c352">
<br></td><td valign="top">
<div class="PrivateMsgDiv">
<pre>-----BEGIN PGP SIGNED MESSAGE-----
<br>Hash: SHA1
<br>
<br>David J. Vernon wrote:
<br><font color="#800000">> On Friday 28 July 2006 11:21, Mark Haney wrote:</font>
<br><font color="#ff0000">>> gpgkeys: key 6108677D1B5CD002 not found on keyserver</font>
<br><font color="#ff0000">>> How do I get postgresql to accept network TCP/IP connections in FC5?</font>
<br><font color="#ff0000">>> There's no postmaster.conf file and no option for that in the</font>
<br><font color="#ff0000">>> postgresql.conf.</font>
<br><font color="#800000">> </font>
<br><font color="#800000">> Any chance you have an iptables rule set enabled? Try connecting again after </font>
<br><font color="#800000">> doing 'service iptables stop'. You can also see what addresses and ports your </font>
<br><font color="#800000">> system is listening on by doing 'netstat -tul'</font>
<br><font color="#800000">> </font>
<br><font color="#800000">> </font>
<br><font color="#800000">> Dave</font>
<br><font color="#800000">> pgp(gpg) 0x2BFEBF88</font>
<br><font color="#800000">> </font>
<br>That's not it, I'm afraid. I have IPtables off on that box since it's
<br>behind a firewall. Here's what I see from a SUSE 9.1 box with
<br>postgresql installed from source:
<br>
<br>tcp 0 0 0.0.0.0:5432 0.0.0.0:* LISTEN
<br>tcp 0 0 :::5432 :::* LISTEN
<br>unix 2 [ ACC ] STREAM LISTENING 1779688
<br>/tmp/.s.PGSQL.5432 LISTEN
<br>
<br>And this is what I see with FC5:
<br>
<br>tcp 0 0 127.0.0.1:5432 0.0.0.0:* LISTEN
<br>unix 2 [ ACC ] STREAM LISTENING 986518 /tmp/.s.PGSQL.5432
<br>
<br>I don't understand.
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>- --
<br>Fere libenter homines id quod volunt credunt.
<br>
<br>Mark Haney
<br>Sr. Systems Administrator
<br>ERC Broadband
<br>(828) 350-2415
<br>-----BEGIN PGP SIGNATURE-----
<br>Version: GnuPG v1.4.4 (GNU/Linux)
<br>Comment: Using GnuPG with Mozilla - <a target="_blank" href="http://enigmail.mozdev.org">http://enigmail.mozdev.org</a>
<br>
<br>iD8DBQFEyjNAYQhnfRtc0AIRAioCAJ9Plw82Zd/no5w9jA7LOHgtdf22vgCfQF01
<br>jr8/IUAUP7/wBpjhuBTi6bg=
<br>=gfpI
<br>-----END PGP SIGNATURE-----
<br>
<br>--
<br>fedora-list mailing list
<br><a href="javascript:bodyCreateMail('fedora-list%40redhat.com')">fedora-list@redhat.com</a>
<br>To unsubscribe: <a target="_blank" href="https://www.redhat.com/mailman/listinfo/fedora-list">https://www.redhat.com/mailman/listinfo/fedora-list</a>
<br>
<br></pre></div></td></tr></tbody></table></div>