database replication

From: lego lego <legoxx(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: database replication
Date: 2002-09-10 09:19:06
Message-ID: 20020910091906.20841.qmail@web14503.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

i want to ask if someone have experiance with data
replication for postgres. I know there is project
called postgres-r going on but it's still
unfinnished. But I need much simplier system more
mysql like. Having one server for insert that
are propagated to other servers used just for
selects.

I know i can probably do it myself with triggers and
some
deamon, but i want to ask if someone have done it
before,
as i don't like to reinvent wheel here;-)

I think that this cases should be taken in
consideration:

* one DB slows down
* one DB crash down
* resync DB after some transaction failure
* add new DB to system
* remove (temporarily) DBs from the system (for
trouble shooting).

I have tried http://pgreplicator.sourceforge.net
but it's not working very well for me.

Any linka and pointers will be helpfull.

Thanks

Peter

__________________________________________________
Yahoo! - We Remember
9-11: A tribute to the more than 3,000 lives lost
http://dir.remember.yahoo.com/tribute

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tourtounis Sotiris 2002-09-10 09:19:34 ???Varchar()
Previous Message Martijn van Oosterhout 2002-09-10 08:46:52 Re: How to get "next" record in a recordset