consider increasing WAL_FILES

Started by Nonamealmost 25 years ago2 messagesgeneral

newsreader@mediaone.net

almost 25 years ago

I dump database from 7.0.3 and attempting
to restore to 7.1rc4. And get the following
messages. I can reproduce them by
dropping new db and recreating new ones.

Line number varies from one restore to
the next and 'MoveOfflineLogs' message
was seen only once

Should I worry? How do I increase
WAL_FILES?

The largest table has about 500,000 entries.

Thanks in advance

DEBUG: copy: line 85254, XLogWrite: new log file created - consider increasing WAL_FILES
DEBUG: MoveOfflineLogs: remove 0000000000000010
DEBUG: MoveOfflineLogs: remove 0000000000000011
DEBUG: copy: line 305196, XLogWrite: new log file created - consider increasing WAL_FILES
DEBUG: copy: line 5129, XLogWrite: new log file created - consider increasing WAL_FILES

Tom Lane

tgl@sss.pgh.pa.us

almost 25 years ago

In reply to: Noname (#1)

Re: consider increasing WAL_FILES

newsreader@mediaone.net writes:

Should I worry?

Not unless you see that message frequently during routine operations.
Initial bulk data load doesn't count as routine ...

How do I increase WAL_FILES?

See the documentation.

regards, tom lane