PostgreSQL/admin: Difference between revisions
from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
Created page with "==Notes== There seems to be some correlation between {{arg|current system user}} and {{arg|Postgres user}}, at least insofar as running <code>psql</code> as pg's superuser ("p..." |
No edit summary |
||
| (One intermediate revision by the same user not shown) | |||
| Line 1: | Line 1: | ||
==Notes== | ==Notes== | ||
There seems to be some correlation between {{arg|current system user}} and {{arg| | There seems to be some correlation between {{arg|current system user}} and {{arg|data engine user}}, at least insofar as running <code>psql</code> as pg's superuser ("postgres" by default) lets you in without a password: | ||
su - postgres -c psql | su - postgres -c psql | ||
To make a user into a superuser: | |||
alter user {{arg|username}} with superuser; | |||
Latest revision as of 00:22, 8 November 2022
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;
