PostgreSQL/admin

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
< PostgreSQL
Revision as of 00:22, 8 November 2022 by Woozle (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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;