Re: [ADMIN] rebellious pg stats collector (reopened case)

2008-12-29 Thread Laszlo Nagy
Tom Lane wrote: Alvaro Herrera alvhe...@commandprompt.com writes: Tom Lane wrote: I wonder whether your tracing tool is affecting the result of getppid(). Most people would consider that a bug in the tracing tool. I wrote to an official the FreeBSD list about this

Re: [ADMIN] rebellious pg stats collector (reopened case)

2008-12-29 Thread Tom Lane
Laszlo Nagy gand...@shopzeus.com writes: maybe is it possible to change the source code, and disable the is postmaster alive check for testing? Rather than disabling it, it'd probably be more convenient to make any getppid value except 1 (the init process) be treated as it's alive. Otherwise

[ADMIN] ssl database connection problems...

2008-12-29 Thread Carol Walter
Hello, I've just created a new instance of postgres. It's running an a Sun server running Solaris 10. I configured it with ssl using port 5433. The server starts and runs. I can connect to it from the local host and list the databases, connect to them etc. I can't connect to the

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

2008-12-29 Thread Kevin Grittner
Carol Walter walt...@indiana.edu wrote: The server starts and runs. I can connect to it from the local host and list the databases, connect to them etc. I can't connect to the database instance from a remote host. Have you set listen_addresses in postgresql.conf? You likely want:

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

2008-12-29 Thread Scott Marlowe
On Mon, Dec 29, 2008 at 2:23 PM, Carol Walter walt...@indiana.edu wrote: Hello, I've just created a new instance of postgres. It's running an a Sun server running Solaris 10. I configured it with ssl using port 5433. The server starts and runs. I can connect to it from the local host and

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

2008-12-29 Thread Ray Stell
On Mon, Dec 29, 2008 at 04:23:30PM -0500, Carol Walter wrote: with openssl when I initially configured the server. Are there other things that need to be done to get openssl started on the database server? How can I diagnose this problem? The files server.key, server.crt, root.crt, and

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

2008-12-29 Thread Tom Lane
Scott Marlowe scott.marl...@gmail.com writes: On Mon, Dec 29, 2008 at 2:23 PM, Carol Walter walt...@indiana.edu wrote: ... I can't connect to the database instance from a remote host. I get a message as follows: walt...@cat:~$ psql -h db -U walterc -d walterc -p 5433 psql: could not connect