Unable to add PostgreSQL server to Plesk: A database server with this combination of host address and port number is already registered

Follow

Comments

5 comments

  • Avatar
    Evert Jan Hooijer

    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

    0
    Comment actions Permalink
  • Avatar
    Alisa Kasyanova

    @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.

    0
    Comment actions Permalink
  • Avatar
    Evert Jan Hooijer

    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 

    0
    Comment actions Permalink
  • Avatar
    Ivan Postnikov

    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/

    0
    Comment actions Permalink
  • Avatar
    JLM Lankhorst (Edited )

    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.

    0
    Comment actions Permalink

Please sign in to leave a comment.

Have more questions? Submit a request