<sect1 id="release-pro-9-6-0-1">

<title>&productname; 9.6.0.1</title>

<note>

<title>Release Date</title>

<simpara>2016-10-28</simpara>

</note>

<sect2>

<title>Overview</title>

<para>This release is based on <productname>Postgres Pro</productname>

9.6.0.1</para>

<para>Major enhancements over <productname>Postgres Pro</productname>

9.6.0 include:</para>

<para>Added k-nearest neighbors algorithm (KNN) for SP-GiST and B-tree (See: <xref linkend="spgist">)</para>

<para>Added new index RUM, based on GIN, as separate module (See: <xref linkend="rum">)</para>

<para>WAL size has been reduced on <command>CREATE INDEX</command> operation in the GiST, GIT, SP-GiST</para>

<para>Added timeout for idle sessions on the server side (See: <xref linkend="config">)</para>

<para>Added SHA-2 algorithm for password encryption (See: <xref linkend="config"> and <xref linkend="SQL-CREATEROLE">)</para>

<para>Added page level compression (CFS)(See: <xref linkend="cfs">)</para>

</sect2>

<sect2>

<title>Migration to Version &productname; 9.6.0.1</title>

<para>A dump/restore using <xref linkend="app-pg-dumpall">, or

use of <xref linkend="pgupgrade">, is required for those

wishing to migrate data from any previous major release.</para>

<para>Dump/restore is not neccessary when migrating from PostgreSQL 9.6.x to

&productname; 9.6.x.y.</para>

<para>When upgrading from previous releases of Postgres Pro or from

vanilla PostgreSQL 9.6.x, some catalog changes should be applied.</para>

<para>If you use binary packages, and your database is in the default

location, this upgrade should be performed automatically. If you've

compiled Postgres Pro from source or create your database in

non-default location, running <literal>initdb</literal> manually, you

should run <literal>pgpro_upgrade</literal> script provided in this

distribution.

</para>

<para>Before running script, you should stop postgres service. Script

should be run as user, owning the database (typically postgres) and

PGDATA environment variable should be set to the directory where

database resides.

</para>

</sect2>

</sect1>