PostgreSQL

Now, postgresql is not really difficult to setup…

I just enabled listening to tcp for a local subnet:

1
2
#host    sameuser    all         127.0.0.1/32          md5
host     all         all         10.0.0.0/8            md5

The administrator is the system user postgres by default, so you just do

1
su postgres

to get a shell with postgresql admin access.

In that shell, you can use commands like createuser, createdb, … to create for example another user with admin access and a real password to use from a phppgadmin instance.

Generated using nanoc and bootstrap - Last content change: 2011-06-10 07:41