[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Postgresql Replication
- Subject: Postgresql Replication
- From: ..hidden..
- Date: Wed, 28 May 2008 00:00:59 -0700 (PDT)
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