Re: [ADMIN] hung postmaster when client machine dies?

2004-05-08 Thread Peter Galbavy
Goulet, Dick wrote: > Hope you don't mind if I disagree. Most OS's that have a tcp/ip > layer also have a parameter therein called tcp_keep_alive. They also > set this parameter to infinity. The purpose of tcp_keep_alive is to > have the OS kernel periodically verify that all tcp/ip connections

Re: [ADMIN] License for PostgreSQL for commercial purpose

2004-03-28 Thread Peter Galbavy
Tom Lane wrote: > Neither of those readings is correct. The correct interpretation is > that the copyright holders (us and UCB, in the case of Postgres) > aren't charging any fee. This does not prohibit others from charging > for their own efforts. As I said in my original reply, intention has l

Re: [ADMIN] License for PostgreSQL for commercial purpose

2004-03-28 Thread Peter Galbavy
Eric Yum wrote: > http://www.postgresql.org/licence.html You should get your local legal professional to give an opinion if you intend to redistribute. One specific area of contention amongst "BSD license" people is the phrase: "... for any purpose, without fee, and ..." Some opine that this mea

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

2004-03-08 Thread Peter Galbavy
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 >

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

2004-03-08 Thread Peter Galbavy
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

Re: [ADMIN] hanging for 30sec when checkpointing

2004-02-11 Thread Peter Galbavy
scott.marlowe wrote: > Oh, spreading misinformation isn't lying? You live in a different > world than I do. Again, I apologise if you took my comment so strongly. I can understand when something that someone works on so hard is critisised. OTOH however, your original post that I replied to, was v

Re: [ADMIN] hanging for 30sec when checkpointing

2004-02-10 Thread Peter Galbavy
scott.marlowe wrote: > I don't know who you think you are, but I've physically tested the > stuff I'm talking about. Care to qualify what you mean? I would genuinely be interested in seeing the results and the methodology. > IDE drives (all the ones I've ever tested) LIE about their write > cach

Re: [ADMIN] hanging for 30sec when checkpointing

2004-02-07 Thread Peter Galbavy
scott.marlowe wrote: > Also, running on SCSI drives will be much faster than running on IDE > drives if the IDE drives have their caches disabled like they should, > since they lie otherwise. Since SCSI disks don't usually lie, and are > designed to handle multiple requests in parallel, they are m

Re: [ADMIN] Timestamp of insertion of the row.

2003-06-11 Thread Peter Galbavy
Anagha Joshi wrote: > Hi, > Is there any way to know data & time when the row is inserted into a > table? A timestamp column with a default value of 'now' ??? This will only work for inserts and not updates. Peter ---(end of broadcast)--- TIP 5: H

Re: [ADMIN] pg or DBI

2002-10-26 Thread Peter Galbavy
> I have used pg to connect to postgres. However, I have seen a lot of > people use DBI. Are there any advantages/disadvantages in using one or the > other for connecting to postgres via perl. Also, which one is more widely > used? Thanks for your input. I have never used Pg but I had a quick

Re: [ADMIN] Encryption.

2001-04-11 Thread Peter Galbavy
> I just want to encrypt the database to stop others looking at it as it > will probably be hosted in an environment that I don't have full control > over. Though, if it is encrypted, the scripts to decrypt it will also be > on the same system to display information from the database to the > webp

Re: [ADMIN] Encryption.

2001-04-10 Thread Peter Galbavy
Perhaps the first question you should be asking and answering is who/what are you trying to protect your data from ? Are you try to stop unauthorised people seeing it ? Changing it ? Adding to it ? What ? Once you do that, the solution tends to direct itself. rgds, -- Peter Galbavy Knowledge

Re: [ADMIN] binding to a specific IP address

2000-10-19 Thread Peter Galbavy
> No, not yet. I have a patch against 7.0, but it does not apply. I hope > to merge it in before 7.1 beta. Thanks - I'll wait :) Peter

[ADMIN] binding to a specific IP address

2000-10-19 Thread Peter Galbavy
ilar for a server. In case it is relevant, this is an OpenBSD server. rgds, -- Peter Galbavy Knowledge Matters Ltd. http://www.knowledge.com/

Re: [ADMIN] Firewall setup

2000-07-07 Thread Peter Galbavy
> Voila! You have yourself an ultra-secure site, as long as you properly lock > down your firewall (turn off telnet, ftp, etc.). Not trying to start a reigious war, but for this sort of thing look at OpenBSD (http://www.openbsd.org) Apart from the ongoing code audit, the transparent filtering br

Re: [ADMIN] HSA (Highly Scalable Architecture) Distribution and replication

1999-10-28 Thread Peter Galbavy
a transaction log from a *single* central update server (writer) to update multiple readers, running in '-F' mode. Not yet tried it. Regards, -- Peter Galbavy Knowledge Matters Ltd http://www.knowledge.com/

Re: [ADMIN] How to replicate databases?

1999-06-10 Thread Peter Galbavy
e past but I can't find a clear answer. > > > > Thanks in advance. > > > > Simon. > > -- > ========== > "There are no kernel hackers in Ireland. They spend all their time in the pub" > Alan Cox > == > > > > -- Peter Galbavy Knowledge Matters Ltd http://www.knowledge.com/