problem connexion server postgre

PostgreSQL is the database server used to store information. Do you have a question or are you having problem with PostgreSQL? If so, post them here.

Moderator: Moderators

problem connexion server postgre

Postby Ludovoyageur » Sat Jul 05, 2008 10:48 am

When i try to connect on the server i have this message :

"Server doen't listen
The server doesn't accept connections : the connection library reports.

could not connect : to server : connection refused (0x0000274D/10061). Is the server running on host "127.0.0.1" and accepting TCP/IP connecions or port 5432 ?

If you encounter this message please check if the server you're trying to contact is actually running Postgre SQL on the given port.
Test if you have network connectivity from your client to the server host using piong or equivalent total. Is your network /UPN/SSH tunnel/ firewall configured correctly ?

For security reasons Postgree SQL dosn't listen on all available Ip addresses on the server over the network, you need toenable listening on the address first.

For Postgre SQL servers starting with version 8.0 thios is controlled using "listen addresses" parameter in the postgresql.conf.file. here you can enter alist on all available IP addresses. For earlier (Version 7.3 or 7.4) you'll need to set "tcpip_socket" parameter to true.

You can use the postgreqlconf editor that is built into pgAdmin III to edit the postgresql.conf configuration file. After changing this file you need to restart process to make the setting effective.

If you double checked your configuration but still get this error message, it's still unlikely that you encounter a fatal PostgreSQL misbehaviour. You probably have some low level connectivity problems (eq firewall configuration). Please heck this thoroughly before reporting a bug to the Postgre SQL community.
.
Ludovoyageur
 
Posts: 4
Joined: Fri Jul 04, 2008 5:29 am

Re: problem connexion server postgre

Postby WhiteRider » Mon Jul 07, 2008 5:45 am

And *is* postgres running?
Try Start -> Programs -> Postgres -> Start Service.
Does that work, does it start?
Or try a reboot?

Have you had PT3 running successfully before?
What O/S do you have?
How did you install postgres?
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK


Return to PostgreSQL [Read Only]

Who is online

Users browsing this forum: No registered users and 0 guests