-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hello:
Reposting this due to no responses. Does anybody have any experience with these issues? ;-( I am constructing a billing system using PostgreSQL, ODBC, and C++. I have a primary database set up on a beefy server which is fed 24/7 by a transaction feeder, and is also used for processing the billing. I have a 2nd server which is being used as a hot backup server, which is also being fed by the transaction feeder. However, billing processing does not run through the feeder, so I find myself doing a daily dump on the appropriate tables on the production server, deleting the old data from the backup, and importing with copy from. Needless to say, RServ would be a better solution for this. I'm not sure how I would set up RServ to access a remote database, however. Is this possible? Also, I would like to provide the ability for users to look up their billing data via a CGI interface, which would perform queries to yet another server, to be set up for R/O access only (for performance, and security). I was thinking of using RServ for this purpose as well, but an even better solution seems to be to run my production (or backup mirror) from a NetApp over Gb NFS so there's no issues with replication. Is it possible, safe, and advisable to share a PostgreSQL database file via NFS, as long as non-masters are only accessing it R/O? Thank you in advance for your advice. - ---------------< LINUX: The choice of a GNU generation. >------------- Steve Frampton <[EMAIL PROTECTED]> http://www.LinuxNinja.com GNU Privacy Guard ID: D055EBC5 (see http://www.gnupg.org for details) GNU-PG Fingerprint: EEFB F03D 29B6 07E8 AF73 EF6A 9A72 F1F5 D055 EBC5 -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.0 (GNU/Linux) Comment: For info see http://www.gnupg.org iD8DBQE7wq7cmnLx9dBV68URAruLAKCJdhc7l1E9Tphha/5fxWZp0QDyfwCgiugt mg5KBHCdrqEyT+MY14it1fU= =YWmp -----END PGP SIGNATURE----- ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
