![]() Go into the new created folder and run the cofigure script with the desired options. SEGSIZE must be a power of 2 between 1 and 64.-with-wal-segsize=SEGSIZE set size of WAL-Segment size in MB.BLOCKSIZE must a power of 2 and between 1 and 32.-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 > 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. How to install PostgreSQL via MacPorts on OSX
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |