Install PostgreSQL on Ubuntu 22.04
https://pupli.net/2022/07/install-postgresql-on-ubuntu-22-04/
PostgreSQL TRUNCATE TABLE
https://pupli.net/2022/12/postgresql-truncate-table/
Restore a postgres backup file using the command line
https://pupli.net/2023/01/restore-a-postgres-backup-file-using-the-command-line/