Re: [COMMITTERS] pgsql: Basic Recovery Control functions for use in Hot Standby. Pause,

2011-03-07 Thread Fujii Masao
On Tue, Mar 8, 2011 at 12:04 PM, Tom Lane wrote: > Fujii Masao writes: >> What about the attached patch? > >> +                                             ereport(LOG, >> +                                                             >> (errmsg("Recovery has paused. Execute pg_xlog_replay_resume

Re: [COMMITTERS] pgsql: Basic Recovery Control functions for use in Hot Standby. Pause,

2011-03-07 Thread Tom Lane
Fujii Masao writes: > What about the attached patch? > + ereport(LOG, > + > (errmsg("Recovery has paused. Execute pg_xlog_replay_resume() to > continue."))); This isn't even close to followi

Re: [COMMITTERS] pgsql: Basic Recovery Control functions for use in Hot Standby. Pause,

2011-03-07 Thread Fujii Masao
On Tue, Mar 8, 2011 at 9:20 AM, Jaime Casanova wrote: > On Tue, Feb 8, 2011 at 11:00 PM, Jaime Casanova wrote: >> On Tue, Feb 8, 2011 at 1:30 PM, Simon Riggs wrote: >>> Basic Recovery Control functions for use in Hot Standby. Pause, Resume, >>> Status check functions only. Also, new recovery.con

Re: [COMMITTERS] pgsql: Basic Recovery Control functions for use in Hot Standby. Pause,

2011-03-07 Thread Jaime Casanova
On Tue, Feb 8, 2011 at 11:00 PM, Jaime Casanova wrote: > On Tue, Feb 8, 2011 at 1:30 PM, Simon Riggs wrote: >> Basic Recovery Control functions for use in Hot Standby. Pause, Resume, >> Status check functions only. Also, new recovery.conf parameter to >> pause_at_recovery_target, default on. >> >

[COMMITTERS] pgsql: Report Python errors from iterators with PLy_elog

2011-03-07 Thread Peter Eisentraut
Report Python errors from iterators with PLy_elog This improves reporting, as the error string now includes the actual Python exception. As a side effect, this no longer sets the errcode to ERRCODE_DATA_EXCEPTION, which might be considered a feature, as it's not documented and not clear why iterat

[COMMITTERS] pgsql: Fix behavior when raising plpy.Fatal()

2011-03-07 Thread Peter Eisentraut
Fix behavior when raising plpy.Fatal() It should cause a elog(FATAL) error, and it fact it was simply causing a elog(ERROR). Jan Urbański Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/804d13adfd2f66c70d8d95a606dde621b3213179 Modified Files -- src/pl/p

[COMMITTERS] pgsql: Improve description of inquiry functions that accept regclass.

2011-03-07 Thread Tom Lane
Improve description of inquiry functions that accept regclass. Per a suggestion from Thom Brown, though this is not his proposed patch. Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/cfcdc99db67172d46a5e226375fa97e5c5a62267 Modified Files -- doc/src/sgm

[COMMITTERS] pgsql: Minor copy-editing in CREATE TRIGGER reference page.

2011-03-07 Thread Tom Lane
Minor copy-editing in CREATE TRIGGER reference page. Per suggestions from Thom Brown and Robert Haas. Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/f8c0af840d84086249647d4415bd35903bfc7933 Modified Files -- doc/src/sgml/ref/create_trigger.sgml | 21 +

[COMMITTERS] pgsql: If recovery_target_timeline is set to 'latest' and standby mode

2011-03-07 Thread Heikki Linnakangas
If recovery_target_timeline is set to 'latest' and standby mode is enabled, periodically rescan the archive for new timelines, while waiting for new WAL segments to arrive. This allows you to set up a standby server that follows the TLI change if another standby server is promoted to master. Before

[COMMITTERS] pgsql: Reword alpha release note item on SSI.

2011-03-07 Thread Robert Haas
Reword alpha release note item on SSI. Per Josh Berkus; some additional explanatory text by me. Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/bcf85e3f44a518eb7bb759541189efb6726fe9bc Modified Files -- doc/src/sgml/release-9.1.sgml |9 - 1 fi

[COMMITTERS] pgsql: Synchronous replication doc corrections.

2011-03-07 Thread Robert Haas
Synchronous replication doc corrections. Thom Brown Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/c74d3aceb99ea6c6d102109349b514e76e497592 Modified Files -- doc/src/sgml/config.sgml|2 +- doc/src/sgml/high-availability.sgml |9 +++---

[COMMITTERS] pgsql: Zero out vacuum_count and related counters in pgstat_recv_tabsta

2011-03-07 Thread Tom Lane
Zero out vacuum_count and related counters in pgstat_recv_tabstat(). This fixes an oversight in commit 946045f04d11d246a834b917a2b8bc6e4f884a37 of 2010-08-21, as reported by Itagaki Takahiro. Also a couple of minor cosmetic adjustments. Branch -- master Details --- http://git.postgresql

Re: [COMMITTERS] pgsql: Efficient transaction-controlled synchronous replication.

2011-03-07 Thread Simon Riggs
On Mon, 2011-03-07 at 17:27 +0900, Fujii Masao wrote: > On Mon, Mar 7, 2011 at 7:51 AM, Simon Riggs wrote: > And,, I found one bug ;) You seem to have wrongly removed the check > of max_wal_senders in SyncRepWaitForLSN. This can make the > backend wait for replication even if max_wal_senders = 0.

[COMMITTERS] pgsql: Document the DEFERRABLE option in SET TRANSACTION command.

2011-03-07 Thread Heikki Linnakangas
Document the DEFERRABLE option in SET TRANSACTION command. Kevin Grittner Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/faba108fe4f2491ebc2b7faf4343f952125cc661 Modified Files -- doc/src/sgml/ref/set_transaction.sgml | 11 +++ 1 files changed,

[COMMITTERS] pgsql: Begin error message with lower-case letter.

2011-03-07 Thread Heikki Linnakangas
Begin error message with lower-case letter. Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/97e3dacd84f185bff86485f54c665621222c576b Modified Files -- src/backend/postmaster/postmaster.c |2 +- 1 files changed, 1 insertions(+), 1 deletions(-) -- Sen

Re: [COMMITTERS] pgsql: Efficient transaction-controlled synchronous replication.

2011-03-07 Thread Fujii Masao
On Mon, Mar 7, 2011 at 7:51 AM, Simon Riggs wrote: > Efficient transaction-controlled synchronous replication. > If a standby is broadcasting reply messages and we have named > one or more standbys in synchronous_standby_names then allow > users who set synchronous_replication to wait for commit,

[COMMITTERS] pgsql: Silence compiler warning about undefined function when compiling

2011-03-07 Thread Heikki Linnakangas
Silence compiler warning about undefined function when compiling without assertions. Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/baabf05196922164db80bdc45fd0660c8700f1f7 Modified Files -- src/backend/replication/syncrep.c |2 ++ 1 files changed, 2