Re: [GENERAL] how to compile postgresql with other version of openssl?

2015-07-26 Thread krz...@gmail.com
and that is probably why openssl-1.0.1p works - it does not seem to have any *.so files so I guess its not dynamicly linked into other programs (?). root@sv1 [/root]# ls /usr/openssl-0.9.8zg/lib ./ ../ engines/ libcrypto.a libcrypto.so@ libcrypto.so.0.9.8* libssl.a libssl.so@ libssl.so.0.9.

Re: [GENERAL] how to compile postgresql with other version of openssl?

2015-07-26 Thread krz...@gmail.com
# LDFLAGS="-L/usr/openssl-0.9.8zg/lib" ./configure --with-openssl Could not execute a simple test program. This may be a problem related to locating shared libraries. Check the file 'config.log' for the exact reason. # grep -i ssl config.log configure:13056: gcc -o conftest -Wall -Wmissing-proto

Re: [GENERAL] how to compile postgresql with other version of openssl?

2015-07-26 Thread krz...@gmail.com
> It may be missing dependencies. Like I mentioned without LDFLAGS CFLAGS there are no problem with compilation so problem is with configure script and CFLAGS LDFLAGS or/and openssl library >You should check config.log for more input I've previously pasted config.log. It does not contain any infor

Re: [GENERAL] how to compile postgresql with other version of openssl?

2015-07-26 Thread krz...@gmail.com
configure: exit 1 setting LDFLAGS to openssl lib dir causes postgresql ./configure to fail without real explanation. A bug? 2015-07-26 9:06 GMT+02:00 Michael Paquier : > On Sun, Jul 26, 2015 at 2:55 PM, krz...@gmail.com wrote: >> Postgresql is first linux program based on automake I

[GENERAL] how to compile postgresql with other version of openssl?

2015-07-25 Thread krz...@gmail.com
Postgresql is first linux program based on automake I've ever seen (and i've been compiling linux stuff nice 1999) that does not allow specyfying lib locations on ./configure like (like --with-openssl=/path/to/openssl) So how do I link it to other version of openssl than one that is present in os

[GENERAL] Re: permission denied to create extension "ltree" Must be superuser to create this extension.

2013-02-12 Thread krz...@gmail.com
Year has passed and still no answer here or in documentation. I wonder if I get to live that long so I can find out answer. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] permission denied to create extension "ltree" Must be superuser to create this extension.

2012-03-14 Thread krz...@gmail.com
Ok, but can someone comment, document something on security of installing extensions for normal users? Does allowing access to extension provides a way to circumvent security model? If not why can't it be allowed for user installations (provided that extension was previously allowed in some conf fi

[GENERAL] permission denied to create extension "ltree" Must be superuser to create this extension.

2012-03-10 Thread krz...@gmail.com
psql (9.1.2) CREATE EXTENSION ltree; ERROR: permission denied to create extension "ltree" HINT: Must be superuser to create this extension. Why does ltree require superuser privledge? Is it dangerous and allow circumventing server security? No mention of this in manual so it is either documenta