Thread: Does postgresql support transaction logs

Does postgresql support transaction logs

From
Kelley Trombly-Freytag
Date:
I am evaluation postgresql as a replacement for an database
that supports almost real-time measurements. The current
database (Sybase) has transaction logs that can be dumped
periodically during the day, to be used for recovery support.
They are applied to the database dump to bring the data
back up-to-the-minute of the last transaction log dump.

I have searched the archives and found older messages referencing
transaction logs and postgresql, as in, "postgresql does not
support transaction logs now but we hope to in the future".

Has the furture arrived. Does the most recent version of postgresql
support dumpable and appliable transaction logs?

Thank you,

--
Kelley Trombly-Freytag
Fermilab
kfreytag@fnal.gov


Re: Does postgresql support transaction logs

From
Bruce Momjian
Date:
It is called point-in-time recovery and we are working on it for our
next release.

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

Kelley Trombly-Freytag wrote:
> I am evaluation postgresql as a replacement for an database
> that supports almost real-time measurements. The current
> database (Sybase) has transaction logs that can be dumped
> periodically during the day, to be used for recovery support.
> They are applied to the database dump to bring the data
> back up-to-the-minute of the last transaction log dump.
>
> I have searched the archives and found older messages referencing
> transaction logs and postgresql, as in, "postgresql does not
> support transaction logs now but we hope to in the future".
>
> Has the furture arrived. Does the most recent version of postgresql
> support dumpable and appliable transaction logs?
>
> Thank you,
>
> --
> Kelley Trombly-Freytag
> Fermilab
> kfreytag@fnal.gov
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>

--
  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

Re: Does postgresql support transaction logs

From
Palle Girgensohn
Date:
Hi!

I *think* it is planned for the upcoming 7.4 release.

/Palle

--On måndag, mars 10, 2003 10.21.33 -0600 Kelley Trombly-Freytag
<kfreytag@fnal.gov> wrote:

> I am evaluation postgresql as a replacement for an database
> that supports almost real-time measurements. The current
> database (Sybase) has transaction logs that can be dumped
> periodically during the day, to be used for recovery support.
> They are applied to the database dump to bring the data
> back up-to-the-minute of the last transaction log dump.
>
> I have searched the archives and found older messages referencing
> transaction logs and postgresql, as in, "postgresql does not
> support transaction logs now but we hope to in the future".
>
> Has the furture arrived. Does the most recent version of postgresql
> support dumpable and appliable transaction logs?
>
> Thank you,
>
> --
> Kelley Trombly-Freytag
> Fermilab
> kfreytag@fnal.gov
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org