Re: pg_xlog and standby - SOLVED - Mailing list pgsql-general

From Greg Smith
Subject Re: pg_xlog and standby - SOLVED
Date
Msg-id Pine.GSO.4.64.0801241327190.1116@westnet.com
Whole thread Raw
In response to Re: pg_xlog and standby - SOLVED  (Erik Jones <erik@myemma.com>)
Responses Re: pg_xlog and standby - SOLVED  ("Roberto Scattini" <roberto.scattini@gmail.com>)
List pgsql-general
On Thu, 24 Jan 2008, Erik Jones wrote:

> To disable archiving, set archive_command="", commenting it out won't
> change it...However, commenting a config is not necessarily equivalent
> to disabling something.

This is actually a problem that is corrected in the upcoming 8.3 release.
From those release notes:

"Commenting out a parameter in postgresql.conf now causes it to revert to
its default value.  [In 8.2 and earlier releases] commenting out an entry
left the parameter's value unchanged until the next server restart."

This is probably why Roberto didn't see the expected behavior until a
server restart.

--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD

pgsql-general by date:

Previous
From: John DeSoi
Date:
Subject: Re: PostgreSQL/PHP Application Server
Next
From: "Dominique Bessette - Halsema"
Date:
Subject: unique constraint