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

2005-04-29 Thread Ryan J. Cavicchioni
Enrico Weigelt wrote: > * Silvana Di Martino <[EMAIL PROTECTED]> wrote: > > > >>We just think it is easier and safer to encrypt the whole database, or even >>the whole disk, than try to understand what the law actually means. > > > BTW politicians should have to be enforced to tell people wha

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

2005-04-29 Thread Bruce Momjian
Ryan J. Cavicchioni wrote: > Enrico Weigelt wrote: > > * Silvana Di Martino <[EMAIL PROTECTED]> wrote: > > > > > > > >>We just think it is easier and safer to encrypt the whole database, or even > >>the whole disk, than try to understand what the law actually means. > > > > > > BTW politician

[ADMIN] Postges 8.0.2 Online backup Errors!

2005-04-29 Thread Pallav Kalva
Hi , I got this error while doing my online backups on the new postgres 8.0.2. I follow the same procedure as mentioned in the docs and the way i do in brief is 1) Put the database in backup mode with pg_start_backup 2) copy data cluster, I use tablespaces and my tables and indexes are in

Re: [ADMIN] Postges 8.0.2 Online backup Errors!

2005-04-29 Thread Bruce Momjian
Pallav Kalva wrote: > Hi , > > I got this error while doing my online backups on the new postgres > 8.0.2. I follow the same procedure as mentioned in the docs and the way > i do in brief is > > 1) Put the database in backup mode with pg_start_backup > 2) copy data cluster, I use tablespa

Re: [ADMIN] Postges 8.0.2 Online backup Errors!

2005-04-29 Thread Tom Lane
Pallav Kalva <[EMAIL PROTECTED]> writes: > bash-2.05b$ ./backup.sh b > 17/8E3DA9F0 > tar: tabledata/165899758/165958430: file changed as we read it > tar: Error exit delayed from previous errors > 17/8E8CB0A8 > bash-2.05b$ You may need to use a stupider version of tar that doesn't consider that an

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

2005-04-29 Thread Chris Browne
pgman@candle.pha.pa.us (Bruce Momjian) writes: I owe you a patch on runtime.sgml for the summary I did on "Use of Encryption." I just sent it... -- (format nil "[EMAIL PROTECTED]" "cbbrowne" "acm.org") http://www.ntlug.org/~cbbrowne/sap.html Rules of the Evil Overlord #78. "I will not tell my L

[ADMIN] Query regarding locale settings

2005-04-29 Thread saurabh nasa
I created a new directory and specified locale settings with initdb --locale=hi_IN.utf and created a new database with encoding set to unicode. But, while I can insert unicode strings correctly with JDBC, it gives the wrong answer while matching strings.I have not been able to find any reason for t

[ADMIN] pg_version_history

2005-04-29 Thread Ezequiel Tolnay
I found a table pg_version_history in the public schema (which we don't use). Does anyone know where this table comes from and what is it for? Also I'd like to implement a code versioning for the functions. Is there a package or a software to do this kind of things, so we can recover from it a

[ADMIN] connecting postgreSQL form Developer 2000 using ODBC

2005-04-29 Thread Md. Monjoor Khayer
Hi..I am Khayer from Bangladesh..I like to connect PostgreSQL from Developer 2000 using ODBCbut I could not make it possible.What are the possible steps to connect postgreSQL form Developer 2000 usingODBC.Please reply me as soon as possible.Thank you very much.Khayer.___

[ADMIN] Suse 9.2 stops booting while starting the postgres-server

2005-04-29 Thread bernd.lentes
Hello to everyone, I'm new to postgres. I Have installed a new SuSE 9.2 on a pc. I also installed the Postgres which was on the suse-cd's. psql --version says: 7.4.7 PG_VERSION in /var/lib/psql/data says: 7.4 Here is an extract from my pg_hba.conf: # TYPE DATABASEUSERIP-ADDRESS

[ADMIN] Post Gres triggers for trail

2005-04-29 Thread Mandar M Bhosale
I have difficulty in setting a trigger to have trail of my project   I need to update the modified_date of my database tables through trigger as   CREATE OR REPLACE TRIGGER taril_trigger AFTER UPDATE ON test_trigger FOR EACH ROWEXECUTE PROCEDURE pro_trail();   pro_trail(){BEGIN NEW.modified

[ADMIN] Unable to drop index

2005-04-29 Thread Oliver Duke-Williams
Hi, I have an error trying to drop an index using PostgreSQL 7.4.6 running on Solaris 2.9. The table on which the index was built is no longer present (it should have been dropped by my application after being used), but it would appear that the index was not dropped at the same time as the tab