[COMMITTERS] pgsql: Prevent intermittent hang in recovery from bgwriter interaction.

2011-03-23 Thread Simon Riggs
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.

2011-03-23 Thread Simon Riggs
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.

2011-03-23 Thread Robert Haas
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.

2011-03-23 Thread Tom Lane
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.

2011-03-23 Thread Tom Lane
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.

2011-03-23 Thread Tom Lane
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.

2011-03-23 Thread Tom Lane
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.

2011-03-23 Thread Tom Lane
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.

2011-03-23 Thread Thom Brown
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.

2011-03-23 Thread Tom Lane
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.

2011-03-23 Thread Simon Riggs
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.

2011-03-23 Thread Tom Lane
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.

2011-03-23 Thread Tom Lane
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.

2011-03-23 Thread Tom Lane
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.

2011-03-23 Thread Tom Lane
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.

2011-03-23 Thread Tom Lane
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.

2011-03-23 Thread Thom Brown
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