PostgreSQL

Database Installation

If PostgreSQL is installed using homebrew, user postgres is not created as suggested in the StackOverflow comment

cd  /opt/homebrew/Cellar/postgresql@14/14.12/bin/
createuser -s postgres

Database Administration

Start

12-10-2023, source: Database Administrators StackExchange

cd /Library/PostgreSQL/12/
sudo -u postgres pg_ctl start -D /Library/PostgreSQL/12/data

Stop

12-10-2023, source: self

cd /Library/PostgreSQL/12/
sudo -u postgres pg_ctl stop -D /Library/PostgreSQL/12/data