How to Configure PostgreSQL Server

[aaron]

   

   

Configure your PostgreSQL server to allow other systems to access the database remotely. To do so, let the server listen to all IP addresses by editing the configuration file.

   

Before proceeding, use the exit command to quit the PostgreSQL shell and return as the regular system user. Then, follow these steps:

   

       
1. Open the configuration file using a text editor. Replace vim if you use another editor and change the directory accordingly:
       

vim /etc/postgresql/14/main/postgresql.conf

       
2. Find the listen_addresses line.
       
3. Remove the # symbol and change the value to an asterisk. Here’s how it should look:
       

listen_addresses = '*'

       
4. Use the :wq command to save the changes and quit vim.
       
5. Set the access policy to authenticate client connection to your PostgreSQL server. To do so, open the pg_hba.conf file in the same directory using vim. The command should look like this:
       

vim /etc/postgresql/14/main/pg_hba.conf

       
6. Add a new policy at the bottom of the file using this syntax:
       

connection database user ip_address encryption

       
7. For instance, we will enable all TCP/IP connections from all users to every PostgreSQL database. These users can use any IP address with an MD5-encrypted password. The rule looks as follows:
       

host all all 0.0.0.0/0 md5

       
8. Restart the PostgreSQL service to apply the changes.
   

   

    Join ellohost