Обсуждение: question about WAL.

Поиск
Список
Период
Сортировка

question about WAL.

От
Chris Johnson
Дата:
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


Re: question about WAL.

От
Bruce Momjian
Дата:
I understand.  We will have point-in-time recovery in 7.4, which will be
perhaps 9 months away.

---------------------------------------------------------------------------

Chris Johnson wrote:
> 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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073