Re: [SL] Postgres replication

[Adam V. <amv...@gm...>]

la...@cl... wrote:
> 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
If you go the route you intent on, I'd guess slony is your best option.  
Of course there are other ways to do this too, like manually scripting a 
db export import daily.

However with knowing just the info you provided, setting up a 
master-slave itself seems like overkill.  What about a VPN?  Or setting 
up SL on it's own host?  My SL server isn't sharing it's IP with other 
domains, so for me a default to deny firewall covers virtually all my 
security needs.  You can always run SSL on it if you like.

-- 
Adam Vandemore
Systems Administrator
IMED Mobility