macos_install_pg_96.txt

$ $ sudo port install postgresql96-server
--->  Computing dependencies for postgresql96-server
The following dependencies will be installed:
 libxml2
 libxslt
 postgresql96
 postgresql_select
Continue? [Y/n]:
--->  Fetching archive for libxml2
--->  Attempting to fetch libxml2-2.9.7_0.darwin_17.x86_64.tbz2 from https://packages.macports.org/libxml2
--->  Attempting to fetch libxml2-2.9.7_0.darwin_17.x86_64.tbz2.rmd160 from https://packages.macports.org/libxml2
--->  Installing libxml2 @2.9.7_0
--->  Activating libxml2 @2.9.7_0
--->  Cleaning libxml2
--->  Fetching archive for libxslt
--->  Attempting to fetch libxslt-1.1.32_0.darwin_17.x86_64.tbz2 from https://packages.macports.org/libxslt
--->  Attempting to fetch libxslt-1.1.32_0.darwin_17.x86_64.tbz2.rmd160 from https://packages.macports.org/libxslt
--->  Installing libxslt @1.1.32_0
--->  Activating libxslt @1.1.32_0
--->  Cleaning libxslt
--->  Fetching archive for postgresql_select
--->  Attempting to fetch postgresql_select-0.3_0.darwin_17.noarch.tbz2 from https://packages.macports.org/postgresql_select
--->  Attempting to fetch postgresql_select-0.3_0.darwin_17.noarch.tbz2.rmd160 from https://packages.macports.org/postgresql_select
--->  Installing postgresql_select @0.3_0
--->  Activating postgresql_select @0.3_0
--->  Cleaning postgresql_select
--->  Fetching archive for postgresql96
--->  Attempting to fetch postgresql96-9.6.10_0.darwin_17.x86_64.tbz2 from https://packages.macports.org/postgresql96
--->  Attempting to fetch postgresql96-9.6.10_0.darwin_17.x86_64.tbz2.rmd160 from https://packages.macports.org/postgresql96
--->  Installing postgresql96 @9.6.10_0
--->  Activating postgresql96 @9.6.10_0
--->  Cleaning postgresql96
--->  Fetching archive for postgresql96-server
--->  Attempting to fetch postgresql96-server-9.6.10_0.darwin_17.noarch.tbz2 from https://packages.macports.org/postgresql96-server
--->  Attempting to fetch postgresql96-server-9.6.10_0.darwin_17.noarch.tbz2.rmd160 from https://packages.macports.org/postgresql96-server
--->  Installing postgresql96-server @9.6.10_0
--->  Activating postgresql96-server @9.6.10_0
--->  Cleaning postgresql96-server
--->  Updating database of binaries
--->  Updating database of C++ stdlib usage
--->  Scanning binaries for linking errors
--->  No broken files found.
--->  No broken ports found.
--->  Some of the ports you installed have notes:
  postgresql96 has the following notes:
    To use the postgresql server, install the postgresql96-server port
  postgresql96-server has the following notes:
    To create a database instance, after install do
     sudo mkdir -p /opt/local/var/db/postgresql96/defaultdb
     sudo chown postgres:postgres /opt/local/var/db/postgresql96/defaultdb
     sudo su postgres -c 'cd /opt/local/var/db/postgresql96 && /opt/local/lib/postgresql96/bin/initdb -D /opt/local/var/db/postgresql96/defaultdb'

    A startup item has been generated that will aid in starting postgresql96-server with launchd. It is disabled by default. Execute the following command to start it, and to cause it to launch at startup:

        sudo port load postgresql96-server
$
$ sudo mkdir -p /opt/local/var/db/postgresql96/defaultdb
$ sudo chown postgres:postgres /opt/local/var/db/postgresql96/defaultdb
$ sudo su postgres -c 'cd /opt/local/var/db/postgresql96 && /opt/local/lib/postgresql96/bin/initdb -D /opt/local/var/db/postgresql96/defaultdb'
The files belonging to this database system will be owned by user "postgres".
This user must also own the server process.

The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".

Data page checksums are disabled.

fixing permissions on existing directory /opt/local/var/db/postgresql96/defaultdb ... ok
creating subdirectories ... ok
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting dynamic shared memory implementation ... posix
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok

WARNING: enabling "trust" authentication for local connections
You can change this by editing pg_hba.conf or using the option -A, or
--auth-local and --auth-host, the next time you run initdb.

Success. You can now start the database server using:

    /opt/local/lib/postgresql96/bin/pg_ctl -D /opt/local/var/db/postgresql96/defaultdb -l logfile start
$
$ sudo su postgres -c '/opt/local/lib/postgresql96/bin/pg_ctl -D /opt/local/var/db/postgresql96/defaultdb -l /opt/local/var/log/postgresql96/postgres.log start &'
server starting
$ sudo -u postgres /opt/local/lib/postgresql96/bin/createuser -d bsnyder
$ sudo -u postgres /opt/local/lib/postgresql96/bin/createdb bsnyder
$ sudo -u postgres /opt/local/lib/postgresql96/bin/psql
postgres=# alter user bsnyder with encrypted password 'bsnyder';
ALTER ROLE
postgres=# grant all privileges on database bsnyder to bsnyder;
GRANT
postgres=# \q
$ /opt/local/lib/postgresql96/bin/psql -U bsnyder
psql (9.6.10)
Type "help" for help.

bsnyder=> select version();
                                                     version
-----------------------------------------------------------------------------------------------------------------
 PostgreSQL 9.6.10 on x86_64-apple-darwin17.7.0, compiled by Apple LLVM version 9.1.0 (clang-902.0.39.2), 64-bit
(1 row)

bsnyder=> \q
$