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

2008-12-31 Thread Ray Stell
On Wed, Dec 31, 2008 at 11:16:42AM -0500, Carol Walter wrote: >> On the web site you directed me to, the s_server command uses a file >> called 'mycert.pem'. Do you know what the system expecting for this file? It's just a file and you tell openssl where it is, where you put it once it is creat

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

2008-12-31 Thread Carol Walter
Begin forwarded message: From: Carol Walter Date: December 31, 2008 11:16:01 AM GMT-05:00 To: Ray Stell Subject: Re: [ADMIN] ssl database connection problems... Sorry, I obviously am pretty clueless. Thanks, Carol On Dec 31, 2008, at 10:09 AM, Ray Stell wrote: On Wed, Dec 31, 2008 at 09

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

2008-12-31 Thread Ray Stell
On Wed, Dec 31, 2008 at 09:19:12AM -0500, Carol Walter wrote: > Here's the output from s_client & s_server commands... > > # openssl s_client > connect: Connection refused > connect:errno=146 oh, I think you need to use some more flags. Take a look at this howto: http://www.madboa.com/geek/opens

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

2008-12-31 Thread Carol Walter
On Dec 30, 2008, at 8:42 PM, Ray Stell wrote: On Tue, Dec 30, 2008 at 03:53:37PM -0500, Carol Walter wrote: OpenSSL is telling me that ssl is not properly configured. how so? Here's the output from s_client & s_server commands... # openssl s_client connect: Connection refused connect:err

Re: [ADMIN] Getting the value of a config parameter in runtime

2008-12-31 Thread Guillaume Lelarge
Jaume Sabater a écrit : > [...] > Sorry to ask this, I had it noted down but now I cannot find it and > I've been googling for 30 minutes now without success. There is a way > to query the system database to get the current value of a > configuration parameter, something in the form of SELECT value

Re: [ADMIN] Getting the value of a config parameter in runtime

2008-12-31 Thread AmitKumar Jain
You can configuration parameter value from psql prompt by typing show all ; or show [paramter name] e.g show shared_buffers; Jaume Sabater wrote: Hi all! Sorry to ask this, I had it noted down but now I cannot find it and I've been googling for 30 minutes now without success. There is a way t

[ADMIN] Getting the value of a config parameter in runtime

2008-12-31 Thread Jaume Sabater
Hi all! Sorry to ask this, I had it noted down but now I cannot find it and I've been googling for 30 minutes now without success. There is a way to query the system database to get the current value of a configuration parameter, something in the form of SELECT value FROM some_table WHERE field_na