BUG #5206: wal_sync_method in stock postgresql.conf may be wrong

From: "Alvaro Herrera" <alvherre(at)postgresql(dot)org>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #5206: wal_sync_method in stock postgresql.conf may be wrong
Date: 2009-11-20 23:56:59
Message-ID: 200911202356.nAKNuxJB044989@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers


The following bug has been logged online:

Bug reference: 5206
Logged by: Alvaro Herrera
Email address: alvherre(at)postgresql(dot)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?

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2009-11-21 06:02:43 Re: BUG #5201: insert select gives bogus error message
Previous Message Alain Baeckeroot 2009-11-20 23:44:55 BUG #5205: Cannot ADD CONSTRAINT ... FOREIGN KEY...

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2009-11-21 00:02:11 Re: ecpg & 8.3 -> 8.4 migration
Previous Message Tom Lane 2009-11-20 23:47:35 Re: DEFAULT of domain ignored in plpgsql (8.4.1)