pg.ddx.io pgsql-sql@postgresql.org mailing list archivehelp / color / mirror / Atom feed
specifying wal file size 2+ messages / 2 participants [nested] [flat]
* specifying wal file size @ 2008-03-31 23:41 gherzig@fmed.uba.ar 2008-04-01 04:45 ` Re: specifying wal file size Tom Lane <tgl@sss.pgh.pa.us> 0 siblings, 1 reply; 2+ messages in thread From: gherzig@fmed.uba.ar @ 2008-03-31 23:41 UTC (permalink / raw) To: pgsql-sql 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? The .backup file may have been created under windows, and im working on Linux. Could that be a problem? Thanks! Gerardo ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: specifying wal file size 2008-03-31 23:41 specifying wal file size gherzig@fmed.uba.ar @ 2008-04-01 04:45 ` Tom Lane <tgl@sss.pgh.pa.us> 0 siblings, 0 replies; 2+ messages in thread From: Tom Lane @ 2008-04-01 04:45 UTC (permalink / raw) To: gherzig@fmed.uba.ar; +Cc: pgsql-sql gherzig@fmed.uba.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 ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2008-04-01 04:45 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2008-03-31 23:41 specifying wal file size gherzig@fmed.uba.ar 2008-04-01 04:45 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox