<title>Overview</title>

<para>This release is based on <productname>PostgreSQL</productname>

9.5.4</para>

<para>Majorenhancement over the <productname>Postgres Pro</productname>

<para>Majorenhancements over <productname>Postgres Pro</productname>

9.5.3.2 include:</para>

<itemizedlist>

<listitem>

<para>Changed thedistance semantic of the FTS phrase operator: less-or-equal

<para>Thedistance semantic of the FTS phrase operator has been changed: less-or-equal

replaced by exact match (For details see: <xref linkend="textsearch-matching">).</para>

</listitem>

<listitem>

<para>Changed predecence of the phrase operator. The

operator <literal>&lt;-&gt;</literal>now have higher

<para>The predecence of the phrase operator has been changed. The

operator <literal>&lt;-&gt;</literal>has now higher

predecence than <literal>&amp;</literal> (AND) operator.</para>

</listitem>

</itemizedlist>

<para>The WinEditLine library integrated for implement autocomplete in psql console on

Windows platforms. Also we changed <application>psql</application>'s

default encoding in Windows to UTF-8.</para>

<para>On Microsoft Windows platforms:</para>

<itemizedlist>

<listitem>

<para>The WinEditLine library is integrated to implement autocomplete

in psql console. The <application>psql</application> default encoding

is changed to UTF-8.</para>

</listitem>

</itemizedlist>

</sect2>

<sect2>

<title>Migration to Version 9.5.4.1</title>

<para>A dump/restore is not required for those running 9.5.3.2.</para>

<para>

However, if you are upgrading from a version earlier than 9.5.3.2,

see <xref linkend="release-pro-9-5-3-2">.

However, if you are upgrading from a version earlier than 9.5.3.2

or vanilla PostgreSQL 9.5.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>

<sect2>

<title>Potential problems</title>

<para>On the Microsoft Windows systems may not work plperl loading (<command>create

extension plperl</command>). For ActivePerl since version 5.16 as C

compiler used GCC from MinGW, but plperl compiled by MSVC2013 now.

Perl version handshake be poor.</para>

<para>Plperl extension loading may not work on Microsoft Windows.</para>

</sect2>

</sect1>

<sect1 id="release-pro-9-5-3-2">