Re: Replication to less secure slave server

On Jan 25, 2011, at 7:04 AM, alys brett wrote:

> I am planning a system that will be hosted within a secure network with very limited access. All access to the
databasewill be from within this network. I need to have a copy of the database available on a much less secure server,
whichwill allow access for web applications. This copy of the database is considered sacrificial. 
>
> The replication methods I have read about are focussed on creating standby servers to take over if the primary
becomesunavailable. For this, there is obviously a requirement that the slave be able to connect to the database on the
master.This is not allowed by our security set-up (that's the whole reason for having the replica database).  
>
> I need to somehow push the changes from the master out to the slave. The database is not very complex or large (two
maintables with < 100,000 rows) and new rows will be added only every few minutes. A minute or so lag on the copy
databaseis acceptable. 

I have similar requirements, so I have the master initiate an SSH reverse tunnel to the replica, where pg connects to
thelocal port that is the remote end of that tunnel. 

--
Scott Ribe
scott_ribe@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice