Skip to content

Instantly share code, notes, and snippets.

@dhbradshaw

dhbradshaw/postgres-windows.md

Last active April 21, 2022 19:08
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save dhbradshaw/e51107baa7d13522256a2d4afddcee92 to your computer and use it in GitHub Desktop.
Save dhbradshaw/e51107baa7d13522256a2d4afddcee92 to your computer and use it in GitHub Desktop.
Download ZIP
Postgres on WSL (Windows Subsystem for Linux) ubuntu 18.04
Raw
postgres-windows.md

Postgres on WSL (Windows Subsystem for Linux) ubuntu 18.04

Hint: it's not different than running it under ubuntu without Windows.

Add postgres package registry

sudo apt install postgresql-common
sudo sh /usr/share/postgresql-common/pgdg/apt.postgresql.org.sh

Update apt

sudo apt-get update

Install postgres version of your choice

sudo apt-get install postgresql-12

Test it out

Start postgres

sudo /etc/init.d/postgresql start

Connect via psql

sudo -i -u postgres
psql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment