====== postgresql ======

<code bash>
su - postgres
vacuumdb --all --full -v
</code>

<code bash>
su - postgres
psql template1
\l
\du
</code>

<code sql>
SELECT rolname FROM pg_roles;

CREATE USER user WITH PASSWORD 'mypass';
GRANT ALL PRIVILEGES ON DATABASE template1 to user;

SELECT rolname FROM pg_roles;
GRANT postgres TO joe;
</code>

<code bash>
# list tables
sudo -u postgres psql -p 5430 -l

# dump table
sudo -u postgres pg_dump -p 5430 -c jiradb | xz > jiradb.sql.xz

sudo -u postgres psql -p 5430 -c 'drop database jiradb'
</code>