Configure PostgreSQL on your Mac

Mac에 PostgreSQL을 설치하고, 설정해요

Install

brew install postgresql

Start

brew services start postgresql

Stop

brew services stop postgres

Restart

brew services restart postgres

Connect

psql postgres

Alter user

createuser postgres --interactive

# make a superuser postgresl
createuser postgres -s

# Change password
alter user postgres with password 'YOUR_PASSWORD';

Upgrade Database

brew postgresql-upgrade-database