Applicable to:
- Plesk for Linux
Symptoms
-
When trying to add a new PostgreSQL server at Tools & Settings > Database Servers and specifying the option Host name or IP address as localhost and leaving the Port number field blank, the following error is shown after clicking OK:
PLESK_ERROR: Error: A database server with this combination of host address and port number is already registered.
-
PostgreSQL is installed on a server with Plesk using instructions from the PostgreSQL official wiki.
Cause
Record about PostgreSQL server with the hostname
localhost
and port 5432 already exists in the Plesk system database
psa.
This is a Plesk bug with ID PPPM-6955, which is planned to be fixed in future Plesk updates.
Resolution
Until a fix becomes available, add a new PostgreSQL server specifying 127.0.0.1 as a Host name or IP address.
Comments
5 comments
Dear ......
I tried this but the i have another problem: Error:
The test connection to the database server has failed because of network problems:
pg_connect(): Unable to connect to PostgreSQL server: could not connect to server: Connection refused
Is the server running on host "127.0.0.1" and accepting
TCP/IP connections on port 5432?
So what can i do too installe Postgresql in plesk??
Greetings
Evert Jan Hooijer
@Evert Jan Hooijer
Please check whether PostgeSQL is listening on port 5432:
netstat -tln | grep 5432
If you use Plesk Firewall, check if there are rules that are blocking port 5432 in Tools & Settings > Firewall.
Dear Alisa Kasyanova,
Thank you for your quick reaction, but i think that the firewall is not the problem?? Look too the 2 screenshots. So what can ik do too work with postgress? Greetings from Evert Jan Hooijer
Hello @Evert Jan Hooijer,
When performing the command "netstat -tln | grep 5432" you have missed the pipe ("|") sign and the output you got is the output of the command "netstat -tln", which gives info about all ports.
The screenshot is very small but from what I see PostgreSQL is not listening to the port 5432. The most probable cause that PostgreSQL is not started or fails to start due to errors in configuration. For support of PostgreSQL configuration, please, contact https://www.postgresql.org/support/
Hi Evert Jan Hooijer, I had the same problem. Simple issue. Check your services. First you see that PostgreSQL isn't active. That's because you've first to install PostgreSQL via plesk update. When you have installed PostgreSQL succesfully you have to setup a username/ password. After you've done that you can start the PostgreSQL service
It is a bit misleading. Because in a fresh plesk installation you've already the possibility to add a new PostgreSQL server instance without any function/ programm behind. Tip for plesk: better/ user friendly would be that you have not the possiblity until PostgreSQL is succesfully installed.
Please sign in to leave a comment.