[COMMITTERS] pgsql: Teach xlogreader to follow timeline switches

2017-03-22 Thread Simon Riggs
Teach xlogreader to follow timeline switches Uses page-based mechanism to ensure we’re using the correct timeline. Tests are included to exercise the functionality using a cold disk-level copy of the master that's started up as a replica with slots intact, but the intended use of the functionalit

[COMMITTERS] pgsql: Improve performance of replay of AccessExclusiveLocks

2017-03-22 Thread Simon Riggs
Improve performance of replay of AccessExclusiveLocks A hot standby replica keeps a list of Access Exclusive locks for a top level transaction. These locks are released when the top level transaction ends. Searching of this list is O(N^2), and each transaction had to pay the price of searching thi

[COMMITTERS] pgsql: Sync pg_dump and pg_dumpall output

2017-03-22 Thread Andrew Dunstan
Sync pg_dump and pg_dumpall output Before exiting any files are fsync'ed. A --no-sync option is also provided for a faster exit if desired. Michael Paquier. Reviewed by Albe Laurenz Discussion: https://postgr.es/m/CAB7nPqS1uZ=ov+uruw6jr3vb-s_dlvmpc0dqpv-ftdjmm0z...@mail.gmail.com Branch -

[COMMITTERS] pgsql: Change logical replication pg_hba.conf use

2017-03-22 Thread Peter Eisentraut
Change logical replication pg_hba.conf use Logical replication no longer uses the "replication" keyword. It just matches database entries in the normal way. The "replication" keyword now only applies to physical replication. Reviewed-by: Petr Jelinek Branch -- master Details --- http

[COMMITTERS] pgsql: Refine rules for altering publication owner

2017-03-22 Thread Peter Eisentraut
Refine rules for altering publication owner Previously, the new owner had to be a superuser. The new rules are more refined similar to other objects. Reviewed-by: Petr Jelinek Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/4cfc9484d4effb0a3aa2c8742bdef0c2bc7a3ca5

[COMMITTERS] pgsql: Assign AccessExclusiveLocks against subxacts in Hot Standby

2017-03-22 Thread Simon Riggs
Assign AccessExclusiveLocks against subxacts in Hot Standby Previously AELs were registered against the top-level xid, which could cause locks to be held much longer than necessary in some cases during Hot Standby replay. We now record locks directly against their appropriate xids. Requires few co

[COMMITTERS] pgsql: Refactor GetOldestXmin() to use flags

2017-03-22 Thread Simon Riggs
Refactor GetOldestXmin() to use flags Replace ignoreVacuum parameter with more flexible flags. Author: Eiji Seki Review: Haribabu Kommi Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/af4b1a0869bd3bb52e5f662e4491554b7f611489 Modified Files -- contrib/pg

[COMMITTERS] pgsql: Correct erroneous comment in GetOldestXmin()

2017-03-22 Thread Simon Riggs
Correct erroneous comment in GetOldestXmin() Craig Ringer Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/c137c68ea6bfe860c3e5f4edee7031e136ba4f0c Modified Files -- src/backend/storage/ipc/procarray.c | 1 + 1 file changed, 1 insertion(+) -- Sent via p

[COMMITTERS] pgsql: Support multiple RADIUS servers

2017-03-22 Thread Magnus Hagander
Support multiple RADIUS servers This changes all the RADIUS related parameters (radiusserver, radiussecret, radiusport, radiusidentifier) to be plural and to accept a comma separated list of servers, which will be tried in order. Reviewed by Adam Brightwell Branch -- master Details ---

[COMMITTERS] pgsql: Fix wrong costing of Sort under Gather Merge.

2017-03-22 Thread Robert Haas
Fix wrong costing of Sort under Gather Merge. There's no mechanism for such a sort to become a top-N sort, so we should pass -1 rather than limit_tuples to cost_sort(). Rushabh Lathia, per a report from Mithun Cy Discussion: http://postgr.es/m/CAGPqQf1akRcSgC9=6iwx=sepap9uvpphjlzg8_n+ouhdb6f...

[COMMITTERS] pgsql: doc: Fix logical replication setup instructions

2017-03-22 Thread Peter Eisentraut
doc: Fix logical replication setup instructions The pg_hba.conf rules were changed in 8df9bd0b445f9bd6134915d4417efde6e85e3add. Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/b9418911900ff5b68a5457b1542668077664e897 Modified Files -- doc/src/sgml/logica

[COMMITTERS] pgsql: doc: Improve CREATE PUBLICATION examples

2017-03-22 Thread Peter Eisentraut
doc: Improve CREATE PUBLICATION examples Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/cbf7ed51b8c0c3e506b91765769f76d5c2e1e9ac Modified Files -- doc/src/sgml/ref/create_publication.sgml | 19 ++- 1 file changed, 14 insertions(+), 5 delet

[COMMITTERS] pgsql: doc: Markup and formatting improvements

2017-03-22 Thread Peter Eisentraut
doc: Markup and formatting improvements Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/a2760915b3a88f8e1b447dd5343549a1ebbb0f78 Modified Files -- doc/src/sgml/ref/alter_subscription.sgml | 6 +++--- doc/src/sgml/ref/create_subscription.sgml | 7 +-- d

[COMMITTERS] pgsql: Expose waitforarchive option through pg_stop_backup()

2017-03-22 Thread Stephen Frost
Expose waitforarchive option through pg_stop_backup() Internally, we have supported the option to either wait for all of the WAL associated with a backup to be archived, or to return immediately. This option is useful to users of pg_stop_backup() as well, when they are reading the stop backup reco