Thread: Postgresql with open-ssl support

How can I be sure that Postgresql Server has been installed with open-ssl support?

Any help please.

On 04/05/10 1:02 PM, AI Rumman wrote:
<blockquote
 cite="mid:l2i2a7905441005040032k319af2d4za572d3f4d7eeba73@mail.gmail.com"
 type="cite">How can I be sure that Postgresql Server has been
installed with open-ssl support?

Any help please.

Execute following command:
pg_config|grep ssl

Above command should show following option:
CONFIGURE = '--prefix=/home/edb/AS83R2/build/AS83R2/edb-postgres/inst'
'--with-libedit-preferred' '--with-openssl' '--with-krb5' '--with-tcl'
'--with-perl' '--with-includes=/usr/include/libxml2' '--with-libxslt'
'--enable-nls' '--with-ossp-uuid' '--with-pgport=5444' '--with-ldap'
'--with-pam' '--with-libmemcached' 'CC=/usr/local/gcc41/bin/gcc'
'CPPFLAGS=-I/home/edb/AS83R2/build/AS83R2/edb-postgres/src/include'
LIBS = -lpgport -lmemcached -lxslt -lxml2 -lpam -lssl -lcrypto -lkrb5
-lz -ledit -ltermcap -lcrypt -ldl -lm

--
Thanks & Regards,
Vibhor Kumar.
EnterpriseDB Corporation
The Enterprise Postgres Company

Office: 732-331-1300 Ext-2022

Website: www.enterprisedb.com
EnterpriseDB Blog: http://blogs.enterprisedb.com
Follow us on Twitter: http://www.twitter.com/enterprisedb

On 04/05/10 1:02 PM, AI Rumman wrote:
<blockquote
 cite="mid:l2i2a7905441005040032k319af2d4za572d3f4d7eeba73@mail.gmail.com"
 type="cite">How can I be sure that Postgresql Server has been
installed with open-ssl support?

Any help please.

Execute following command:
pg_config|grep ssl

Above command should show following option:
CONFIGURE = '--prefix=/home/edb/AS83R2/build/AS83R2/edb-postgres/inst'
'--with-libedit-preferred' '--with-openssl' '--with-krb5' '--with-tcl'
'--with-perl' '--with-includes=/usr/include/libxml2' '--with-libxslt'
'--enable-nls' '--with-ossp-uuid' '--with-pgport=5444' '--with-ldap'
'--with-pam' '--with-libmemcached' 'CC=/usr/local/gcc41/bin/gcc'
'CPPFLAGS=-I/home/edb/AS83R2/build/AS83R2/edb-postgres/src/include'
LIBS = -lpgport -lmemcached -lxslt -lxml2 -lpam -lssl -lcrypto -lkrb5
-lz -ledit -ltermcap -lcrypt -ldl -lm

Thanks & Regards,
Vibhor Kumar
EnterpriseDB Co.

On Tue, 2010-05-04 at 13:32 +0600, AI Rumman wrote:
> How can I be sure that Postgresql Server has been installed with
> open-ssl support?

You can check postgres binary with ldd, I think. i.e.:

$ ldd /usr/bin/postgres|grep ssl
    libssl.so.10 => /usr/lib/libssl.so.10 (0x07b43000)

--
Devrim GÜNDÜZ
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
PostgreSQL RPM Repository: http://yum.pgrpms.org
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org  Twitter: http://twitter.com/devrimgunduz