question about WAL.

From: Chris Johnson <chris(at)sebis(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: question about WAL.
Date: 2002-09-05 22:24:42
Message-ID: 3D77D9AA.7080504@sebis.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

hi group,
I've been told to investigate a real-time "transaction logging" for
our website's database, currently running postgresql 7.1. It seems to
me that the WAL feature is what the boss is referring to but the
documentation only covers the basics (the recovery section doesn't
exist). I see from archives on google groups that recovery is not
implemented yet (as of april). I was wondering if current versions fully
supported WAL or if it's still under development? Or if there is another
approach to get an up-to-the-current log of transactions for backup and
recovery purposes? I'm currently using 'pg_dumpall' to get a backup
nightly but we would like a more up to date option in case of a crash. I
appologize if this is the wrong group of if this question is asked daily.

thanks to all,
chrisj

ps. please mail me directly as I'm not on the group yet

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Marc Mitchell 2002-09-05 23:30:45 Remote monitoring
Previous Message Nick Fankhauser 2002-09-05 20:50:54 Re: turn off auto-commit