Re: [SL] Postgres replication (me three)

[Dr E. L. <el...@li...>]

Tim,

we would be extremely interested in a solution for exactly this issue.
Not only for SL, by the way, we have another database that we would like
to replicate read-only in a simple fashion.

Please post any solution that you may find, or if it's not of interest
to the list, please email me directly.

greetings, el

on 5/28/08 8:04 AM la...@cl... said the following:
> 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
						
-- 
Dr. Eberhard W. Lisse  \        / Obstetrician & Gynaecologist (Saar)
el...@li... el108-ARIN / *     |   Telephone: +264 81 124 6733 (cell)
PO Box 8421             \     /   Please do NOT email to this address
Bachbrecht, Namibia     ;____/        if it is DNS related in ANY way