| 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: | Whole Thread | Raw Message | 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
| 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 |