Remove old postgres
sudo apt remove --purge postgresql\* -yRemove binary if exist
sudo rm -f /usr/bin/psql
sudo rm -f /usr/share/postgresql-common
sudo rm -rf /usr/lib/postgresqlClear dependencies if exist
sudo apt autoremove -y
sudo apt autocleanwhich psql
which psqlThis should return not found
Install new postgres
sudo apt update
sudo apt install postgresql postgresql-contrib libpq-dev
sudo service postgresql start
psql --versionSet new user and role
sudo -u postgres createuser -s xyborg -Plogin as xyborg
psql -U xyborg -d postgrescreate db
create database liloconnect db
\c lilo