-with-blocksize=BLOCKSIZE set pagesize in KB.-with-pgport=NUMBER specify a port for your server.-sysconfdir=PATH path for configuration files.-bindir=PATH path for executable programs.-exec-prefix=PATH path for architectur-dependet file.There are a large number of different options for the configuration of PostgreSQL:įull Link to the full installation procedure Now you can extract the source files: tar -xzvf postgresql-9.6.3.tar.gz postgres=#SELECT setting FROM pg_settings WHERE name='data_directory' Īnd you will be back at your shell prompt.Ĭongratulations! You now have a running PostgreSQL instance on OS/X. Here you can type a query to see that the server is running. You will see a prompt from postgres: psql (9.6.1) Verify that we can connect to the server: su postgres -c psql Now we start the server: sudo port load -w postgresql96-server sudo mkdir -p /opt/local/var/db/postgresql96/defaultdb The log provides instructions on the rest of the steps for installation, so we do that next. > Computing dependencies for postgresql96 Sudo su postgres -c '/opt/local/lib/postgresql96/bin/initdb -D /opt/local/var/db/postgresql96/defaultdb' Sudo chown postgres:postgres /opt/local/var/db/postgresql96/defaultdb
Sudo mkdir -p /opt/local/var/db/postgresql96/defaultdb
#Postgresql mac tutorial install#
> Installing postgresql96-server Activating postgresql96-server create a database instance, after install do > Attempting to fetch postgresql96-server-9.6beta2_0.darwin_15.x86_64.tbz2 from > Fetching archive for postgresql96-server > Installing postgresql96 Activating postgresql96 use the postgresql server, install the postgresql96-server port > Attempting to fetch postgresql96-9.6beta2_0.darwin_15.x86_64.tbz2 from > Dependencies to be installed: postgresql96 You will see an installation log like this: -> Computing dependencies for postgresql96-server sudo port install postgresql96-server postgresql96 In this example, the most recent version of PostgreSQL that is supported in 9.6, so we will install that. You should get a list that looks something like the following: postgresql80 databases/postgresql80 Use this command to see what versions you have available. In order to install PostgreSQL on OSX, you need to know which versions are currently supported.
#Postgresql mac tutorial how to#
How to install PostgreSQL via MacPorts on OSX
0 kommentar(er)
