0

Install DB Server PosgreSQL postgresql-9.6.1-1-windows-x64.

After Install I change number standard port to 84. In postgresql.conf

port = 84               # 5433 (change requires restart)

I restarted service and new port working.

After I try to connected DB Server by pgAdmin4.

But when I change Connection Port pgAdmin4 wrote ERROR

enter image description here

Can I connected to DB with port less 1024?

4
  • 1
    why you take 2 digit port number? it must be greater than 1024. Nov 25, 2016 at 5:13
  • "* I change number standard port to 84" - why would you do that? What is the reason behind that? Nov 25, 2016 at 6:21
  • I have a small test lab. It has some of the database. test lab allows podklchyuchatsya to them from outside. But the router has a limit on the number of individual records NAT port. Therefore, the connection ports begin with 82. Nov 25, 2016 at 6:32
  • You could file a bug to pgAdmin. This error should be a mere warning. Nov 25, 2016 at 13:03

3 Answers 3

0

Your port number must be greater than 1024, as message printed on your screen. Less than 1024 given error in pgadmin.

2
  • I want to conect DB with 84 number port. pgAdmin4 do not give me such an opportunity? Nov 25, 2016 at 6:27
  • Never give this opportunity because port number must be greater than 1024 Nov 25, 2016 at 6:46
2

There is a very good reason this port restriction should be removed. When using a Platform As A Service (PAAS) that creates endpoints based on services, it is typical to create the service on port 80 or 443 regardless of what is behind the URL. Since this is just a host name, there is no reason why this should be blocked. The landscape is different then the data center level as these services could be spun up at any time. This requirement is arbitrary.

2

You may want to consider manipulating the SQLite DB backing pgAdmin 4, stored e.g. at AppData\Roaming\pgAdmin\pgadmin4.db.

Create your server in pgAdmin with a port > 1024, then via SQLite remove the constraint in the server table on the port column (or change it from "port > 1024..." to "port > 1..."), and then change the value of the port column on the corresponding server line.

Of course, that's a hack and will probably be overridden when you install pgAdmin updates.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.