Did you restart postgres? is it listening? (netstat -l)
If yes, is there some firewalling code on the box dropping your packets? Kev. ----- Original Message ----- From: "Johnny Stork" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, February 21, 2003 8:32 AM Subject: Re: (clug-talk) Postgres Gurus? > Found a /var/lib/pgsql/postgresql.conf. No "network" setting but maybe this is it? > > # > # Connection Parameters > # > tcpip_socket = true > #ssl = false > > > Uncommented the tcp_ip line and changed "false" to "true" but still no connection possible? > > > <hr> > <b><font color=blue size=4>Open Enterprise Solutions</font></b> > <b><font color=red>Linux & Open Source Solutions for Business</font></b> > > Johnny Stork, BA > Calgary, AB > Canada > > <a href="http://www.openenterprise.ca";> > www.openenterprise.ca</a> > > ------ original message ------ > From: Kevin Anderson <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Sent: Thu Feb 20 21:24:26 MST 2003 > Subject: Re: (clug-talk) Postgres Gurus? > > There is also a Postgres conf file somewhere (I'll find it tomorrow, and > <br>mail it's location. I think in the same directory as pg_hba.) Anyways, > <br>either the first or second line of the file will be something like > <br> > <br>Network Access = False > <br> > <br>You'll need to change that to true, or it won't listen for a tcp/ip > <br>connection (pgADMIN). > <br> > <br>I set it up a while ago, and haven't needed back in there, so I can't > <br>remember exactly where it all was located. Sorry. Hopefully this'll help > <br>point you in the right direction. > <br> > <br>Kev. > <br> > <br> > <br> > <br> > <br>----- Original Message ----- > <br>From: "Aaron J. Seigo" <[EMAIL PROTECTED]> > <br>To: <[EMAIL PROTECTED]> > <br>Sent: Wednesday, February 19, 2003 9:53 PM > <br>Subject: Re: (clug-talk) Postgres Gurus? > <br> > <br> > <br>> -----BEGIN PGP SIGNED MESSAGE----- > <br>> Hash: SHA1 > <br>> > <br>> On Wednesday 19 February 2003 09:03, Johnny Stork wrote: > <br>> > Here's what I got now Aaron... > <br>> > <br>> i really didn't understand what you wrote. sorry =/ > <br>> > <br>> but auth with pgsql is really quite straightforward. here's two pages that > <br>lay > <br>> it out quite clearly: > <br>> > <br>> > <br><a href="http://candle.pha.pa.us/main/writings/pgsql/sgml/client-authentication .html"target="top">http://candle.pha.pa.us/main/writings/pgsql/sgml/client-a uthentication.html</a> > <br>> <a href="http://candle.pha.pa.us/main/writings/pgsql/sgml/auth-methods.html"tar get="top">http://candle.pha.pa.us/main/writings/pgsql/sgml/auth-methods.html </a> > <br>> > <br>> maybe once you're rested up again given them a read and another go at it. > <br>> > <br>> - -- > <br>> Aaron J. Seigo > <br>> GPG Fingerprint: 8B8B 2209 0C6F 7C47 B1EA EE75 D6B7 2EB1 A7F1 DB43 > <br>> > <br>> KDE: The 'K' is for 'kick ass' > <br>> <a href="http://www.kde.org"target="top";>http://www.kde.org</a> <a href="http://promo.kde.org/3.1/feature_guide.php"target="top";>http://promo.k de.org/3.1/feature_guide.php</a> > <br>> -----BEGIN PGP SIGNATURE----- > <br>> Version: GnuPG v1.2.1 (GNU/Linux) > <br>> > <br>> iD8DBQE+VF871rcusafx20MRApawAJ9pc3Tq/xXzCyMqcXy25HR5q70YYwCcCgHr > <br>> ae6sjOBmS9hlL+ZBiJhB/a4= > <br>> =LcQj > <br>> -----END PGP SIGNATURE----- > <br>> > <br>> > <br>> > <br> > <br> > <br> > > --------------------------------------------------- > The Webtop Personal Web-based Email System > http://www.yourwebtop.com > > >
