Re: WAL segments size - Mailing list pgsql-general

From Andrew Sullivan
Subject Re: WAL segments size
Date
Msg-id 20071112194231.GZ32349@crankycanuck.ca
Whole thread Raw
In response to WAL segments size  ("Bruno Almeida do Lago" <teolupus@gmail.com>)
List pgsql-general
On Mon, Nov 12, 2007 at 05:14:24PM -0300, Bruno Almeida do Lago wrote:
> I was looking for a parameter on postgresql.conf to increase the WAL
> segments size, but according to documentation this can only be changed while
> building PostgreSQL.

You mean this:

http://www.postgresql.org/docs/8.2/static/runtime-config-wal.html#GUC-CHECKPOINT-SEGMENTS

?

That doesn't say you have to set it at compile time.  You can't change it
without _restarting_ Postgres.  That's because it's something that has to be
initialized at start up.

A

--
Andrew Sullivan
Old sigs will return after re-constitution of blue smoke

pgsql-general by date:

Previous
From: hubert depesz lubaczewski
Date:
Subject: Re: Regression in 8.3?
Next
From: "Scott Marlowe"
Date:
Subject: Re: WAL segments size