run postgresql server in the background

sudo service postgresql start

connect to psql

sudo -u postgres psql -d blogator

protocol://username:password@host:port/database

postgres://postgres:postgres@localhost:5432/blogator

goose migration

// up
goose -dir=./sql/schema postgres "postgres://username:password@localhost:5432/your_database" up

// down
goose -dir=./sql/schema postgres "postgres://username:password@localhost:5432/your_database" down