From: Lou Picciano <loupicciano@comcast.net>
To: Venkat Balaji <venkat.balaji@verse.in>
Cc: pgsql-admin@postgresql.org
Subject: Re: Postgresql 9.0.1 installation error
Date: Mon, 8 Aug 2011 14:04:20 +0000 (UTC)
Message-ID: <334862708.174486.1312812260983.JavaMail.root@sz0093a.westchester.pa.mail.comcast.net> (raw)
In-Reply-To: <CAFrxt0gEcx0xPL4Oj9x_iRzqsFYsmfBU=Kxd4QQM+B9EWYd4gA@mail.gmail.com>
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.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.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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: loupicciano@comcast.net, venkat.balaji@verse.in
Subject: Re: Postgresql 9.0.1 installation error
In-Reply-To: <334862708.174486.1312812260983.JavaMail.root@sz0093a.westchester.pa.mail.comcast.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox