Differences

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

--- myhelp:sql [2026/04/09 08:36] – created - external edit 127.0.0.1
+++ myhelp:sql [2026/07/22 11:04] (current) – [Enable remote connections] ulrich
@@ Line 60: / Line 60: @@
 ===== 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'
 listen_addresses = '*' # OR a specific IP instead of the wildcard for all IPs</code>