PostgreSQL/admin

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
Jump to navigation Jump to search

Notes

There seems to be some correlation between <current system user> and <data engine user>, at least insofar as running psql as pg's superuser ("postgres" by default) lets you in without a password:

su - postgres -c psql

To make a user into a superuser:

alter user <username> with superuser;