Reply to topic
PostgreSQL?
bobum
Elvis Fanatic
Elvis Fanatic

Joined: 16 Nov 2004
Posts: 746
Location: Montgomery, AL
Post Posted: Tue Feb 01, 2005 7:23 pm Reply with quote
Ok - we're installing a new PostgreSQL server here at work to run SourceForge...I can connect fine when I shell into the Linux box. But I am havin g probs getting into the db via the web. Anyone have any experience with PostgreSQL? Mosre specifically 8.0 and how to get it to listen to TCP/IP sockets instead of just the local Unix socket?

I'm playing with the postgres.conf and pg_hba.conf files now...
PostgreSQL
joe


Joined: 14 Dec 2004
Posts: 4
Location: Newark, Delaware
Post Posted: Fri Feb 04, 2005 3:16 am Reply with quote
You need to set tcpip_socket=true in postgresql.conf. The default listening port should be 5432. I hope this helps!
bobum
Elvis Fanatic
Elvis Fanatic

Joined: 16 Nov 2004
Posts: 746
Location: Montgomery, AL
Post Posted: Fri Feb 04, 2005 5:22 am Reply with quote
It certainly did - I started looking into the TCPIP stuff as you suggested and found that in the latest version of PostgreSQL they have combined all of that into a single "listen_addresses = " line

I made that listen_addresses='*' and it worked like a charm

Thanks!
sql
joe


Joined: 14 Dec 2004
Posts: 4
Location: Newark, Delaware
Post Posted: Fri Feb 11, 2005 3:24 am Reply with quote
No problem. I'm glad I was able to help!
PostgreSQL?
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
 		All times are GMT  
Page 1 of 1  
  
  
 Reply to topic