I have ever used Slackware, so no rpm's for me... gives me some control
on what to include and what not... but it learned me how to do compile
stuff ;-)
Here is what I would do:
locate all Postgresql binaries. I suppose it's in /usr/bin
dump _all_ your data (maybe stopping the postmaster and mak
On March 8, 2004 09:07, Andrew Sullivan wrote:
> On Mon, Mar 08, 2004 at 12:07:23PM +, Silvana Di Martino wrote:
> > This seems to give to this "db encryption" issue the status of "global
> > relevance" that would deserve a more systematic approach. I mean: no
> > homegrown solutions - rather h
On Mon, 8 Mar 2004, Silvana Di Martino wrote:
> Alle 15:08, lunedì 8 marzo 2004, Stephan Szabo ha scritto:
> > That's what I figured, but given a system where the password is given on
> > startup to the database, you would need another layer for the security,
> > have you though about how that wo
Can PostgreSQL use multiple processors if they are present in a
computer, and if so, how much will it speed up database server? Tnx in
advance.
Linux OS, can explode multiprocessors servers, therefore, each session
on postgres (a session = a process), can be allocated in a processor.
Mult
Alle 19:19, lunedì 8 marzo 2004, Bruce Momjian ha scritto:
> The user could decrypt it and store it in a temporary table, and join to
> that table in queries, and pass that decrypted password column to
> pg_crypto functions, but do we guarantee that that temp table would not
> be on the disk if the
Alle 17:29, lunedì 8 marzo 2004, Joe Conway ha scritto:
> Silvana Di Martino wrote:
> > Oracle has a built-in feature for encrypting/decrypting this password's
> > password.
>
> Right, and this master password is only protected because Oracle is
> closed source. It is not possible to do the same th
On Mon, 8 Mar 2004, mlists wrote:
> Can PostgreSQL use multiple processors if they are present in a
> computer, and if so, how much will it speed up database server? Tnx in
> advance.
Yes, Postgresql can use >1 CPU. Each process can use one, and only one
CPU by itself. however, the OS can us
Alle 15:08, lunedì 8 marzo 2004, Stephan Szabo ha scritto:
> That's what I figured, but given a system where the password is given on
> startup to the database, you would need another layer for the security,
> have you though about how that would work? A not terrible option would be
> to compose th
Alle 12:30, lunedì 8 marzo 2004, Peter Galbavy ha scritto:
> Silvana Di Martino wrote:
> > Oracle has a system similar to pgcrypto but more sophisticated. I do
> > not know if it can use encrypted indexes, encrypted dates and
> > encrypted times (it is likely but I did not tried, yet). It stores
>
On Thu, 4 Mar 2004, Indibil wrote:
> Hi:
>
> I have a PostgreSQL 7.2.2 running in a Linux Mandrake 8.2 Server.
> I want to upgrade to PostgreSQL 7.3
> I would like to accomplish this by installing fit rpm packages, because my
> linux skills are limited.
> However, there aren't any packages of Po
On Sat, 6 Mar 2004, Dario Ottaviano wrote:
> Hi, i use Postgresql 7.2 on a windows server (Win 2000 Server).
> The problem is that when i write a date into a timestamp field of a table,
> it writes it in to No-Europe format.
7.2 had some issues with accepting the wrong date formats and just
mang
Silvana Di Martino wrote:
> And this one shows a feasible solution for PostgreSQL (using pgcrypto):
>
> "Oracle has one of the best solutions for in-database encryption-decryption
> keys. It stores the keys, encrypted, in a table. For users with access
> rights, it decrypts the keys, which in tu
> BTW: It looks like I'm the only one here facing this problem. That's
> surprising, given the number of countries that have a law
> like the italian
> one and the wide diffusion of PostgreSQL.
This is normal because the task to encrypt database is usually done at
hardware/OS level. In general t
On Mon, 2004-03-08 at 02:23, mlists wrote:
> Can PostgreSQL use multiple processors if they are present in a
> computer, and if so, how much will it speed up database server? Tnx in
> advance.
Postgres has no special functionality regarding processors. Each
connection is handled by a separate pr
On Mon, 8 Mar 2004, Silvana Di Martino wrote:
> Alle 17:40, domenica 7 marzo 2004, Stephan Szabo ha scritto:
> > Who has access to the unencrypted versions of the data? Are there people
> > who will have access to the database who might have access to some of the
> > encrypted data but not all or
On Mon, Mar 08, 2004 at 08:37:37 +,
Silvana Di Martino <[EMAIL PROTECTED]> wrote:
> Alle 18:19, domenica 7 marzo 2004, Joe Conway ha scritto:
> > Silvana Di Martino wrote:
> > > 4) What could actually solve our problem is something like the following
> > > scenario. Imagine that postmaster (o
On Mon, Mar 08, 2004 at 12:07:23PM +, Silvana Di Martino wrote:
> This seems to give to this "db encryption" issue the status of "global
> relevance" that would deserve a more systematic approach. I mean: no
> homegrown solutions - rather have the community to develop a specific,
> standard
Silvana Di Martino wrote:
> Oracle has a system similar to pgcrypto but more sophisticated. I do
> not know if it can use encrypted indexes, encrypted dates and
> encrypted times (it is likely but I did not tried, yet). It stores
> its "global encryption password" into a system table in encrypted
>
Alle 09:32, lunedì 8 marzo 2004, Peter Galbavy ha scritto:
> Perhaps, given the potential commercial necessities of this for larger
> organisations, find out what Oracle and IBM propose doing or have
> implemented ?
I do not know of IBM.
Oracle has a system similar to pgcrypto but more sophistica
For the (very few?) people interested in this topic:
"Time is Right for Database Encryption"
Dec 9, 2003 | By Don MacVittie
Published on NetworkComputing
(www.nwc.com)
http://www.nwc.com/shared/article/printFullArticle.jhtml;jsessionid=REGYCTEZ5MNJQQSNDBGCKHY?articleID=16401578
This paragraph
It looks like that also USA-resident DBAdmins have to protect their data, at
least when their data are related to someone else's personal health:
http://www.cms.hhs.gov/hipaa/
http://www.hhs.gov/ocr/hipaa/
http://www.hipaa.org/
This seems to give to this "db encryption" issue the status of "gl
Can PostgreSQL use multiple processors if they are present in a
computer, and if so, how much will it speed up database server? Tnx in
advance.
Dragan
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
Silvana Di Martino wrote:
> Actually, the Italian law is an implementation of a EU directive
> strictly inspired to the existing UK law. It will affect all EU in a
> few years.
Perhaps, given the potential commercial necessities of this for larger
organisations, find out what Oracle and IBM propos
Alle 22:16, domenica 7 marzo 2004, [EMAIL PROTECTED] ha scritto:
> The EU directive (and therefore the laws of indiviual countries) requires
> that if someone gets access to your *DATABASE* they cannot get personal
> details of individuals out of it. That is all. It is intended to protect
> peop
Alle 17:40, domenica 7 marzo 2004, Stephan Szabo ha scritto:
> Who has access to the unencrypted versions of the data? Are there people
> who will have access to the database who might have access to some of the
> encrypted data but not all or someone who has access to the database but
> none of th
25 matches
Mail list logo
