Install postgres using Homebrew and load the "dvdrental" demo database on Mac OSX

gistfile1.txt

# Install postgres with Homebrew:

brew update
brew install postgres
brew services start postgresql
/usr/local/opt/postgres/bin/createuser -s postgres

# Import the demo database and import it
# Download database: https://www.postgresqltutorial.com/postgresql-sample-database/

unzip ~/Downloads/dvdrental.zip

createdb dvdrental
pg_restore -d dvdrental -U postgres ~/Desktop/dvdrental.tar

# Verify this worked

psql
\l
\c dvdrental
\dt
SELECT * FROM actor LIMIT 10;