There has got to be some persistence, there will be a lot of tables and metadata and it may have to handle validation requirements for other apps doing secure file transfer and a bespoke secure http proxy and it's going to be a speculative buffer against protocol based worms crossing into the production environment.
On 7/5/07, Richard Huxton <[EMAIL PROTECTED]> wrote:
Patrick Carroll wrote: > I am architecting a solution for an interface between a highly secure > production environment and a corporate network which involves transfer of > records from Oracle and SQL Server through an intermediary "firewall DB", a > Postgres Instance, to SQL Server/ Oracle. I anticipate that there will > either be direct database links or jdbc connections and stored > procedures to > pass data. > > Does anybody have a view on likely issues I may have in practice, should I > really be looking at existing commercial technologies or is PostgreSQL the > right technology? I'm not sure what PostgreSQL is doing for you here, unless you need some sort of "buffer" to cope with network bandwidth problems. Why not just have a secured application sitting in the dmz/on firewall and connect to both sides transferring for you? -- Richard Huxton Archonet Ltd