And if you're on a Mac, Postgres.app makes it even easier: https://postgresapp.com/
(PostgreSQL experts: Is there a magic way to sync schema changes and data from a local instance to a production server?)
(PostgreSQL experts: Is there a magic way to sync schema changes and data from a local instance to a production server?)