From: | Helge Bahmann <bahmann(at)math(dot)tu-freiberg(dot)de> |
---|---|
To: | Leandro Fanzone <leandro(at)hasar(dot)com> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Transactions |
Date: | 2000-12-05 15:25:20 |
Message-ID: | Pine.LNX.4.21.0012051607440.1837-100000@lothlorien.stunet2.tu-freiberg.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On Tue, 5 Dec 2000, Leandro Fanzone wrote:
> I'm having problems with transactions, lately. I'm checking
> power-failure conditions on my psql-based programs, and found that a
> simple loop with
>
> BEGIN TRANSACTION
> INSERT INTO test VALUES('any #n');
> COMMIT TRANSACTION
>
> leaves me with no records inserted at all after an abrupt reset on the
> server. The loop is outside the transaction, id est, the BEGIN/COMMIT is
> executed every time. Is there any way to assure this, I mean, to
> actually write the records and to not rely on the cache to do it?
> Because I think it is somewhere floating in the Linux cache and it's
> never wrote physically, and when the power is down, everything is lost.
> Thank you in advance,
Do you accidently pass the "-F" option to the postgres backends? This will
disable fsync (and boost performance). Remove the "-o -F" option to
postmaster from your start-up script and everything should be fine.
You will still experience data loss if you do not use a journalling
filesystem; get the ext3 patches or try reiserfs.
cu,
Helge
--
Hi! I'm a .signature virus! Put me into your .signature and help me spread!
% rm * .o
rm: cannot remove '.o': No such file or directory
From | Date | Subject | |
---|---|---|---|
Next Message | Leandro Fanzone | 2000-12-05 15:35:32 | Re: Transactions |
Previous Message | Tom Lane | 2000-12-05 15:21:04 | Re: Transactions |