[COMMITTERS] pgsql: Prevent intermittent hang in recovery from bgwriter interaction.
Prevent intermittent hang in recovery from bgwriter interaction. Startup process waited for cleanup lock but when hot_standby = off the pid was not registered, so that the bgwriter would not wake the waiting process as intended. Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/b98ac467f5d35970edade4ad65c767fc89059026 Modified Files -- src/backend/access/transam/xlog.c |2 ++ src/backend/storage/ipc/standby.c |5 - 2 files changed, 2 insertions(+), 5 deletions(-) -- Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-committers
[COMMITTERS] pgsql: Prevent intermittent hang in recovery from bgwriter interaction.
Prevent intermittent hang in recovery from bgwriter interaction. Startup process waited for cleanup lock but when hot_standby = off the pid was not registered, so that the bgwriter would not wake the waiting process as intended. Branch -- REL9_0_STABLE Details --- http://git.postgresql.org/pg/commitdiff/9bb1ddec4cd998c5fbac278a54d8ad5a5011e4e1 Modified Files -- src/backend/access/transam/xlog.c |2 ++ src/backend/storage/ipc/standby.c |5 - 2 files changed, 2 insertions(+), 5 deletions(-) -- Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-committers
[COMMITTERS] pgsql: Remove synchronous_replication/max_wal_senders cross-check.
Remove synchronous_replication/max_wal_senders cross-check. This is no longer necessary, and might result in a situation where the configuration file is reloaded (and everything seems OK) but a subsequent restart of the database fails. Per an observation from Fujii Masao. Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/19584ec659678841ea3036336f960acbdae962a0 Modified Files -- src/backend/postmaster/postmaster.c |3 --- 1 files changed, 0 insertions(+), 3 deletions(-) -- Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-committers
[COMMITTERS] pgsql: Fix ancient typo in user-defined-aggregates documentation.
Fix ancient typo in user-defined-aggregates documentation. The description of the initcond value for the built-in avg(float8) aggregate has been wrong since it was written. Noted by Disc Magnet. Branch -- REL8_4_STABLE Details --- http://git.postgresql.org/pg/commitdiff/e39d6db39b958381ed2892734d3176e2c9bb1b40 Modified Files -- doc/src/sgml/xaggr.sgml |2 +- 1 files changed, 1 insertions(+), 1 deletions(-) -- Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-committers
[COMMITTERS] pgsql: Fix ancient typo in user-defined-aggregates documentation.
Fix ancient typo in user-defined-aggregates documentation. The description of the initcond value for the built-in avg(float8) aggregate has been wrong since it was written. Noted by Disc Magnet. Branch -- REL9_0_STABLE Details --- http://git.postgresql.org/pg/commitdiff/6d0877fc5e5847e272129eb23ae48246ca352d2a Modified Files -- doc/src/sgml/xaggr.sgml |2 +- 1 files changed, 1 insertions(+), 1 deletions(-) -- Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-committers
[COMMITTERS] pgsql: Fix ancient typo in user-defined-aggregates documentation.
Fix ancient typo in user-defined-aggregates documentation. The description of the initcond value for the built-in avg(float8) aggregate has been wrong since it was written. Noted by Disc Magnet. Branch -- REL8_3_STABLE Details --- http://git.postgresql.org/pg/commitdiff/03f957fe1d10b7950bac75929be17fad87ee Modified Files -- doc/src/sgml/xaggr.sgml |2 +- 1 files changed, 1 insertions(+), 1 deletions(-) -- Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-committers
[COMMITTERS] pgsql: Fix ancient typo in user-defined-aggregates documentation.
Fix ancient typo in user-defined-aggregates documentation. The description of the initcond value for the built-in avg(float8) aggregate has been wrong since it was written. Noted by Disc Magnet. Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/ba7d020d9d6edba872173f8640ca240e00ae7070 Modified Files -- doc/src/sgml/xaggr.sgml |2 +- 1 files changed, 1 insertions(+), 1 deletions(-) -- Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-committers
[COMMITTERS] pgsql: Fix ancient typo in user-defined-aggregates documentation.
Fix ancient typo in user-defined-aggregates documentation. The description of the initcond value for the built-in avg(float8) aggregate has been wrong since it was written. Noted by Disc Magnet. Branch -- REL8_2_STABLE Details --- http://git.postgresql.org/pg/commitdiff/24cdee8606086699a634f424333b894509c5cbd0 Modified Files -- doc/src/sgml/xaggr.sgml |2 +- 1 files changed, 1 insertions(+), 1 deletions(-) -- Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-committers
Re: [COMMITTERS] pgsql: Fix ancient typo in user-defined-aggregates documentation.
On 23 March 2011 16:34, Tom Lane wrote: > Fix ancient typo in user-defined-aggregates documentation. > > The description of the initcond value for the built-in avg(float8) > aggregate has been wrong since it was written. Noted by Disc Magnet. > > Branch > -- > REL8_2_STABLE > > Details > --- > http://git.postgresql.org/pg/commitdiff/24cdee8606086699a634f424333b894509c5cbd0 > > Modified Files > -- > doc/src/sgml/xaggr.sgml | 2 +- > 1 files changed, 1 insertions(+), 1 deletions(-) The preceding paragraph says that it typically uses a two-element array for the state value. Maybe this should say two or three-element given the example that immediately follows it. -- Thom Brown Twitter: @darkixion IRC (freenode): dark_ixion Registered Linux user: #516935 EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-committers
Re: [COMMITTERS] pgsql: Fix ancient typo in user-defined-aggregates documentation.
Thom Brown writes: > On 23 March 2011 16:34, Tom Lane wrote: >> Fix ancient typo in user-defined-aggregates documentation. >> >> The description of the initcond value for the built-in avg(float8) >> aggregate has been wrong since it was written. Noted by Disc Magnet. > The preceding paragraph says that it typically uses a two-element > array for the state value. Maybe this should say two or three-element > given the example that immediately follows it. Oh, I shouldn't have done that with blinders on :-(. I think probably we have to explain that float8_accum supports more things than just average. Will fix as soon as I get back from my doctors appointment. regards, tom lane -- Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-committers
[COMMITTERS] pgsql: Minor changes to recovery pause behaviour.
Minor changes to recovery pause behaviour. Change location LOG message so it works each time we pause, not just for final pause. Ensure that we pause only if we are in Hot Standby and can connect to allow us to run resume function. This change supercedes the code to override parameter recoveryPauseAtTarget to false if not attempting to enter Hot Standby, which is now removed. Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/b5f2f2a712e56fe1edf7d5665c07ee97be464c0b Modified Files -- src/backend/access/transam/xlog.c | 24 1 files changed, 12 insertions(+), 12 deletions(-) -- Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-committers
[COMMITTERS] pgsql: Improve user-defined-aggregates documentation.
Improve user-defined-aggregates documentation. On closer inspection, that two-element initcond value seems to have been a little white lie to avoid explaining the full behavior of float8_accum. But if people are going to expect the examples to be exactly correct, I suppose we'd better explain. Per comment from Thom Brown. Branch -- REL8_3_STABLE Details --- http://git.postgresql.org/pg/commitdiff/5b6c27a607641145d29b64c2f90907db0ed4b36f Modified Files -- doc/src/sgml/xaggr.sgml | 13 + 1 files changed, 9 insertions(+), 4 deletions(-) -- Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-committers
[COMMITTERS] pgsql: Improve user-defined-aggregates documentation.
Improve user-defined-aggregates documentation. On closer inspection, that two-element initcond value seems to have been a little white lie to avoid explaining the full behavior of float8_accum. But if people are going to expect the examples to be exactly correct, I suppose we'd better explain. Per comment from Thom Brown. Branch -- REL8_2_STABLE Details --- http://git.postgresql.org/pg/commitdiff/63fe94d1652a376bdd698d7ad68477e66640e246 Modified Files -- doc/src/sgml/xaggr.sgml | 13 + 1 files changed, 9 insertions(+), 4 deletions(-) -- Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-committers
[COMMITTERS] pgsql: Improve user-defined-aggregates documentation.
Improve user-defined-aggregates documentation. On closer inspection, that two-element initcond value seems to have been a little white lie to avoid explaining the full behavior of float8_accum. But if people are going to expect the examples to be exactly correct, I suppose we'd better explain. Per comment from Thom Brown. Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/472671e133da77f280e87cb47c6544c75572df6b Modified Files -- doc/src/sgml/xaggr.sgml | 16 +++- 1 files changed, 11 insertions(+), 5 deletions(-) -- Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-committers
[COMMITTERS] pgsql: Improve user-defined-aggregates documentation.
Improve user-defined-aggregates documentation. On closer inspection, that two-element initcond value seems to have been a little white lie to avoid explaining the full behavior of float8_accum. But if people are going to expect the examples to be exactly correct, I suppose we'd better explain. Per comment from Thom Brown. Branch -- REL8_4_STABLE Details --- http://git.postgresql.org/pg/commitdiff/3b02cef29517e3b64a600d994f995ee352fd3fb4 Modified Files -- doc/src/sgml/xaggr.sgml | 16 +++- 1 files changed, 11 insertions(+), 5 deletions(-) -- Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-committers
[COMMITTERS] pgsql: Improve user-defined-aggregates documentation.
Improve user-defined-aggregates documentation. On closer inspection, that two-element initcond value seems to have been a little white lie to avoid explaining the full behavior of float8_accum. But if people are going to expect the examples to be exactly correct, I suppose we'd better explain. Per comment from Thom Brown. Branch -- REL9_0_STABLE Details --- http://git.postgresql.org/pg/commitdiff/03c77337209f0b2b3059d6ee9df2f94c6f66d910 Modified Files -- doc/src/sgml/xaggr.sgml | 16 +++- 1 files changed, 11 insertions(+), 5 deletions(-) -- Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-committers
Re: [COMMITTERS] pgsql: Improve user-defined-aggregates documentation.
On 23 March 2011 20:58, Tom Lane wrote: > Improve user-defined-aggregates documentation. > > On closer inspection, that two-element initcond value seems to have been > a little white lie to avoid explaining the full behavior of float8_accum. > But if people are going to expect the examples to be exactly correct, > I suppose we'd better explain. Per comment from Thom Brown. > > Branch > -- > REL9_0_STABLE > > Details > --- > http://git.postgresql.org/pg/commitdiff/03c77337209f0b2b3059d6ee9df2f94c6f66d910 > > Modified Files > -- > doc/src/sgml/xaggr.sgml | 16 +++- > 1 files changed, 11 insertions(+), 5 deletions(-) Thanks Mr Lane :) -- Thom Brown Twitter: @darkixion IRC (freenode): dark_ixion Registered Linux user: #516935 EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-committers