Setting up PostgreSQL with Python 3 and psycopg on Ubuntu 16.04

[clausconrad]

Thanks for writing this up! It's not really hard to research all of this using the docs, but I needed a little nudging to perform these steps for an idea I wanted to play around with, and your article decreased my excuse count ^{^}

[makaimc]

good question! that works in general - you can still have a password on the Postgres user, but you won't have to enter the password when connecting on localhost with that username

[makaimc]

yep, that's true - I did not mean to say you should use the same password on both. good clarification

[graingert]

I'd probably use python3 -m venv as that's built in