PostgreSQL

• PostgreSQL Servers
• Add Remote PgSQL Server
• PostgreSQL Root Password

PostgreSQL Servers

To Manage PostgreSQL Database Servers

This page will show all PgSQL database servers configured in your Eenos hosting control panel.

PostgreSQL -> PostgreSQL Servers

You can manage the local  PgSQL server and remote  PgSQL servers from Eenos.

The local PgSQL servers can be restarted and disable.

If the database server is disabled , users can't create databases on this server.

The remote PgSQL servers can restart  ,  disable , Edit settings, and Delete

Deleting a remote PgSQL server will only delete the server from Eenos. It doesn't delete the databases.

Add Remote PgSQL Server

To add a remote PgSQL Server

You can add unlimited  number of remote  PgSQL servers to your Eenos hosting control panel.

PostgreSQL -> Add Remote PgSQL Server

We recommend to add a PgSQL 13 or higher compatible version of remote  database servers

Add A New Server

To add a new server you need to fill out the following,

• Remote Host : The remote PgSQL server IP or Host Name to connect.
• Remote PgSQL  User :  The user name to authenticate to the remote  server.
• Remote User Password : The remote pgsql  user password.

Please  make sure the remote user have admin privileges on remote server , so that the user can create  other users and  databases

You may need to white list the remote server IP in firewall and open the PgSQL outgoing port 5432

How to grant remote user privilege ?

Enabling remote access to postgres is easy.  Please follow the steps below,

 Modify the PostgreSQL configuration file

Open the PostgreSQL configuration file “postgresql.conf” using your preferred text editor. 

Example :  /etc/postgresql/13/main/postgresql.conf

Then, find the line #listen_addresses = 'localhost' and uncomment it (remove the # character at the beginning of the line).

Next, change the value of “listen_addresses” to “*”. This allows PostgreSQL to listen on all available IP addresses. Alternatively, you can specify a specific IP address or a range of IP addresses that are allowed to connect to the server.

Modify the pg_hba.conf file

Open the “pg_hba.conf” file using your preferred text editor. 

Example :  /etc/postgresql/13/main/pg_hba.conf

Take the following section:

# IPv4 local connections: 
host    all             all             127.0.0.1/32            md5 

And modify it this way: 

# IPv4 local connections:
host    all             all             0.0.0.0/0            md5 

Restart PostgreSQL

Run the following command to restart PostgreSQL: 

sudo service postgresql restart

After completing these steps, you should be able to connect to the PostgreSQL server from a remote machine using a PostgreSQL client. However, please note that allowing remote access to a PostgreSQL server can bear a security risk, so it is recommended to use secure passwords, encryption, and firewall rules to protect your system.

Please use a strong complicated password for the remote PgSQL user.

PostgreSQL Root Password

Reset PgSQL Administrative Password

This option will help you to reset reset the admin password of Local PgSQL Server

PostgreSQL -> PostgreSQL  Password

To reset the   admin password of PgSQL server click the button Reset PgSQL  Password

The admin panel  generate a complicated random password to reset the password. 

You can only reset the local PgSQL  password,  you can't reset the remote PgSQL  password.