Difference between revisions of "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
(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|Postgres user}}, at least insofar as running <code>psql</code> as pg's superuser ("postgres" by default) lets you in without a password:
+
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;