Difference between revisions of "Brew install postgresql@15"
Jump to navigation
Jump to search
| Line 2: | Line 2: | ||
[[brew install postgresql]]@15 | [[brew install postgresql]]@15 | ||
| + | <pre> | ||
| + | ==> Caveats | ||
| + | ==> postgresql@15 | ||
| + | This formula has created a default database cluster with: | ||
| + | initdb --locale=C -E UTF-8 /Users/user/brew/var/postgresql@15 | ||
| + | For more details, read: | ||
| + | https://www.postgresql.org/docs/15/app-initdb.html | ||
| + | |||
| + | postgresql@15 is keg-only, which means it was not symlinked into /Users/user/brew, | ||
| + | because this is an alternate version of another formula. | ||
| + | |||
| + | If you need to have postgresql@15 first in your PATH, run: | ||
| + | echo 'export PATH="/Users/user/brew/opt/postgresql@15/bin:$PATH"' >> ~/.zshrc | ||
| + | |||
| + | For compilers to find postgresql@15 you may need to set: | ||
| + | export LDFLAGS="-L/Users/user/brew/opt/postgresql@15/lib" | ||
| + | export CPPFLAGS="-I/Users/user/brew/opt/postgresql@15/include" | ||
| + | |||
| + | For pkg-config to find postgresql@15 you may need to set: | ||
| + | export PKG_CONFIG_PATH="/Users/user/brew/opt/postgresql@15/lib/pkgconfig" | ||
| + | |||
| + | |||
| + | To restart postgresql@15 after an upgrade: | ||
| + | brew services restart postgresql@15 | ||
| + | Or, if you don't want/need a background service you can just run: | ||
| + | /Users/user/brew/opt/postgresql@15/bin/postgres -D /Users/user/brew/var/postgresql@15 | ||
| + | </pre> | ||
Revision as of 10:55, 14 February 2023
brew install postgresql@15
==> Caveats ==> postgresql@15 This formula has created a default database cluster with: initdb --locale=C -E UTF-8 /Users/user/brew/var/postgresql@15 For more details, read: https://www.postgresql.org/docs/15/app-initdb.html postgresql@15 is keg-only, which means it was not symlinked into /Users/user/brew, because this is an alternate version of another formula. If you need to have postgresql@15 first in your PATH, run: echo 'export PATH="/Users/user/brew/opt/postgresql@15/bin:$PATH"' >> ~/.zshrc For compilers to find postgresql@15 you may need to set: export LDFLAGS="-L/Users/user/brew/opt/postgresql@15/lib" export CPPFLAGS="-I/Users/user/brew/opt/postgresql@15/include" For pkg-config to find postgresql@15 you may need to set: export PKG_CONFIG_PATH="/Users/user/brew/opt/postgresql@15/lib/pkgconfig" To restart postgresql@15 after an upgrade: brew services restart postgresql@15 Or, if you don't want/need a background service you can just run: /Users/user/brew/opt/postgresql@15/bin/postgres -D /Users/user/brew/var/postgresql@15
To connect:
Errors
psql psql: error: connection to server on socket "/tmp/.s.PGSQL.5432" failed: FATAL: database "xxxx" does not exist
Related
See also
- PostgreSQL:
psql,.psqlrc, .pgpass,$HOME/.pg service.conf,-U, -W, -d, meta-commands:\du, \dg, \ddp, \dp, \list, \dn, \dt, \c, \l, \di, \q,show users,show,su - postgres,psql -c, \?, \connect, \conninfo,--version, --help, PL/pgSQL - PostgreSQL:
pg_dump, pg_restore,pgAdmin, pg_config, psql, pg_ctl, pg_isready, initdb, Role, Schema, DBeaver, Navicat, DataGrip, OmniDB,Adminer, docker-compose.xml PostgreSQL, PostgreSQL version, PostgreSQL logs,postgresql.conf,pg_hba.conf, $HOME/.pg_service.conf, Create database (PostgreSQL), Create user,createdb,GRANT,pg_stat, PostgreSQL VACUUM, EXPLAIN,pg stat activity, Autovacuum, ALTER DATABASE, PostgreSQL statistics collector, Shared buffers, EXPLAIN (PostgreSQL),EXPLAIN ANALYZE, Bitmap scan,EXPLAIN VERBOSE,EXPLAIN VERBOSE (PostgresSQL),WAL,ALTER USER,CREATE ROLE, CREATE USER,\du,show users,\l, The Statistics Collector, pganalyze,cron.schedule, Master,pg_tables, PostgreSQL replication,CREATE, SET, TOAST, PgBouncer, Restore DB, Index, meta-commands, Table, foreign table, Schema, Sequence, Views, materialized view, Table Partitioning, monitoring, PostgreSQL System Administration Functions, PostgreSQL extension, privileges, logging, PGTune, PostgreSQL parameter tunning, PostgreSQL modules, pgbench, PostgreSQL users, catalogs
Advertising:
