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/