Thread: Does postgresql support transaction logs
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
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
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