Emerging Postgresql...

Talk about anything related to Gentoox or Gentoo.
Post Reply
justquick
Newbie
Posts: 2
Joined: Thu Jun 01, 2006 7:01 am

Emerging Postgresql...

Post by justquick » Thu Jun 01, 2006 7:22 am

Ok I have installed postgresql my ShallaxPro box (using both emerge & make) and everything seems ok. It runs the server sucessfully with no sign of warning and is completely available from psql. When I try to connect to it over the network (which im sure works cause im using ssh) it says that it cant find a connection. I checked netstat on the xbox and sure enough postmaster was not listening for connections. I opened up the permission to fully but nothing works. Is postgresql not ready for the xbox or have i missed something?

orochi
Gentoox Guru!
Posts: 606
Joined: Sun Oct 24, 2004 8:11 am

Post by orochi » Fri Jun 02, 2006 8:29 am

I believe thats because its using sockets and not a port to allow connections to postgresql

you should be able to login via ssh and run 'psql' to administer your service


be sure to checkout
http://gentoo-wiki.com/Special:Search?s ... esql&go=Go

justquick
Newbie
Posts: 2
Joined: Thu Jun 01, 2006 7:01 am

Post by justquick » Sat Jun 03, 2006 7:22 pm

You believe incorrectly, postgresql allows for remote connections through a default port of 5432. This is where I run into problems because when i ssh into my box and use psql it works just fine but when I try to connect remotely to postmaster it cant find the port connection even when my pg_hba.conf is allowing anyone into any database with no passwd. I dont care about security, i just want it to work. Also the firewall is disabled so it cant be that.

orochi
Gentoox Guru!
Posts: 606
Joined: Sun Oct 24, 2004 8:11 am

Post by orochi » Sun Jun 04, 2006 5:44 am

I checked netstat on the xbox and sure enough postmaster was not listening for connections.
you wont be able to remotely access your box untill netstat shows this port

Post Reply

Who is online

Users browsing this forum: No registered users and 2 guests