-->

<para>

Add default roles whichcontrols file system access (Stephen Frost)

Add default roles whichcontrol file system access (Stephen Frost)

</para>

<para>

<literal>pg_execute_server_program</literal>. These roles now also

control who can use <command>COPY</command> and extension <link

linkend="file-fdw"><application>file_fdw</application></link>.

Previously onlysuper-users could use these functions, and that

Previously onlysuperusers could use these functions, and that

is still the default behavior.

</para>

</listitem>

<para>

Allow access to file system functions to be controlled by

<command>GRANT</command>/<command>REVOKE</command> permissions,

rather thansuper-user checks (Stephen Frost)

rather thansuperuser checks (Stephen Frost)

</para>

<para>

</para>

<para>

Previously super userswere exclusively grantedtoaccess these

Previously, superuserswere exclusively granted access to these

functions.

</para>

</para>

<para>

<productname>PostgreSQL</productname> only allowssuper-users to

<productname>PostgreSQL</productname> only allowssuperusers to

access <application>postgres_fdw</application> tables without

passwords, e.g. via <literal>peer</literal>. Previously the

session owner had to be asuper-user to allow such access; now

session owner had to be asuperuser to allow such access; now

the view owner is checked instead.

</para>

</listitem>

<para>

Add server setting <link

linkend="guc-ssl-passphrase-command"><varname>ssl_passphrase_command</varname></link>

to allow supplying of thethepassphrase for <acronym>SSL</acronym>

to allow supplying of the passphrase for <acronym>SSL</acronym>

key files (Peter Eisentraut)

</para>

<para>

The new unit is "B". This is in addition to "kB", "MB", "GB"

and "TB", which were accepted previously.

and "TB".

</para>

</listitem>

-->

<para>

Exclude unlogged, temporary tables, and

Exclude unlogged tables, temporary tables, and

<filename>pg_internal.init</filename> files from streaming base

backups (David Steele)

</para>

<para>

Also, if any table mentioned in <command>VACUUM</command> uses

a column list, then <command>ANALYZE</command> keyword must be

supplied;previously <command>ANALYZE</command> was implied in

a column list, thenthe<command>ANALYZE</command> keyword must be

supplied; previously, <command>ANALYZE</command> was implied in

such cases.

</para>

</listitem>

</para>

<para>

This is useful for allowing aggregate functions be optimized and

This is useful for allowing aggregate functionstobe optimized and

to work as window functions.

</para>

</para>

<para>

Also allow PL/PL/Perl, PL/Python, and PL/Tcl to handle

Also allow PL/Perl, PL/Python, and PL/Tcl to handle

composite-domain function arguments and results. Also improve

PL/Python domain handling.

</para>

<para>

Add text search function <link

linkend="textsearch-functions-table"><function>websearch_to_tsquery()</function></link>

that supports aqueries syntax similar to that used by web search

that supports aquery syntax similar to that used by web search

engines (Victor Drobny, Dmitry Ivanov)

</para>

</listitem>

<para>

Add function <link

linkend="textsearch-functions-table"><function>json(b)_to_tsvector()</function></link>

to create text search query for matching

to createatext search query for matching

<type>JSON</type>/<type>JSONB </type>values (Dmitry Dolgov)

</para>

-->

<para>

Add approximated Zipfian-distributed random generator to

Addanapproximated Zipfian-distributed random generator to

<application>pgbench</application> (Alik Khilazhev)

</para>

</listitem>

-->

<para>

Add <link

Addan option to<link

linkend="app-pgbasebackup"><application>pg_basebackup</application></link>

option to create a named replication slot (Michael Banck)

that creates a named replication slot (Michael Banck)

</para>

<para>

The option <option>--create-slot</option> creates

the named replication slot (<option>--slot</option>)

when the <acronym>WAL</acronym> streaming method

(<option>-wal-method=stream</option>) is used.

(<option>--wal-method=stream</option>) is used.

</para>

<para>

</para>

<para>

This is useful if the system to be loaded hasadifferent collation

This is useful if the system to be loaded has different collation

definitions or endianness, requiring the rows to be stored in

different partitions.

</para>

-->

<para>

Addabilityto suppress dumping and restoring of comments

Addan optionto suppress dumping and restoring comments

(Robins Tharakan)

</para>

</para>

<para>

Previously onlysuper-users could call adminpack functions;

Previously onlysuperusers could call adminpack functions;

now role permissions are checked.

</para>

</listitem>