DEV Community

Cover image for Install psql in WSL
DrSimple
DrSimple

Posted on

Install psql in WSL

Remove old postgres

sudo apt remove --purge postgresql\* -y
Enter fullscreen mode Exit fullscreen mode

Remove binary if exist

sudo rm -f /usr/bin/psql
sudo rm -f /usr/share/postgresql-common
sudo rm -rf /usr/lib/postgresql
Enter fullscreen mode Exit fullscreen mode

Clear dependencies if exist

sudo apt autoremove -y
sudo apt autoclean
Enter fullscreen mode Exit fullscreen mode

which psql

which psql
Enter fullscreen mode Exit fullscreen mode

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
Enter fullscreen mode Exit fullscreen mode

Set new user and role

sudo -u postgres createuser -s xyborg -P
Enter fullscreen mode Exit fullscreen mode

login as xyborg

psql -U xyborg -d postgres
Enter fullscreen mode Exit fullscreen mode

create db

create database lilo
Enter fullscreen mode Exit fullscreen mode

connect db

\c lilo
Enter fullscreen mode Exit fullscreen mode

Top comments (0)