postgresql server

postgresql server

configuration > server > postgresql-server

important binaries are: database management createdb createuser postgres cli interface psql useful commands:

du   # list users
list # list all databases
dt   # list all tables
dS+  # list schema and size (all tables)

psql -h -U powerdns -d powerdns -a -f schema.pgsql.sql

permissions to connect from outside

this must explicitly be allowed using a pg_hba.conf, which is located under /usr/local/pgsql/data/pg_hba.conf or /etc/postgresql/9.3/main/. This file can be edited like that:

# host    all       all     trust
host    all       all       all              trust

::: {style=“text-align:right”} configuration settings explained :::