wiki.server17.net

User Tools

Site Tools

Trace:
myhelp:sql

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

myhelp:sql [2026/04/09 08:36] – created - external edit 127.0.0.1myhelp:sql [2026/07/22 11:04] (current) – [Enable remote connections] ulrich
Line 60: Line 60:
  
 ===== Enable remote connections ===== ===== Enable remote connections =====
-  - Find your postgresql.conf <code>sudo -u postgres psql -c "SHOW config_file;" </code>+  - Find your postgresql.conf:  <code>sudo -u postgres psql -c "SHOW config_file;" </code> 
 +  - Find your pg_hba.conf: <code>sudo -u postgres psql -tAc "SHOW hba_file;"</code>
   - Open the postgresql.conf  (/var/lib/pgsql/18/data/postgresql.conf) <code>#listen_addresses = 'localhost'   - Open the postgresql.conf  (/var/lib/pgsql/18/data/postgresql.conf) <code>#listen_addresses = 'localhost'
 listen_addresses = '*' # OR a specific IP instead of the wildcard for all IPs</code> listen_addresses = '*' # OR a specific IP instead of the wildcard for all IPs</code>
myhelp/sql.txt · Last modified: by ulrich