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? ----- Original Message ----- From: "Venkat Balaji" <venkat.bal...@verse.in> To: "Lou Picciano" <loupicci...@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 < loupicci...@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.bal...@verse.in > To: pgsql-admin@postgresql.org Sent: 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
