BUG #5206: wal_sync_method in stock postgresql.conf may be wrong - Mailing list pgsql-bugs

From Alvaro Herrera
Subject BUG #5206: wal_sync_method in stock postgresql.conf may be wrong
Date
Msg-id 200911202356.nAKNuxJB044989@wwwmaster.postgresql.org
Whole thread Raw
Responses Re: BUG #5206: wal_sync_method in stock postgresql.conf may be wrong
List pgsql-bugs
The following bug has been logged online:

Bug reference:      5206
Logged by:          Alvaro Herrera
Email address:      alvherre@postgresql.org
PostgreSQL version: any
Operating system:   any
Description:        wal_sync_method in stock postgresql.conf may be wrong
Details:

Jaime Casanova just made me note that though most commented variables in
postgresql.conf list the value that they have because of being the default,
this is not the case with wal_sync_method -- it instead says "fsync" and
then explains in a comment that the real value is something else.

Now I understand why this is (it's because of the fact that the default
value is platform-dependent), but it still is a bit unfortunate and it would
be better to avoid it.

I have two suggestions to fix this:

1. avoid displaying any value at all as if it were the true default (this
would perhaps make the line invalid were the user to uncomment it)

2. change initdb so that it modifies that line too (along with
shared_buffers etc) to put the actual default value in there, but without
uncommenting it.

I also have one non-suggestion:

3. do nothing

Thoughts?

pgsql-bugs by date:

Previous
From: Kris Jurka
Date:
Subject: Re: BUG #5197: JDBC: selecting oid results in Exception
Next
From: ""
Date:
Subject: BUG #5201: insert select gives bogus error message