Re: BUG #6042: unlogged table with Streaming Replication - Mailing list pgsql-bugs

From Robert Haas
Subject Re: BUG #6042: unlogged table with Streaming Replication
Date
Msg-id BANLkTikJMDYacf84z6Zf4ZfftahPjRJdhQ@mail.gmail.com
Whole thread Raw
In response to Re: BUG #6042: unlogged table with Streaming Replication  (Jaime Casanova <jaime@2ndquadrant.com>)
List pgsql-bugs
On Fri, May 27, 2011 at 1:53 AM, Jaime Casanova <jaime@2ndquadrant.com> wrote:
> btw, i guess we should be defaulting to asynchronous standbys (ie:
> synchronous_commit=local)

By default, synchronous_standby_names is empty, which makes
synchronous_commit=on equivalent to synchronous_commit=local.  So I
think the current default is good, because it means you only need to
change ONE parameter to switch from async rep to sync rep (namely,
synchronous_standby_names).

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

pgsql-bugs by date:

Previous
From: Robert Haas
Date:
Subject: Re: BUG #5984: Got FailedAssertion("!(opaque->btpo_prev == target)", File: "nbtpage.c", Line: 1166)
Next
From: Cédric Villemain
Date:
Subject: Re: Unlogged tables cannot be truncated twice