@@ -164,7 +164,7 @@ doc/src/sgml/pgprobackup.sgml
164
164
recovery of <productname >PostgreSQL</productname > database clusters.
165
165
It is designed to perform periodic backups of the <productname >PostgreSQL</productname >
166
166
instance that enable you to restore the server in case of a failure.
167
- <application >pg_probackup</application > supports PostgreSQL 9.5 or higher.
167
+ <application >pg_probackup</application > supports PostgreSQL 9.6 or higher.
168
168
</para >
169
169
170
170
<itemizedlist spacing =" compact" >
@@ -401,11 +401,6 @@ doc/src/sgml/pgprobackup.sgml
401
401
<para >
402
402
<application >pg_probackup</application > currently has the following limitations:
403
403
<itemizedlist spacing =" compact" >
404
- <listitem >
405
- <para >
406
- <application >pg_probackup</application > only supports PostgreSQL 9.5 and higher.
407
- </para >
408
- </listitem >
409
404
<listitem >
410
405
<para >
411
406
The remote mode is not supported on Windows systems.
@@ -422,17 +417,6 @@ doc/src/sgml/pgprobackup.sgml
422
417
<option >--remote-user</option > option to <literal >postgres</literal >.
423
418
</para >
424
419
</listitem >
425
- <listitem >
426
- <para >
427
- For <productname >PostgreSQL</productname > 9.5, functions
428
- <function >pg_create_restore_point(text)</function > and
429
- <function >pg_switch_xlog()</function > can be executed only if
430
- the backup role is a superuser, so backup of a
431
- cluster with low amount of WAL traffic by a non-superuser
432
- role can take longer than the backup of the same cluster by
433
- a superuser role.
434
- </para >
435
- </listitem >
436
420
<listitem >
437
421
<para >
438
422
The <productname >PostgreSQL</productname > server from which the backup was taken and
@@ -612,25 +596,6 @@ pg_probackup add-instance -B <replaceable>backup_dir</replaceable> -D <replaceab
612
596
only in the database <emphasis role =" strong" >used for
613
597
connection</emphasis > to the <productname >PostgreSQL</productname > server:
614
598
</para >
615
- <para >
616
- For <productname >PostgreSQL</productname > 9.5:
617
- </para >
618
- <programlisting >
619
- BEGIN;
620
- CREATE ROLE backup WITH LOGIN;
621
- GRANT USAGE ON SCHEMA pg_catalog TO backup;
622
- GRANT EXECUTE ON FUNCTION pg_catalog.current_setting(text) TO backup;
623
- GRANT EXECUTE ON FUNCTION pg_catalog.set_config(text, text, boolean) TO backup;
624
- GRANT EXECUTE ON FUNCTION pg_catalog.pg_is_in_recovery() TO backup;
625
- GRANT EXECUTE ON FUNCTION pg_catalog.pg_start_backup(text, boolean) TO backup;
626
- GRANT EXECUTE ON FUNCTION pg_catalog.pg_stop_backup() TO backup;
627
- GRANT EXECUTE ON FUNCTION pg_catalog.pg_create_restore_point(text) TO backup;
628
- GRANT EXECUTE ON FUNCTION pg_catalog.pg_switch_xlog() TO backup;
629
- GRANT EXECUTE ON FUNCTION pg_catalog.txid_current() TO backup;
630
- GRANT EXECUTE ON FUNCTION pg_catalog.txid_current_snapshot() TO backup;
631
- GRANT EXECUTE ON FUNCTION pg_catalog.txid_snapshot_xmax(txid_snapshot) TO backup;
632
- COMMIT;
633
- </programlisting >
634
599
<para >
635
600
For <productname >PostgreSQL</productname > 9.6:
636
601
</para >