Nag - Don't conflate concerns over making an SSL connection with making a 'simple' connection; keep it simple first.
Then, once you move to SSL, yes - whatever 'client' you're using to connect must have SSL support built in. In some cases, this will be libpq or ecpg.
First off, have you read through your build logs? Are you sure everything is happening as you expect?
From: "Venkat Balaji" <venkat.balaji@verse.in>
To: "Lou Picciano" <loupicciano@comcast.net>
Cc: pgsql-admin@postgresql.org
Sent: Monday, August 8, 2011 8:11:41 AM
Subject: Re: [ADMIN] Postgresql 9.0.1 installation error
Yes, i can connect from the different bin without any issues, but, may not be able to get the SSL services, since that built is not SSL compiles.
Below is the detailed explaination -
Here is what i have done -
./configure --with-openssl --prefix=/opt/Postgresql9.0.1/
make install
The below bin path is already there -
/usr/local/postgresql9.0.1/bin - this is used by some other apps and is not compiled with openssl.
Thanks
Nag
On Mon, Aug 8, 2011 at 5:29 PM, Lou Picciano
<loupicciano@comcast.net> wrote:
Is your client psql compiled similarly to your server? IE, are you using the (correctly-) corresponding client, preferably the one built with the server?
That you can connect AOK from a different bin is the clue, I should think.
Lou Picciano
From: "Venkat Balaji" <
venkat.balaji@verse.in>
To: pgsql-admin@postgresql.orgSent: Monday, August 8, 2011 7:11:55 AM
Subject: [ADMIN] Postgresql 9.0.1 installation error
Hello,
This is my first post to the community.
We have been widely using PostgreSQL for our production environment.
We are pleased with the performance and features of PostgreSQL.
We have landed into a problem recently -
We had installed PostgreSQL9.0.1 for which i had executed the below commands -
./configure --with-openssl --prefix=/opt/Postgresql9.0.1/
make install
installed successfully
Created the cluster using initdb command successfully
When i said "./psql -p 5445", I am getting the below error
[postgres@warehouse1 bin]$ ./psql -p 5445
LOG: unexpected EOF on client connection
Segmentation fault
Note : -
1. Port Number was specified in the postgresql.conf file
2. The same version of PostgreSQL was installed in the same server in a different location and is working fine without any issues -
3. Postgres process is running fine. When i am connecting from a different PG installer bin directory,
I am able to connect.
Can someone please help !!
I need PostgreSQL 9.0.1 with Open-SSL.
Thanks
Nag