Home » Install PostGres on Mac

Install PostGres on Mac

Steps to install PostGres on Big Sur [LINK]

brew uninstall postgres brew install postgres # AUTOSTART brew services start postgresql # SET PASSWORD cd ~/ sudo -u postgres psql -c "ALTER USER postgres PASSWORD 'postgres';" psql -U postgres
Code language: Shell Session (shell)

LOG of BREW INSTALL

==> Caveats To migrate existing data from a previous major version of PostgreSQL run: brew postgresql-upgrade-database This formula has created a default database cluster with: initdb --locale=C -E UTF-8 /usr/local/var/postgres For more details, read: https://www.postgresql.org/docs/13/app-initdb.html To have launchd start postgresql now and restart at login: brew services start postgresql Or, if you don't want/need a background service you can just run: pg_ctl -D /usr/local/var/postgres start ==> Summary 🍺 /usr/local/Cellar/postgresql/13.1: 3,217 files, 42.6MB ==> Caveats ==> krb5 krb5 is keg-only, which means it was not symlinked into /usr/local, because macOS already provides this software and installing another version in parallel can cause all kinds of trouble. If you need to have krb5 first in your PATH, run: echo 'export PATH="/usr/local/opt/krb5/bin:$PATH"' >> ~/.zshrc echo 'export PATH="/usr/local/opt/krb5/sbin:$PATH"' >> ~/.zshrc For compilers to find krb5 you may need to set: export LDFLAGS="-L/usr/local/opt/krb5/lib" export CPPFLAGS="-I/usr/local/opt/krb5/include" ==> postgresql To migrate existing data from a previous major version of PostgreSQL run: brew postgresql-upgrade-database This formula has created a default database cluster with: initdb --locale=C -E UTF-8 /usr/local/var/postgres For more details, read: https://www.postgresql.org/docs/13/app-initdb.html To have launchd start postgresql now and restart at login: brew services start postgresql Or, if you don't want/need a background service you can just run: pg_ctl -D /usr/local/var/postgres start
Code language: Smali (smali)