switch to postgres user
sudo -u postgres -i
dump database
pg_dumpall > sql-dump
dump only specific tables
pg_dump --host localhost --port 5432 --username postgres --table oc_blubb dbname > /path/to/file
read file via
psql -f sql-dump
commands for cli:
List Databases:
postgres=# \l
Switch Database:
postgres=# \c nextcloud You are now connected
List tables:
nextcloud=# \dt
analyse tasks:
SELECT * FROM pg_stat_activity;