Install
sudo apt install postgresql
Login
sudo -u postgres psql
Restore from backup or sql
sudo -u postgres psql -d batterysizer < leoch_dump_copy.sql
Install PostgreSQL, phpPgAdmin and All Dependencies
1. Install Apache - https://www.osradar.com/how-to-install-lapp-stack-on-ubuntu-20-04/
2. https://www.rosehosting.com/blog/how-to-install-phppgadmin-on-ubuntu-20-04/
or https://www.howtoforge.com/tutorial/ubuntu-postgresql-installation/
PostgreSQL Notes