Re: [ADMIN] ssl database connection problems...

2009-01-23 Thread Ray Stell
On Fri, Jan 23, 2009 at 02:04:21PM -0500, Carol Walter wrote: >>> >>> ssl_ciphers 'ALL:!ADH:!LOW:@STRENGTH' I don't understand this syntax, is it described somewhere to your knowledge. The doc say to see the openssl docs, so I went fishing there. Maybe one of these will work: > openssl cipher

Re: [ADMIN] triggers on system tables ?

2009-01-23 Thread Tom Lane
Kevin Kempter writes: > Is it possible to add triggers to system catalog and/or statistics collector > tables ? No. regards, tom lane -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailp

[ADMIN] triggers on system tables ?

2009-01-23 Thread Kevin Kempter
Hi All; Is it possible to add triggers to system catalog and/or statistics collector tables ? Thanks in advance -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

Re: [ADMIN] ssl database connection problems...

2009-01-23 Thread Carol Walter
On Jan 22, 2009, at 1:27 PM, Ray Stell wrote: On Thu, Jan 22, 2009 at 10:35:22AM -0500, Carol Walter wrote: I'm still having problems with ssl. My ssl_ciphers line in postgresql.conf looks as the following: ssl_ciphers 'ALL:!ADH:!LOW:@STRENGTH' this parameter was not available in 8.2.x w

Re: [ADMIN] Why is that index not used?

2009-01-23 Thread Michael Monnerie
On Mittwoch 21 Januar 2009 Tom Lane wrote: > > Can somebody explain me why on the last line, "dbmail_physmessage", > > there is a seq. scan going on and no index used? > > Because it chose to use a hash instead.  Given the rowcounts I don't > think that's wrong, You mean reading 10k out of 234k e

[ADMIN] pgpool-II question

2009-01-23 Thread Gerd König
Hello, while evaluating pgpool-II (replication mode) I ran into a situation where I don't know the reason why The setup looks like: - host "one": postgres8.3.5 (defined as backend_0) and pgpoolII (port ) host "two": postgres8.3.5 (defined as backend_1) According to the