pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Sanjay Arora <skpobox@gawab.com>
To: pgsql-admin@postgresql.org
Subject: Best approach to database design, in this case?
Date: 27 Jun 2004 06:56:28 +0530
Message-ID: <1088299588.18791.81.camel@Sewak.Asr.Lan> (raw)

I am planning a vendor management module, which has to areas. One...A
database located in DMZ, that will have user registration info and
second in Green Segment of the Lan, which will have user information and
correspondence, in addition to user registration.

Now a user that comes in to register may already have a presence in the
main database and may have come to the DMZ database from an invitation
initiated from the main database. The DMZ DB is a subset of the main
database, but contact/product information submitted by user overwrites
that already existing.

Now what should be the process? DMZ cannot contact the Green Database
upon update, due to firewalling. So a periodic replication of records
has to happen triggered by something. Or should I put the entire
database in Green and use a SSH tunnel from the web-server in DMZ? What
are the security approaches to this and their implications?

Also, since the main database is heavily normalized and therefore
querying (from internal processes...users from the net would have low
registration & modification needs) would be much slower, I am planning
along two lines.

- Try to use materialized views.
- Try Single Master-Multi Slave Replication and use something like
pgpooling module announced in the announce mailing list today.

What pg contrib/third party modules may I use and what are their
reliability issues?

Also, how does pg deal with NAS, especially the low cost ones built with
EIDE or SATA drives? Anyone built one from low cost components? Looking
for tips on all issues involved...especially using open source and low
cost hardware as I am highly constrained by budgets.

All/Any tips, warnings, help, URLs, pointers to further reading will be
greatly appreciated.

With best regards.
Sanjay.





Message-ID: <1088299588.18791.81.camel@Sewak.Asr.Lan>
Permalink:  ../1088299588.18791.81.camel@Sewak.Asr.Lan/
Also on:    postgresql.org/message-id/1088299588.18791.81.camel@Sewak.Asr.Lan

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: skpobox@gawab.com
  Subject: Re: Best approach to database design, in this case?
  In-Reply-To: <1088299588.18791.81.camel@Sewak.Asr.Lan>
  References: <1088299588.18791.81.camel@Sewak.Asr.Lan>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox