A program that acts as an interface between the rdbms and whatever wants the files can be constructed easilly. Personally I would look into using java to create an applet that uses jdbc to get the files from the rdbms and then uses regular java libraries to "ftp" it. Stream to stream essentially. The files extracted from the rdbms never need to exist on the fs, only in memory. Geoff Sent from my BlackBerry wireless handheld. -----Original Message----- From: John R Pierce <pierce at hogranch.com> Date: Sat, 06 Oct 2007 13:42:42 To:CentOS mailing list <centos at centos.org> Subject: Re: [CentOS] near-realtime file system replication gjgowey at tmo.blackberry.net wrote: > If using a file system for the file storage isn't mandatory then I would go with an rdbms such as Postgres with the file stored in a blob field of a table. If the systems are in the same location and can use a shared Filesystem then I would look into getting a netraid scsi card or something similar. The netraid cards have the very nice capability of all sitting on a single scsi bus along with the datastore device (a hard drive or hdd array). There's no replication that occurs because they are all using the same data source jointly. > The application for which I have an immediate requirement actually uses postgres *and* files. the files are required because of stupid external reasons, they are collected and FTP'd to another system beyond our control. I'm already intending to evaluate Slony-I for the postgres replication. _______________________________________________ CentOS mailing list CentOS at centos.org http://lists.centos.org/mailman/listinfo/centos