Difference between revisions of "PostgreSQL/admin"
Jump to navigation
Jump to search
(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...") |
|||
| (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;