Skip to content

10_Configure_PostgreSQL_on_your_Mac.md

Latest commit

 

History

History
67 lines (42 loc) · 613 Bytes

10_Configure_PostgreSQL_on_your_Mac.md

File metadata and controls

67 lines (42 loc) · 613 Bytes

Configure PostgreSQL on your Mac

Install and configure PostgreSQL on Mac



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