20170612:

  AFFECTS: users of database/postgresql*, databases/postgis* and other

           software using PostgreSQL to run

  AUTHOR: tz@FreeBSD.org

  The default version of PostgreSQL has been switched from 9.3 to 9.5.

  Upgrade instructions:

  First stop your PostgreSQL, fetch current PostgreSQL-binaries and backup your data:

  # service postgresql stop

  # pkg fetch postgresql93-server postgresql93-contrib

  # mkdir /tmp/pg-upgrade

  # tar xf /var/cache/pkg/postgresql93-server-9.3.17.txz -C /tmp/pg-upgrade

  # tar xf /var/cache/pkg/postgresql93-contrib-9.3.17.txz -C /tmp/pg-upgrade

  # mv /usr/local/pgsql/data /usr/local/pgsql/data93

  Now update PostgreSQL:

    pkg user:

    # pkg upgrade

    Portmaster users:

    # portmaster databases/postgresql95-server databases/postgresql95-contrib

    # portmaster -a

    Portupgrade users:

    # portinstall databases/postgresql95-server databases/postgresql95-contrib

    # portupgrade -a

  After installing the new PostgreSQL version you need to convert

  all your databases to new version:

  # service postgresql initdb

  # su -l pgsql -c "pg_upgrade -b /tmp/pg-upgrade/usr/local/bin/ -d /usr/local/pgsql/data93/ -B /usr/local/bin/ -D /usr/local/pgsql/data/"