Differences

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

--- dev:kb:database:postgresql [2014/05/01 10:15] – created hackerzhou
+++ dev:kb:database:postgresql [2020/06/06 23:32] (current) – external edit 127.0.0.1
@@ Line 1: / Line 1: @@
 ====== PostgreSQL ======
-==== Enable PostgreSQL remote access without password ====
+==== Enable PostgreSQL 8+ remote access without password ====
+<code bash>
+cat >> $PGSQL_DATA/pg_hba.conf <<EOF
+host all all 0/0 trust
+EOF
+sed -i "s|.*listen_addresses.*|listen_addresses = '*'|" $PGSQL_DATA/postgresql.conf
+# Add following rule to iptables if needed.
+iptables -A INPUT -p tcp --dport 5432 -j ACCEPT
+</code>