Thread: Not connect to server!
Hello! Well, i just try to connect to server, but without successfull! the error is "Is the server running on host "172.22.0.23" and accepting TCP/IP Connections on port 5432?" Just look documentation and follow the steps and the error continue! Please, help me! its urgent! Regards, Amauri Pimenta Junior Consultor BI Softtek Brasil Batera banda Riffy
On Thu, 2004-12-30 at 07:46, Amauri Pimenta wrote: > Hello! > > Well, i just try to connect to server, but without successfull! > > the error is "Is the server running on host "172.22.0.23" and > accepting TCP/IP Connections on port 5432?" > > Just look documentation and follow the steps and the error continue! > > Please, help me! its urgent! Are you starting your database with pg_ctl or by typing postmaster by hand? If you're using pg_ctl, edit your $PGDATA/postgresql.conf file to have tcpip_socket = true, and edit $PGDATA/pg_hba.conf to allow your machine to connect. Look for a line that looks like this: host all all 127.0.0.1 255.255.255.0 trust and edit accordingly, then restart your server. If you're starting postmaster by hand, I'd recommend switching to using pg_ctl. Generally running postmaster by hand is done by people more expert at running postgresql than folks not sure why they can't get TCP/IP connections to work. :)
On Dec 30, 2004, at 8:46 AM, Amauri Pimenta wrote: > Hello! > > Well, i just try to connect to server, but without successfull! > > the error is "Is the server running on host "172.22.0.23" and > accepting TCP/IP Connections on port 5432?" First, check for a listening port: netstat -vant | grep 5432 If you don't get any responses, then you'll probably need to edit your postgresql.conf: tcpip_socket = true Mine is located at /var/lib/pgsql/data/postgresql.conf, your location may vary. Then do a pg_ctl reload to effect the changes. Hope this helps! -- Jason Dixon DixonGroup Consulting http://www.dixongroup.net
Hey Guys, I am total novice at the postgresql( hehehhe) Had changed config files, but the error continue! The files are atached. Please, help me! =) I use a version 8.0.0 Thanks a lot! Amauri Junior On Thu, 30 Dec 2004 09:35:02 -0500, Jason Dixon <jason@dixongroup.net> wrote: > On Dec 30, 2004, at 8:46 AM, Amauri Pimenta wrote: > > > Hello! > > > > Well, i just try to connect to server, but without successfull! > > > > the error is "Is the server running on host "172.22.0.23" and > > accepting TCP/IP Connections on port 5432?" > > First, check for a listening port: > > netstat -vant | grep 5432 > > If you don't get any responses, then you'll probably need to edit your > postgresql.conf: > > tcpip_socket = true > > Mine is located at /var/lib/pgsql/data/postgresql.conf, your location > may vary. Then do a pg_ctl reload to effect the changes. Hope this > helps! > > -- > Jason Dixon > DixonGroup Consulting > http://www.dixongroup.net > > -- Amauri Pimenta Junior Consultor BI Softtek Brasil Batera banda Riffy
Attachment
You need to restart your server after the changes. If you're not sure how to do that: su - postgres (from the root account usually) pg_ctl restart On Thu, 2004-12-30 at 10:05, Amauri Pimenta wrote: > Hey Guys, > > I am total novice at the postgresql( hehehhe) > > Had changed config files, but the error continue! > > The files are atached. Please, help me! =) > > I use a version 8.0.0 > > Thanks a lot! > > Amauri Junior > > > On Thu, 30 Dec 2004 09:35:02 -0500, Jason Dixon <jason@dixongroup.net> wrote: > > On Dec 30, 2004, at 8:46 AM, Amauri Pimenta wrote: > > > > > Hello! > > > > > > Well, i just try to connect to server, but without successfull! > > > > > > the error is "Is the server running on host "172.22.0.23" and > > > accepting TCP/IP Connections on port 5432?" > > > > First, check for a listening port: > > > > netstat -vant | grep 5432 > > > > If you don't get any responses, then you'll probably need to edit your > > postgresql.conf: > > > > tcpip_socket = true > > > > Mine is located at /var/lib/pgsql/data/postgresql.conf, your location > > may vary. Then do a pg_ctl reload to effect the changes. Hope this > > helps! > > > > -- > > Jason Dixon > > DixonGroup Consulting > > http://www.dixongroup.net > > > > >