Thread: consider increasing WAL_FILES

consider increasing WAL_FILES

From
newsreader@mediaone.net
Date:
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

Re: consider increasing WAL_FILES

From
Tom Lane
Date:
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