Re: specifying wal file size

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: gherzig(at)fmed(dot)uba(dot)ar
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: specifying wal file size
Date: 2008-04-01 04:45:36
Message-ID: 20357.1207025136@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

gherzig(at)fmed(dot)uba(dot)ar writes:
> Hi dudes. Im trying to find out how to deal with this. I just receive a
> 1.2 MB wal file (may some 'windows home version' do that?), and obviosly,
> when i try to recovery from there, get the 'incorrect file size' error.
> Acording to the docs, wal file size can be changed at compile time. Not so
> bad, i can do that. But where is that code?

> BTW: 1163398 bytes seems like a wrong size for any wal file, isnt?

WAL files must certainly be a power of 2 in size. I think you're
looking at a file-transfer error, or else the file got corrupted
on the source system. I rather doubt that your source knows how
to change the intended file size from 16MB anyway ;-)

regards, tom lane

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Raphael Bauduin 2008-04-01 15:50:42 difference between EXCEPT and NOT IN?
Previous Message gherzig 2008-03-31 23:41:32 specifying wal file size