diff options
| author | Peter Eisentraut <peter_e@gmx.net> | 2017-08-16 19:46:50 -0400 |
|---|---|---|
| committer | Peter Eisentraut <peter_e@gmx.net> | 2017-08-16 19:46:50 -0400 |
| commit | cf851519d40e85c8129515c06532515386eaf41c (patch) | |
| tree | a8e7047acabffb0ee40e45e4f3182baf1b3a8127 /doc/src/sgml/ref/pg_dump.sgml | |
| parent | dcd052c8d20c5359c55f2a101f10a8e6341233cd (diff) | |
| download | postgresql-cf851519d40e85c8129515c06532515386eaf41c.tar.gz postgresql-cf851519d40e85c8129515c06532515386eaf41c.zip | |
pg_dump: Support using synchronized snapshots on standbys
This became possible by commit
6c2003f8a1bbc7c192a2e83ec51581c018aa162f. This just makes pg_dump aware
of it and updates the documentation.
Author: Petr Jelinek <petr.jelinek@2ndquadrant.com>
Diffstat (limited to 'doc/src/sgml/ref/pg_dump.sgml')
| -rw-r--r-- | doc/src/sgml/ref/pg_dump.sgml | 18 |
1 files changed, 10 insertions, 8 deletions
diff --git a/doc/src/sgml/ref/pg_dump.sgml b/doc/src/sgml/ref/pg_dump.sgml index ad5b6fc7035..7ccbee4855c 100644 --- a/doc/src/sgml/ref/pg_dump.sgml +++ b/doc/src/sgml/ref/pg_dump.sgml @@ -337,14 +337,16 @@ PostgreSQL documentation but to abort the dump. </para> <para> - For a consistent backup, the database server needs to support synchronized snapshots, - a feature that was introduced in <productname>PostgreSQL</productname> 9.2. With this - feature, database clients can ensure they see the same data set even though they use - different connections. <command>pg_dump -j</command> uses multiple database - connections; it connects to the database once with the master process and - once again for each worker job. Without the synchronized snapshot feature, the - different worker jobs wouldn't be guaranteed to see the same data in each connection, - which could lead to an inconsistent backup. + For a consistent backup, the database server needs to support + synchronized snapshots, a feature that was introduced in + <productname>PostgreSQL</productname> 9.2 for primary servers and 10 + for standbys. With this feature, database clients can ensure they see + the same data set even though they use different connections. + <command>pg_dump -j</command> uses multiple database connections; it + connects to the database once with the master process and once again + for each worker job. Without the synchronized snapshot feature, the + different worker jobs wouldn't be guaranteed to see the same data in + each connection, which could lead to an inconsistent backup. </para> <para> If you want to run a parallel dump of a pre-9.2 server, you need to make sure that the |