From: IvoD <gordion@quick.cz>
To: pgsql-general@postgresql.org
Subject: Re: Database Selection
Date: 25 Apr 2006 23:30:23 -0700
Message-ID: <1146033023.579598.54890@v46g2000cwv.googlegroups.com> (raw)
References: <1145863743.280424.116910@y43g2000cwc.googlegroups.com>
<BAY101-DAV104E25204EDB4E872DA29FA3BE0@phx.gbl>
<1145946406.876724.302030@g10g2000cwb.googlegroups.com>
<1145980154.23538.212.camel@state.g2switchworks.com>
<60u08hp8id.fsf@dba2.int.libertyrms.com>
> smarl...@g2switchworks.com (Scott Marlowe) writes:
> > About the security thing. Security is a process, and you won't get
> > it from using two different database engines.
>
> I'd argue that security is an "emergent property" which is either
> supported by or undermined by particular facts/features/configurations.
>
I had other "security" aspect on my mind - one half of the newsgroups
data will be accessible from public part of web pages, second part and
the whole company data system will be accessible from private part of
web pages; newsgroups database must have read/write web access, company
database will have read only web access and read/write access from 3
specific IPs.
Lets assume two databases+two database engines:
If somebody hacks the newsgroups database and gets the read/write
access then he cannot access data from the company database (different
engine, different engine type).
And now lets assume two databases+one database engine:
If somebody hacks the newsgroups database and gets the read/write
access then he could switch database under the same hacked access and
get the read/write access to company data (if somebody gets access to
protected database through (at least) the "only local
access+login+password" restrictions then I must expect he knows how to
switch (hack) to any connected database under the same engine).
That is why I wanted to separate two databases using two different
database engines (in order to increase the standard security covered by
other security rules)
But this idea is maybee too paranoiac and disadvantages of two
different engines exceed the security benefits (maybe hypothetic)
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-general@postgresql.org
Cc: gordion@quick.cz
Subject: Re: Database Selection
In-Reply-To: <1146033023.579598.54890@v46g2000cwv.googlegroups.com>
References: <1145863743.280424.116910@y43g2000cwc.googlegroups.com> <BAY101-DAV104E25204EDB4E872DA29FA3BE0@phx.gbl> <1145946406.876724.302030@g10g2000cwb.googlegroups.com> <1145980154.23538.212.camel@state.g2switchworks.com> <60u08hp8id.fsf@dba2.int.libertyrms.com> <1146033023.579598.54890@v46g2000cwv.googlegroups.com>
* 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