Re: [ADMIN] Tyan Thunder MB for postgres server

2004-12-13 Thread William Yu
I've used a slew of LSI controllers (22915A, integrated 53C1010, 22320-R, MegaRAID 320-1) and they've all performed w/o issues. Now I have had some hardware die though. One was probably our fault -- during an attempted upgrade, we probably weren't careful enough with the 22320-R (cramped [EMAIL PRO

Re: [ADMIN] plperl loading

2004-12-13 Thread Marek Lewczuk
Joe Conway napisaÅ(a): Marek Lewczuk wrote: I've made some tests with plperl and I see that when plperl function is executed for the first time, then it takes much more time. I know that this is a "shared library" problem - is there a way to preload plperl every connection or maybe I can build p

Re: [ADMIN] Tyan Thunder MB for postgres server

2004-12-13 Thread Iain
Hi Ericson, (B (BI'm planning on using the onboard LSI SCSI controller, and have read alot (Babout poor IO performance on Dells using LSI. Then again, most of the talk (Babout Adaptec hasn't been all that complimentary either as I saw it ;-) It (Bseems that there is more to it than the nam

[ADMIN] Please Unsubscribe from PostgreSQL listing

2004-12-13 Thread Deepak Vohra
Please Unsubscribe from PostgreSQL listing __ Do you Yahoo!? Read only the mail you want - Yahoo! Mail SpamGuard. http://promotions.yahoo.com/new_mail ---(end of broadcast)--- TIP 2: you can get

Re: [ADMIN] From latin9 to sql_ascii??

2004-12-13 Thread Tom Lane
Jaime Casanova <[EMAIL PROTECTED]> writes: > => select to_ascii('Jiménez'); > will retrieve 'Jimenez' at least it works on Latin1 > encoding. > Why it not work on Latin9, Probably because it hasn't got a table for Latin9. Feel free to contribute one --- see src/backend/utils/adt/ascii.c.

Re: [ADMIN] preventing the effective fork bomb when restarting a high traffic server?

2004-12-13 Thread Tom Lane
Jeff <[EMAIL PROTECTED]> writes: > The problem I'm encountering is when I restart PG for whatever reason > it takes it a long time to come back fully online: the reason: the > machine is dealing with over 100 connection attempts / second while > trying to replay the logical logs. Um, perhaps y

Re: [ADMIN] plperl loading

2004-12-13 Thread Joe Conway
Marek Lewczuk wrote: I've made some tests with plperl and I see that when plperl function is executed for the first time, then it takes much more time. I know that this is a "shared library" problem - is there a way to preload plperl every connection or maybe I can build plperl into postgresql s

[ADMIN] plperl loading

2004-12-13 Thread Marek Lewczuk
Hi, I've made some tests with plperl and I see that when plperl function is executed for the first time, then it takes much more time. I know that this is a "shared library" problem - is there a way to preload plperl every connection or maybe I can build plperl into postgresql source ? Thanks i

[ADMIN] preventing the effective fork bomb when restarting a high traffic server?

2004-12-13 Thread Jeff
I have a PG server that handles a pretty good amount of traffic. Typically the connections are going through pgpool, which is a godsend. The problem I'm encountering is when I restart PG for whatever reason it takes it a long time to come back fully online: the reason: the machine is dealing

[ADMIN] From latin9 to sql_ascii??

2004-12-13 Thread Jaime Casanova
Hi, someone show me that if had accents in a word i can suppress it with the to_ascii function. => select to_ascii('Jiménez'); will retrieve 'Jimenez' at least it works on Latin1 encoding. Why it not work on Latin9, there's another way of doing such a thing? regards, Jaime Casanova __

Re: [ADMIN] Tyan Thunder MB for postgres server

2004-12-13 Thread Ericson Smith
We use that exact configuration right now, except with an Adaptec card (Band more RAM. (B (BWe used RHEL 3.0, then switched to Fedora core 2 64Bit as a test, since (Bthis server was since placed into standby duties. Well, we needed to use (Bthe server when the main server went into maintenance

Re: [ADMIN] HELP database files are incompatible with server

2004-12-13 Thread Bjoern Metzdorf
Seems you have broken your database files. You could try resetting PG_VERSION with pg_resetxlog or recompile postgres (I had a similar case where just recompiling worked). Make sure to take backups of $PGDATA before you try anything. Regards, Bjoern Paulo Jobim wrote: Hi I am posting again I di

[ADMIN] Logs

2004-12-13 Thread Marek Dabrowski
Hello Dear friends, I have one problem. My postgres 7.4.6 is working on HP DL360G4 with 2 disks working in mirror. Normaly average quantity postmaster proceses is 5-30 but when I switch on loging: syslog=2 log_connections = true log_hostname = true fsync = false quantity of postmasters grow up t