From: | Marc Howard Zuckman <marc(at)classyad(dot)com> |
---|---|
To: | Michael Davis <michael(dot)davis(at)prevuenet(dot)com> |
Cc: | "'pgsql-hackers(at)postgreSQL(dot)org'" <pgsql-hackers(at)postgreSQL(dot)org> |
Subject: | Re: [HACKERS] Transaction logging? |
Date: | 1999-02-14 00:51:33 |
Message-ID: | Pine.LNX.4.02A.9902131949340.30728-100000@fallon.classyad.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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(at)fallon(dot)classyad(dot)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! _
_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas G. Lockhart | 1999-02-14 04:19:25 | Patches applied for v6.4.3 |
Previous Message | Michael Davis | 1999-02-14 00:47:04 | Transaction logging? |