Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 92DE5B5DC08 for ; Mon, 8 Aug 2011 11:04:27 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 19718-02 for ; Mon, 8 Aug 2011 14:04:21 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from qmta02.westchester.pa.mail.comcast.net (qmta02.westchester.pa.mail.comcast.net [76.96.62.24]) by mail.postgresql.org (Postfix) with ESMTP id 0188AB5DBDB for ; Mon, 8 Aug 2011 11:04:20 -0300 (ADT) Received: from omta05.westchester.pa.mail.comcast.net ([76.96.62.43]) by qmta02.westchester.pa.mail.comcast.net with comcast id Hq0a1h0040vyq2s52q4MFd; Mon, 08 Aug 2011 14:04:21 +0000 Received: from sz0093.wc.mail.comcast.net ([76.96.58.151]) by omta05.westchester.pa.mail.comcast.net with comcast id Hq4M1h00B3FmDic3Rq4M6t; Mon, 08 Aug 2011 14:04:21 +0000 Date: Mon, 8 Aug 2011 14:04:20 +0000 (UTC) From: Lou Picciano To: Venkat Balaji Cc: pgsql-admin@postgresql.org Message-ID: <334862708.174486.1312812260983.JavaMail.root@sz0093a.westchester.pa.mail.comcast.net> In-Reply-To: Subject: Re: Postgresql 9.0.1 installation error MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_174485_472525102.1312812260982" X-Originating-IP: [76.117.178.80] X-Mailer: Zimbra 6.0.10_GA_2706 (ZimbraWebClient - FF3.0 (Mac)/6.0.10_GA_2697) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.709 tagged_above=-10 required=5 tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_NONE=-0.0001, RP_MATCHES_RCVD=-0.811 X-Spam-Level: X-Archive-Number: 201108/26 X-Sequence-Number: 38013 ------=_Part_174485_472525102.1312812260982 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit 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" To: "Lou Picciano" 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.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 ------=_Part_174485_472525102.1312812260982 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable <= div style=3D'font-family: Verdana; font-size: 12pt; color: #000000'>Nag - D= on'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@ve= rse.in>
To: "Lou Picciano" <loupicciano@comcast.net>
= Cc: pgsql-admin@postgresql.org
Sent: Monday, August 8, 201= 1 8:11:41 AM
Subject: Re: [ADMIN] Postgresql 9.0.1 installation e= rror

Yes, i can connect from the different bin without any issu= es, but, may not be able to get the SSL services, since that built is not S= SL compiles.

Below is the detailed explaination -<= /div>

Here is what i have done -

./configure --with-= openssl --prefix=3D/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 a= nd is not compiled with openssl.

Thanks
= Nag


On Mon, Aug 8, 2011 at 5= :29 PM, Lou Picciano <loupicciano@comcast.net> wrote:<= br>
Is your client psql compiled similarly to your server? IE, are you usi= ng 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=20 think.

Lou Picciano

From: "Venkat Balaji" <venkat.balaji@verse= .in>
To: pgsql-admin@postgresql.org
Sent: Monday, August 8, 2011 7:11:55 AM
Subject: [ADMIN] P= ostgresql 9.0.1 installation error

Hello,

This is my first post to the community.
We have been widely using PostgreSQL for our production environment.
<= div>
We are pleased with the performance and features of Post= greSQL.

We have landed into a problem recently -

=
We had installed PostgreSQL9.0.1 for which i had executed the be= low commands -

./configure --with-openssl --prefix= =3D/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 fau= lt

Note : -
1. Port Number was spe= cified 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 someo= ne please help !!

I need PostgreSQL 9.0.1 with Ope= n-SSL.

Thanks
Nag



------=_Part_174485_472525102.1312812260982--