PostgreSQL: Difference between revisions
No edit summary |
(→Users) |
||
Line 14: | Line 14: | ||
==Users== | ==Users== | ||
<syntaxhighlight lang="postgres"> | <syntaxhighlight lang="postgres"> | ||
# Create user | |||
CREATE USER myuser WITH ENCRYPTED PASSWORD 'mypass'; | CREATE USER myuser WITH ENCRYPTED PASSWORD 'mypass'; | ||
ALTER USER | |||
# Give superuser | |||
ALTER USER myuser WITH SUPERUSER; | |||
</syntaxhighlight> | </syntaxhighlight> |
Revision as of 16:12, 29 March 2021
Installation
Upgrading
See [1]
- Backup old postgres cluster
sudo su postgres
psql_dumpall > export.sql
- Install new postgresql version
sudo apt install postgresql-13
- Migrate database and configuration files
- Remove and cleanup old postgresql files
Users
# Create user
CREATE USER myuser WITH ENCRYPTED PASSWORD 'mypass';
# Give superuser
ALTER USER myuser WITH SUPERUSER;