Transaction logging?
Is there any documentation on database recovery. I am new to Postgres. I
really like what I see. I have written a membership database application
for a NPO in New Mexico. It is written in Access 97. I want to migrate to
a real database engine and I am strongly considering Postgres. I have
several questions:
1) Is transaction logging available, how does it work, and how do I set
it up. I have been through most of the on-line documentation several time
(available on the internet) and have not found anything that talks about
transaction logging.
2) Database recovery. If I make a back up at 10:00am and the database
goes south at 1:00pm, can I restore back to 10:00am and automatically
re-post any/all transactions that occurred between 10:00am and 1:00pm
without requiring the users to re-enter all their data?
3) Is any working on mirroring or shadowing? I would like to be able
have a backup database engine on a second back-up server get automatically
updated soon after an update is posted to the main server.
Thanks, Michael
On Sat, 13 Feb 1999, Michael Davis wrote:
Is there any documentation on database recovery. I am new to Postgres. I
really like what I see. I have written a membership database application
for a NPO in New Mexico. It is written in Access 97. I want to migrate to
a real database engine and I am strongly considering Postgres. I have
several questions:
1) Is transaction logging available, how does it work, and how do I set
it up. I have been through most of the on-line documentation several time
(available on the internet) and have not found anything that talks about
transaction logging.
2) Database recovery. If I make a back up at 10:00am and the database
goes south at 1:00pm, can I restore back to 10:00am and automatically
re-post any/all transactions that occurred between 10:00am and 1:00pm
without requiring the users to re-enter all their data?
3) Is any working on mirroring or shadowing? I would like to be able
have a backup database engine on a second back-up server get automatically
updated soon after an update is posted to the main server.Thanks, Michael
Transaction logging and database recovery have all received
considerable discussion, but are not yet implemented. Furthermore,
to my knowledge they are not included in the upcoming release of
v 6.5.
I am unaware of any efforts to implement database replication.
Marc Zuckman
marc@fallon.classyad.com
_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_
_ Visit The Home and Condo MarketPlace _
_ http://www.ClassyAd.com _
_ _
_ FREE basic property listings/advertisements and searches. _
_ _
_ Try our premium, yet inexpensive services for a real _
_ selling or buying edge! _
_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_