Question Managing postgres database from my computer

[Korpin]

Server operating system version

Ubuntu

Plesk version and microupdate number

Obsidian 18.0.55

Good morning,

I have configured a Postgress database and would now like to configure it remotely, from my machine.
From the site, it's localhost:5432 (classic), but when I try remotely from my machine, I put the server's IP address as well as port 5432 but no way to connect.

I have also tried to activate pgMyAdmin but I can't find it, is it normal (i have the Developer pack and a linux server)?

Is there anything special I need to do (remote host authorization is already enabled)?

 

[Peter Debik]

Have you already seen this article?

All About PostgreSQL Remote Access Under Plesk – Full Guide

PostgreSQL is a powerful, open-source object-relational database system that utilizes and adds to the SQL language. Learn how to use remote access.

www.plesk.com

If you basically configured all correctly and are still unable to reach the database, the port is probably blocked. It can be blocked by a firewall in your local router, the firewall on your server or a firewall in your data center that sits in front of your server.

 

[Korpin]

Have you already seen this article?

All About PostgreSQL Remote Access Under Plesk – Full Guide

PostgreSQL is a powerful, open-source object-relational database system that utilizes and adds to the SQL language. Learn how to use remote access.

www.plesk.com

If you basically configured all correctly and are still unable to reach the database, the port is probably blocked. It can be blocked by a firewall in your local router, the firewall on your server or a firewall in your data center that sits in front of your server.

Thanks a lot for the article.

Sadly, I don't have the directory 'pgsql' so I can't edit the postgresql.conf file.

 

[Korpin]

Thanks a lot for the article.

Sadly, I don't have the directory 'pgsql' so I can't edit the postgresql.conf file.

Ok, the command was for CentOS and I'm on Ubuntu, I found the file