Install psql in WSL

Remove old postgres sudo apt remove --purge postgresql\* -y Remove binary if exist sudo rm -f /usr/bin/psql sudo rm -f /usr/share/postgresql-common sudo rm -rf /usr/lib/postgresql Clear dependencies if exist sudo apt autoremove -y sudo apt autoclean which psql which psql This should return not found Install new postgres sudo apt update sudo apt install postgresql postgresql-contrib libpq-dev sudo service postgresql start psql --version Set new user and role sudo -u postgres createuser -s xyborg -P login as xyborg psql -U xyborg -d postgres create db create database lilo connect db \c lilo

Mar 30, 2025 - 22:46

sudo apt remove --purge postgresql\* -y

sudo rm -f /usr/bin/psql
sudo rm -f /usr/share/postgresql-common
sudo rm -rf /usr/lib/postgresql

sudo apt autoremove -y
sudo apt autoclean

which psql

This should return not found

sudo apt update
sudo apt install postgresql postgresql-contrib libpq-dev
sudo service postgresql start

psql --version

sudo -u postgres createuser -s xyborg -P

psql -U xyborg -d postgres

create database lilo

\c lilo