Add Remote PgSQL Server

To add a remote MySQLPgSQL Server

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

MySQLPostgreSQL -> Add Remote MySQLPgSQL Server

We recommend to add a MySQLPgSQL 813 or higher compatible version of remote  database servers

You can add the MySQL  Community server, MariaDB server and Percona MySQL servers to the server pool.

Add A New Server

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

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

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

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

How to grant remote user privilege ?

YouEnabling needremote access to performpostgres is easy.  Please follow the GRANTsteps ALLbelow,

PRIVILEGES

 queryModify 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 theall remoteavailable mysqlIP serveraddresses. toAlternatively, allowyou yourcan specify Eenosa serverspecific IP address or a range of IP addresses that are allowed to connect to the remoteserver.

database.

Modify Anthe Examplepg_hba.conf isfile

given

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

YourExample Eenos: server IP is, 10.0.0.10/etc/postgresql/13/main/pg_hba.conf

Remote server  user is , root

Remote mysql password is , changethis

Please  runTake the following query in remote MySQL server:section:

GRANT# ALLIPv4 PRIVILEGESlocal ONconnections: 
*.*host    TOall             'root'@'10.all             127.0.0.10'1/32            IDENTIFIEDmd5 BY 'changethis';

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 MySQLPgSQL user.