User Tools

Site Tools


dev:kb:database:postgresql

PostgreSQL

Enable PostgreSQL 8+ remote access without password

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
dev/kb/database/postgresql.txt · Last modified: 2020/06/06 23:32 by 127.0.0.1