blob: 28a00432c14d50e3ed8a2601de1e0b0dced181cb (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
|
# The PostgreSQL DBMS
Default user, db: `postgres`
## User management
Everything should be done as user `postgres`.
New user:
createuser --pwprompt mypguser
Change password:
# in `psql`
ALTER ROLE user WITH PASSWORD 'xxx';
## New database
sudo su postgres
createdb -O mypguser mypgdatabase
# delete db
dropdb mypgdatabase
|