413vhcu1lq0463ob: /* Edit pg_hba.conf */

2025-02-04T13:27:43Z

Edit pg_hba.conf

← Older revision		Revision as of 13:27, 4 February 2025
Line 20:		Line 20:
	This file defines client authentication rules for connecting to the database.		This file defines client authentication rules for connecting to the database.

	* '''Find and modify the authentication rules''': Open <code>pg_hba.conf</code> (usually in the same directory as <code>postgresql.conf</code>). You’ll see entries similar to the following for local connections:		'''Find and modify the authentication rules''': Open <code>pg_hba.conf</code> (usually in the same directory as <code>postgresql.conf</code>). You’ll see entries similar to the following for local connections:

	IPv4 local connections:		IPv4 local connections:

413vhcu1lq0463ob: Created page with " To configure PostgreSQL to accept connections from hosts other than `localhost`, you'll need to modify two files: # '''`postgresql.conf`''': This file controls various settings related to the PostgreSQL server. # '''`pg_hba.conf`''': This file controls client authentication and permissions (if not configured properly the PostgreSQL instance will accept unauthenticated connections). Here’s how you can configure both: === Edit `p..."`


2025-02-04T13:26:20Z
Created page with " To configure PostgreSQL to accept connections from hosts other than <code>localhost</code>, you'll need to modify two files:  # '''<code>postgresql.conf</code>''': This file controls various settings related to the PostgreSQL server. # '''<code>pg_hba.conf</code>''': This file controls client authentication and permissions (if not configured properly the PostgreSQL instance will accept unauthenticated connections).  Here’s how you can configure both:  === Edit <code>p..."
New page


To configure PostgreSQL to accept connections from hosts other than <code>localhost</code>, you'll need to modify two files:



# '''<code>postgresql.conf</code>''': This file controls various settings related to the PostgreSQL server.

# '''<code>pg_hba.conf</code>''': This file controls client authentication and permissions (if not configured properly the PostgreSQL instance will accept unauthenticated connections).



Here’s how you can configure both:



=== Edit <code>postgresql.conf</code> ===

This file controls how PostgreSQL listens for incoming connections.



* '''Find and edit the <code>listen_addresses</code> setting''':  Open <code>postgresql.conf</code>, typically located in the PostgreSQL data directory (e.g., <code>/var/lib/pgsql/data/</code> or <code>/etc/postgresql/{version}/main/</code> depending on your installation).  Search for <code>listen_addresses</code> (it might be commented out).



 listen_addresses = 'localhost'

Change it to:

 listen_addresses = '*'

This will allow PostgreSQL to listen on all available network interfaces. If you want to restrict it to specific IP addresses, you can replace <code>'*'</code> with a comma-separated list of IP addresses, like <code>listen_addresses = 'localhost,192.168.1.100'</code>.



=== Edit <code>pg_hba.conf</code> ===

This file defines client authentication rules for connecting to the database.



* '''Find and modify the authentication rules''':  Open <code>pg_hba.conf</code> (usually in the same directory as <code>postgresql.conf</code>).  You’ll see entries similar to the following for local connections:



IPv4 local connections:

 host    all             all             127.0.0.1/32            md5

IPv6 local connections:

 host    all             all             ::1/128                 md5

To allow remote connections, add a line for the IP addresses or subnets you want to allow. For example, to allow all IP addresses (not recommended for production, but fine for testing), add:

 host    all             all             0.0.0.0/0               md5

Or to limit it to a specific subnet (e.g., <code>192.168.1.0/24</code>):

 host    all             all             192.168.1.0/24          md5



* Replace <code>md5</code> with other authentication methods if necessary (like <code>password</code> or <code>scram-sha-256</code>).



=== Restart PostgreSQL ===

After making these changes, restart the PostgreSQL service to apply them:

 sudo systemctl restart postgresql

or

 sudo service postgresql restart



=== Check Firewall Settings (if applicable) ===

If your server has a firewall enabled, make sure that the port PostgreSQL uses (by default, port 5432) is open for the IP addresses you want to allow.

Allow remote connections on PostgreSQL - Revision history

413vhcu1lq0463ob: /* Edit pg_hba.conf */