Обсуждение: wal_mode in postgresql.conf
Why is 'wal_level' listed next to 'fsync' in postgresql.conf? #wal_level = 'hot_standby' # minimal, archive, or hot_standby#fsync = on # turnsforced synchronization on or off#synchronous_commit = on # immediate fsync at commit#wal_sync_method= fsync # the default is the first option Seems it should be in the archiving section. -- Bruce Momjian <bruce@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com
Bruce Momjian wrote: > Why is 'wal_level' listed next to 'fsync' in postgresql.conf? > > #wal_level = 'hot_standby' # minimal, archive, or hot_standby > #fsync = on # turns forced synchronization on or off > #synchronous_commit = on # immediate fsync at commit > #wal_sync_method = fsync # the default is the first option > > Seems it should be in the archiving section. Sorry, subject was wrong. I am asking about 'wal_level'. -- Bruce Momjian <bruce@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com
On Fri, May 14, 2010 at 12:22 AM, Bruce Momjian <bruce@momjian.us> wrote: > Bruce Momjian wrote: >> Why is 'wal_level' listed next to 'fsync' in postgresql.conf? >> >> #wal_level = 'hot_standby' # minimal, archive, or hot_standby >> #fsync = on # turns forced synchronization on or off >> #synchronous_commit = on # immediate fsync at commit >> #wal_sync_method = fsync # the default is the first option >> >> Seems it should be in the archiving section. -1 since wal_level affects WAL logging itself, and is to do with not only archiving but also hot standby. Regards, -- Fujii Masao NIPPON TELEGRAPH AND TELEPHONE CORPORATION NTT Open Source Software Center