PostgreSQL
The PostgreSQL server administration tools.
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.