In article
<8F4C99C66D04D4118F580090272A7A234D3340@sectorbase1.sectorbase.com>,
"Mikheev, Vadim" <vmikheev@sectorbase.com> wrote:
>> Is it OK to delete the files from pg_xlog? What will be the result?
> It's not Ok. Though you could remove files numbered from 000000000000000
> to 0000000000012 (in hex), if any.
OK, thanks. Is there any documentation on these files, and what
our options are if something like this happens?
>> Will I be able to avoid this problem by splitting the load data into
>> multiple files?
> Yes if you'll run CHECKPOINT command between COPY-s. You could also
> move logs to another FS. Vadim
I have the logs in /home/pgsqldata, and created another
location in /home2/pgsqldata for the database. Still
managed to fill it up. It's a *big* file.
With other RDBMS products I use, DB2 and Sybase, there
are options in the import/load/bcp utilities which commit
every n records, selectable by the user. I think having
a feature like this in COPY would greatly facilitate
data migrations (which is what I'm doing, and the reason
for such a big file). What do you think?
Thanks,
Gordon.
--
It doesn't get any easier, you just go faster.
-- Greg LeMond
