Re: [HACKERS] Transaction logging?

Поиск
Список
Период
Сортировка
От Marc Howard Zuckman
Тема Re: [HACKERS] Transaction logging?
Дата
Msg-id Pine.LNX.4.02A.9902131949340.30728-100000@fallon.classyad.com
обсуждение исходный текст
Ответ на Transaction logging?  (Michael Davis <michael.davis@prevuenet.com>)
Список 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@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!                      _
_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Michael Davis
Дата:
Сообщение: Transaction logging?
Следующее
От: "Thomas G. Lockhart"
Дата:
Сообщение: Patches applied for v6.4.3