-----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 <frampton@LinuxNinja.com> 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-----