Remote database questions (NFS shared access, RServ) - Mailing list pgsql-admin

From Steve Frampton
Subject Remote database questions (NFS shared access, RServ)
Date
Msg-id Pine.LNX.4.33.0110050342570.16243-100000@astro.phpwebhosting.com
Whole thread Raw
In response to Re: Problems getting rserv working properly  ("pgsql-admin" <pgsql-admin@fc.emc.com.ph>)
List pgsql-admin
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hello:

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

iD8DBQE7vWY3mnLx9dBV68URAnQ0AJ92iZAsLkwcmtq8AzOK9NVoiZZT2gCeMHEz
3CZfmNcKahm67S6gfNtWX2k=
=JVfy
-----END PGP SIGNATURE-----


pgsql-admin by date:

Previous
From: Steve Frampton
Date:
Subject: Re: Problems getting rserv working properly
Next
From: "Chris Ruprecht"
Date:
Subject: Slightly off topic - Hardware Question