[GENERAL] configure can't find libcrypto on MacOS Sierra for pg 9.6.2

2017-02-12 Thread Jerry LeVan
Hello, I am trying to build pg 9.6.2 on my MacOS Sierra but configure is being balky configure:9494: checking for CRYPTO_new_ex_data in -lcrypto configure:9519: gcc -o conftest -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -Wmissing-for mat-attribute -Wfo

Re: [GENERAL] configure can't find libcrypto on MacOS Sierra for pg 9.6.2

2017-02-12 Thread Adrian Klaver
On 02/12/2017 06:56 AM, Jerry LeVan wrote: Hello, I am trying to build pg 9.6.2 on my MacOS Sierra but configure is being balky configure:9494: checking for CRYPTO_new_ex_data in -lcrypto configure:9519: gcc -o conftest -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -W

Re: [GENERAL] configure can't find libcrypto on MacOS Sierra for pg 9.6.2

2017-02-12 Thread Tom Lane
Jerry LeVan writes: > Hello, I am trying to build pg 9.6.2 on my MacOS Sierra but > configure is being balky Hmm, I'm not really sure why it's failing at that step --- it gets past that for me. Possibly looking into config.log to see if there's a more detailed error report would be illuminating.

Re: [GENERAL] Causeless CPU load waves in backend, on windows, 9.5.5 (EDB binary).

2017-02-12 Thread Nikolai Zhubr
Hello all, In order to locate the problem more precisely, I'd like to prepare a test, involving some ping-like communication between the server and a test client. That is, I'd like to repeatedly send something valid to the server and get some valid replies from it, but without any kind of real

Re: [GENERAL] Custom shuffle function stopped working in 9.6

2017-02-12 Thread Francisco Olarte
On Sat, Feb 11, 2017 at 5:37 PM, Alexander Farber wrote: ... > after switching to 9.6.2 from 9.5.3 the following custom function has > stopped working: > CREATE OR REPLACE FUNCTION words_shuffle(in_array varchar[]) > RETURNS varchar[] AS > Any suggestions for a better shuffling function pl

Re: [GENERAL] configure can't find libcrypto on MacOS Sierra for pg 9.6.2

2017-02-12 Thread Jerry LeVan
Sigh, I will try to build without OpenSSL… My database is seventeen years old, I don’t even remember which Postgresql I started out with... Jerry > On Feb 12, 2017, at 10:53 AM, Tom Lane wrote: > > Jerry LeVan writes: >> Hello, I am trying to build pg 9.6.2 on my MacOS Sierra but >> configur

Re: [GENERAL] configure can't find libcrypto on MacOS Sierra for pg 9.6.2

2017-02-12 Thread Adrian Klaver
On 02/12/2017 12:39 PM, Jerry LeVan wrote: Sigh, I will try to build without OpenSSL… I am not a Mac user, but from the below it does not seem that difficult to get around Apples decision: https://solitum.net/openssl-os-x-el-capitan-and-brew/ My database is seventeen years old, I don’t e

Re: [GENERAL] configure can't find libcrypto on MacOS Sierra for pg 9.6.2

2017-02-12 Thread Adrian Klaver
On 02/12/2017 12:39 PM, Jerry LeVan wrote: Sigh, I will try to build without OpenSSL… Of course there is another option, prebuilt binaries: https://www.postgresql.org/download/macosx/ My database is seventeen years old, I don’t even remember which Postgresql I started out with... Jerry

[GENERAL] 64 and 32 bit libpq

2017-02-12 Thread Jerry LeVan
Hello, I am trying to upgrade my postgresql ‘stuff’ to 64 bits from 32 bits. I am running MaxOS Sierra. I have built the 64 bit version of the server and have loaded my database into the new server ( 9.6.2 ). Everything seems to be working. I have some legacy apps that are 32 bit and talk to the

Re: [GENERAL] 64 and 32 bit libpq

2017-02-12 Thread Steve Atkins
> On Feb 12, 2017, at 5:03 PM, Jerry LeVan wrote: > > Hello, I am trying to upgrade my postgresql ‘stuff’ to 64 bits from 32 bits. > > I am running MaxOS Sierra. > > I have built the 64 bit version of the server and have loaded > my database into the new server ( 9.6.2 ). Everything seems to b