Postgres Pro
Downloads
Home   >   mailing lists

consider increasing WAL_FILES - Mailing list pgsql-general

From newsreader@mediaone.net
Subject consider increasing WAL_FILES
Date
Msg-id 20010413150712.A8229@dragon.universe
Whole thread Raw
Responses Re: consider increasing WAL_FILES
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Shared memory failure?
Next
From: Tom Lane
Date:
Subject: Re: Shared memory failure?