[ADMIN] pgpool

2006-07-05 Thread adey
Please could someone give me an idea of what pgpool is, and where I can research it? I have run a search on postgresql.org and found many references, but they don't explain what it is, and it doesn't appear in the documentation index of the v8.1 manuals.

[ADMIN] solaris and postgresql and locale

2006-07-05 Thread Palle Girgensohn
Hi! I'm having trouble setting a locale other than C when running initdb. "locale -a" reveals the appropriate locale, sv_SE.UTF-8, and it has been installed, but initdb just complains "cannot set locale" and uses C instead. This is not a postgres problem, same thing happens with xterm, but I

[ADMIN] corruption since 7.4.13 update ?

2006-07-05 Thread FM
Hello, I'e got a very strange (scary) problem. Look at that : itu_test-# \d ERROR: cache lookup failed for relation 1024 itu_test=# \q [EMAIL PROTECTED] ~]$ psql -h pisa itu_test itu_test=# \d ERROR: cache lookup failed for relation 1024 itu_test=# select * from zones; zone_id | code | regio

Re: [ADMIN] Wrap (obfuscate) code

2006-07-05 Thread Rodrigo De Leon
On 7/5/06, Scott Marlowe <[EMAIL PROTECTED]> wrote: Or, just hire a crusty old perl programmer and have him write them all as one line, super compact perl scripts and use plperl. ;^) ROFLMAO! The plpgsql_o idea sounds cool, but it seems I'm the only one that presented such a need :( Maybe no

Re: [ADMIN] Wrap (obfuscate) code

2006-07-05 Thread Joshua D. Drake
On Wednesday > Or, just hire a crusty old perl programmer and have him write them all > as one line, super compact perl scripts and use plperl. I thought we were actually trying to *help* people on this list... ;) Joshua D. Drake > > ;^) -- === The PostgreSQL Company: Command Prompt, Inc.

Re: [ADMIN] Wrap (obfuscate) code

2006-07-05 Thread Scott Marlowe
On Tue, 2006-07-04 at 20:51, Tom Lane wrote: > "Rodrigo De Leon" <[EMAIL PROTECTED]> writes: > > I would be quite a bonus to have equivalent functionality in PG. > > Write your functions in C and give them precompiled libraries. > Yes, also theoretically decompilable, but plenty hard ... plus > th

[ADMIN] %psql help

2006-07-05 Thread KyLiE
Hi all, I'm quiet new in this stuff, I have N psql users and N databases, each user has a database and can connect to it using his psql account, however I don't want to allow that some user access to another database that does not belong to him. I've modify my pg_hba.conf file, and allow the a

Re: [ADMIN] Wrap (obfuscate) code

2006-07-05 Thread Jonah H. Harris
On 7/4/06, Joshua D. Drake <[EMAIL PROTECTED]> wrote: Although everything you say is accurate Jonah, it will cost more money to defang obfuscated code then non obfuscated code. Thus there is a financial detterant to stealing. My bet is that it would take < 1 day to turn PL/pgSQL into a code gen

[ADMIN] PGpool and VACUUM

2006-07-05 Thread Wim
Hello list, I have a 2 database cluster with pgpool running. It is configured as a load balancer and is working good untill I start a VACUUM, then the database goes in degeneration mode... Has anyone experienced the same problem? Thanks for helping. -- Cheers! Wim De Hul --