Search code examples
postgresqlpgadminpgadmin-4

How to create two localhost servers in pgAdmin?


I already have a local server running with data in the default 5432 port in pgAdmin. I need to create a different local host server to test importing another DB group.

But when I try to create one more server in localhost:5400, I get the following error

Internal server error: unable to connect to server connection to server at "localhost". Port 5400 failed: connection refused to server at "localhost". Is the server running on that host and accepting tcp/ip connections?

But if I use the same port, a serer with all the same data is getting created which may conflict with the import and also confuse me. So I need a totally new server without these data in it.


Solution

  • My guess is what you think is creating a server in pgAdmin is really just creating a connection to a server. That would mean it lets you create a connection to a server you already have on 5432 as many times as you wish (note that's multiple connections to the exact same one), but since there's nothing running on 5400, it fails to connect there, and it doesn't attempt to create one.

    I don't think pgAdmin lets you install a whole new server/cluster/instance. You can create new databases on the one you already have connected to with CREATE DATABASE, but to install a whole new separate server on a different port, you just need to go through the regular install process.

    If you were the one to set up the PostgreSQL server currently running on your port 5432, you can probably repeat the process and just select a different port.