Re: Postgresql 9.0.1 installation error

From: Lou Picciano <loupicciano(at)comcast(dot)net>
To: Venkat Balaji <venkat(dot)balaji(at)verse(dot)in>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Postgresql 9.0.1 installation error
Date: 2011-08-08 14:04:20
Message-ID: 334862708.174486.1312812260983.JavaMail.root@sz0093a.westchester.pa.mail.comcast.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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(dot)balaji(at)verse(dot)in>
To: "Lou Picciano" <loupicciano(at)comcast(dot)net>
Cc: pgsql-admin(at)postgresql(dot)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(at)comcast(dot)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(dot)balaji(at)verse(dot)in >
To: pgsql-admin(at)postgresql(dot)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(at)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message antismarmy 2011-08-08 14:45:34 pgsql2shp error when query is introduced
Previous Message Venkat Balaji 2011-08-08 12:11:41 Re: Postgresql 9.0.1 installation error