Difference between revisions of "PostgreSQL"
From Briki
| Line 19: | Line 19: | ||
== Starting an interactive session == | == Starting an interactive session == | ||
| − | psql <dbname> | + | sudo -u postgres psql <dbname> |
| + | |||
| + | == Useful Commands == | ||
| + | * List all databases: | ||
| + | \list | ||
Latest revision as of 12:35, 12 May 2020
Contents
Creating a DB
sudo -u postgres createdb <dbname>
Creating a role
Note that in postgres all access is managed by "roles", there is no concept of users or groups (though for historical purposes users and roles can be thought of as largely interchangeable).
Without a password:
sudo -u postgres createuser <username>
With a password:
sudo -u postgres createuser <username> -P
Authentication
Local Users
By default (defined in `/etc/postgresql/11/main/pg_hba.conf`), local users can authenticate without needing a password into a role with the same name as their username.
Remote Users
Remote users (including those connecting from other docker containers) can only connect as roles with passwords defined.
Starting an interactive session
sudo -u postgres psql <dbname>
Useful Commands
- List all databases:
\list
