Re: [ADMIN] Database Encryption (now required by law in Italy)

2004-03-06 Thread Silvana Di Martino
Alle 20:34, venerdì 5 marzo 2004, scott.marlowe ha scritto: > Sorry, but that's the wrong answer. Once someone has root on a unix box > her can do ANYTHING he wants. and he can cover his tracks. If the > encryption takes place on his box, he can attach to the process doing the > encryption and /

Re: [ADMIN] Database Encryption (now required by law in Italy)

2004-03-06 Thread Silvana Di Martino
Alle 23:23, venerdì 5 marzo 2004, Michael Chaney ha scritto: > > BTW: if you have a USA-based company and collect info regarding Italian > > people, you have to comply with this absurd Italian law. Funny, isn't it? > > No, we don't. We're not bound by Italian law, only US law. Unfortunately, that

Re: [ADMIN] Database Encryption (now required by law in Italy)

2004-03-06 Thread Silvana Di Martino
Alle 21:29, venerdì 5 marzo 2004, Bruno Wolff III ha scritto: > On Fri, Mar 05, 2004 at 20:12:37 +, > > Silvana Di Martino <[EMAIL PROTECTED]> wrote: > > BTW: if you have a USA-based company and collect info regarding Italian > > people, you have to comply with this absurd Italian law. Funny,

Re: [ADMIN] Postgresql functions

2004-03-06 Thread Grega Bremec
...and on Wed, Mar 03, 2004 at 12:04:25AM +, Ivan Dario Salazar used the keyboard: > Hi there... > > I write it becouse i need to know where can i get a "SPECIFIC DOCUMENT" > with the "Postgresql Administration Functions" like > > - Create User > - Create Group Hello Ivan, There are a coup

Re: [ADMIN] How to do fast, reliable backups?

2004-03-06 Thread Silvana Di Martino
Alle 21:37, venerdì 5 marzo 2004, Chris Ruprecht ha scritto: > I am wondering how you guys back up your databases. Say, I have a 20 GB > database, data and indexes. If I run pg_dump on this, it backs up the > schema and the data. When I have to restore this, I whould have to run this > through psql

Re: [ADMIN] Help! Regarding Pg for posgreSQL

2004-03-06 Thread Sam Barnett-Cormack
In my perl scripts, I have: use DBI; use DBD:Pg; So maybe this is what you need? On Mon, 1 Mar 2004, Amit Kush wrote: > Hi! > I came to ur e-mail address from one of the sites through google. Hope u > could help me please. > I am using red hat linux and running my perl programs with postgresql

Re: [ADMIN] Help! Regarding Pg for posgreSQL

2004-03-06 Thread VanderLeeden
Hi Amit, you can check the pgperl Project -- pgperl pgperl is a native Perl interface to PostgreSQL. It clearly follows libpq's API. HomePage= http://gborg.postgresql.org/project/pgperl/projdisplay.php The most recent version is Pg-2.0.2 and if you install it on your node it will provide Pg.pm. A

Re: [ADMIN] Help! Regarding Pg for posgreSQL

2004-03-06 Thread Bruno Wolff III
On Sat, Mar 06, 2004 at 12:52:33 +, Sam Barnett-Cormack <[EMAIL PROTECTED]> wrote: > In my perl scripts, I have: > > use DBI; > use DBD:Pg; > > So maybe this is what you need? Pg.pm is an alternate perl module that is closer to libpq than DBD::Pg. ---(end of broadc

Re: [ADMIN] How to do fast, reliable backups?

2004-03-06 Thread Andrew Sullivan
On Sat, Mar 06, 2004 at 01:39:28PM +, Silvana Di Martino wrote: > a slave replica of your main database server. Should you have any problem > with the main server, just switch the IP addresses of the master and slave > servers and you are up and running again. The switching takes a few > mil

Re: [ADMIN] Database Encryption (now required by law in Italy)

2004-03-06 Thread Gorshkov
On March 6, 2004 03:59, Silvana Di Martino wrote: > > Both USA and UE companies have to comply with WTO rules. There are > international agreements between USA and EU regarding online commerce and > these agreements states that a company in EU cannot violate the law on > commerce of USA if it oper

Re: [ADMIN] Help! Regarding Pg for posgreSQL

2004-03-06 Thread Sam Barnett-Cormack
On Sat, 6 Mar 2004, Bruno Wolff III wrote: > On Sat, Mar 06, 2004 at 12:52:33 +, > Sam Barnett-Cormack <[EMAIL PROTECTED]> wrote: > > In my perl scripts, I have: > > > > use DBI; > > use DBD:Pg; > > > > So maybe this is what you need? > > Pg.pm is an alternate perl module that is closer to l

Re: [ADMIN] How to do fast, reliable backups?

2004-03-06 Thread Silvana Di Martino
Alle 16:30, sabato 6 marzo 2004, Andrew Sullivan ha scritto: > Asynchronous replication with automatic failover is _dangerous_, > because you can strand records. Many commercial systems do this with > what they describe as conflict-management; in truth, this usually > amounts to marking _both_ rec

Re: [ADMIN] Database Encryption (now required by law in Italy)

2004-03-06 Thread Silvana Di Martino
Alle 13:55, sabato 6 marzo 2004, Lamar Owen ha scritto: > On Friday 05 March 2004 03:34 pm, scott.marlowe wrote: > > Sorry, but that's the wrong answer. Once someone has root on a unix box > > her can do ANYTHING he wants. and he can cover his tracks. > > This is what things like the capabilities