From: <la...@cl...> - 2008-05-28 07:03:43
|
hello all...our business has now the need to replicate our sl/postgres db from our main office in ca to ny as the ny system (public and outside of our firewall) has the need to generate non-critical read only invoice and inventory reports. our requirements are real simple and slony-i seems to be an overkill. we have also evaluated pgpool-ii but it was ruled out as it doesn't support x509 ssl connection (a must for business data). oralce and informix would have been nice as they both provide standby read-only databases that are very simple to manage. it is too bad that you cannot access a standby postgres database. so my question is anyone has any comments on what other tools out there that may allow us to create a postgres standby read-only database? if nothing we may just have to walk down the slony-i path...thanks ahead for any comments. regards, tim |