Search Postgresql Archives

Server writing short WAL files

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi,

I'm having trouble with WAL files. Every 4th WAL file written by the server
into pg_xlog is 24576 bytes instead of 16MB. A short WAL causes a fatal
error during recovery.

This behavior is perfectly consistent. For example, if archive_timeout is 5
mins, every 20 minutes the new WAL file is 24576 bytes, followed 5 mins later
by a 16MB one. By adjusting the archive_timeout, I can change the interval
-- e.g. every 3rd or 5th WAL file is short -- but the general behavior is the
same.

Here's my WAL config:

wal_level = archive
fsync = on
#synchronous_commit = on
#wal_sync_method = fsync
full_page_writes = on
wal_buffers = -1
#wal_writer_delay = 200ms
#commit_delay = 0
#commit_siblings = 5
checkpoint_segments = 10
checkpoint_timeout = 6min
checkpoint_completion_target = 0.6
#checkpoint_warning = 30s
archive_mode = on
archive_command = '/usr/local/sbin/postgresql_archive.sh %p %f'
archive_timeout = 5min

Does anyone know how to fix this?

Postgres version 9.1.4 on Amazon Linux, installed from the yum package
manager.

Thanks.

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux