#MAC RESTART POSTGRES INSTALL#
To install version we need we can just run install command (in our case for version brew install will see the output like this: => Downloading downloaded: Pouring Caveatsīrew is keg-only, which means it was not symlinked into /usr/local,īecause this is an alternate version of another formula. Homebrew/cask/navicat-for-postgresql homebrew/cask/photo-supreme-postgresql 2.2. You will see the output like this: => Formulae To get the list of available versions of PostgreSQL in a brew, we can simply run: brew search postgresql LIBS = -lpgcommon -lpgport -lxslt -lxml2 -lpam -lssl -lcrypto -lgssapi_krb5 -lz -lreadline -lm LDFLAGS = -L/usr/local/opt/openssl/lib -L/usr/local/opt/readline/lib -Wl,-dead_strip_dylibs PGXS = /usr/local/lib/postgresql/pgxs/src/makefiles/pgxs.mkĬONFIGURE = '-disable-debug' '-prefix=/usr/local/Cellar/postgresql/11.2' '-datadir=/usr/local/share/postgresql' '-libdir=/usr/local/lib' '-sysconfdir=/usr/local/etc' '-docdir=/usr/local/Cellar/postgresql/11.2/share/doc/postgresql' '-enable-thread-safety' '-with-bonjour' '-with-gssapi' '-with-icu' '-with-ldap' '-with-libxml' '-with-libxslt' '-with-openssl' '-with-pam' '-with-perl' '-with-uuid=e2fs' '-with-tcl' '-with-tclconfig=/Applications/Xcode.app/Contents/Developer/Platforms/atform/Developer/SDKs/MacOSX10.14.sdk/System/Library/Frameworks/Tcl.framework' 'CC=clang' 'LDFLAGS=-L/usr/local/opt/openssl/lib -L/usr/local/opt/readline/lib' 'CPPFLAGS=-I/usr/local/opt/openssl/include -I/usr/local/opt/readline/include' 'CXX=clang++' 'PKG_CONFIG_PATH=/usr/local/opt/icu4c/lib/pkgconfig:/usr/local/opt/openssl/lib/pkgconfig:/usr/local/opt/readline/lib/pkgconfig' 'PKG_CONFIG_LIBDIR=/usr/lib/pkgconfig:/usr/local/Homebrew/Library/Homebrew/os/mac/pkgconfig/10.14'ĬPPFLAGS = -I/usr/local/Cellar/icu4c/63.1/include -isysroot /Applications/Xcode.app/Contents/Developer/Platforms/atform/Developer/SDKs/MacOSX10.14.sdk -I/usr/local/opt/openssl/include -I/usr/local/opt/readline/include -I/Applications/Xcode.app/Contents/Developer/Platforms/atform/Developer/SDKs/MacOSX10.14.sdk/usr/include/libxml2ĬFLAGS = -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -Wno-unused-command-line-argument -O2 MANDIR = /usr/local/Cellar/postgresql/11.2/share/man LOCALEDIR = /usr/local/Cellar/postgresql/11.2/share/locale INCLUDEDIR-SERVER = /usr/local/Cellar/postgresql/11.2/include/server PKGINCLUDEDIR = /usr/local/Cellar/postgresql/11.2/include
INCLUDEDIR = /usr/local/Cellar/postgresql/11.2/include HTMLDIR = /usr/local/Cellar/postgresql/11.2/share/doc/postgresql You will get output like this: BINDIR = /usr/local/Cellar/postgresql/11.2/binĭOCDIR = /usr/local/Cellar/postgresql/11.2/share/doc/postgresql PostgreSQL has specific command to get config details: pg_config To connect to PostgreSQL using command line, just type: psql postgres 1.4. 22:55:06.655 EEST LOG: database system is ready to accept connections 22:55:06.649 EEST LOG: database system was shut down at 22:55:02 EEST Now you can start PostgreSQL Server with command: pg-start waiting for server to start. Open current user’s bash profile: nano ~/.bash_profileĪdd following line to the end of the file: alias pg-start='brew services start postgresql'Īlias pg-stop='brew services stop postgresql'Īlias pg-restart='brew services restart postgresql'Īlias pg-status='pg_ctl -D /usr/local/var/postgres status' We can avoid using long commands to start, stop or restart postgresql service can create aliases in our user’s. You will get output like this: => Downloading If you ok with with that version than can install it with command: brew install postgresql In line #1 you can see version number: stable 11.2 and this is what we looked for. Or, if you don't want/need a background service you can just run: To have launchd start postgresql now and restart at login: To migrate existing data from a previous major version of PostgreSQL run: Postgres-xc (because postgresql and postgres-xc install the same binaries.) You will get output like this (valid for April 2019): postgresql: stable 11.2 (bottled), HEAD To check the version, we just need to run: brew info postgresql Check what is the latest version available
0 kommentar(er)
