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

2015-07-26 Thread Michael Paquier
On Sun, Jul 26, 2015 at 2:55 PM, krz...@gmail.com wrote: > 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) You could use

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

2015-07-26 Thread krz...@gmail.com
# ./configure CFLAGS="-I/usr/openssl-0.9.8zg/include" LDFLAGS="-L/usr/openssl-0.9.8zg/lib" --with-openssl configure: error: 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. # tail config.lo

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

2015-07-26 Thread Michael Paquier
On Mon, Jul 27, 2015 at 8:34 AM, krz...@gmail.com wrote: > setting LDFLAGS to openssl lib dir causes postgresql ./configure to > fail without real explanation. (Please do not top-post). It may be missing dependencies. You should check config.log for more input about the reason why it failed and t

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 Adrian Klaver
On 07/26/2015 04:34 PM, krz...@gmail.com wrote: # ./configure CFLAGS="-I/usr/openssl-0.9.8zg/include" LDFLAGS="-L/usr/openssl-0.9.8zg/lib" --with-openssl configure: error: Could not execute a simple test program. This may be a problem related to locating shared libraries. Check the file '

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

2015-07-26 Thread Adrian Klaver
On 07/26/2015 05:24 PM, krz...@gmail.com wrote: 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 previous

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
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.

[GENERAL] I lost my password

2015-07-26 Thread papa
After installing PostgreSQL I lost the password, how can I recover it?

Re: [GENERAL] I lost my password

2015-07-26 Thread Yves Dorfsman
On 2015-07-26 20:51, p...@arbolone.ca wrote: > After installing PostgreSQL I lost the password, how can I recover it? Assuming you have "local" login configured (which is the default), you can su to the postgres user (or whichever is configured in pg_hba.conf) and login with psql directly without

Re: [GENERAL] I lost my password

2015-07-26 Thread Adrian Klaver
On 07/26/2015 07:51 PM, p...@arbolone.ca wrote: After installing PostgreSQL I lost the password, how can I recover it? What OS? How did you install? What password are you talking about? Assuming you are talking about a Postgres password, take a look at: http://www.postgresql.org/docs/9.4/in

Re: [GENERAL] I lost my password

2015-07-26 Thread John McKown
Which password? What operating system (Linux, Windows, Mac)? If you are on Linux, what I do is an "sudo su postgres-" to switch to the "postgres" user, which does not (since I'm "root" via sudo) require a password to do. On Sun, Jul 26, 2015 at 9:51 PM, wrote: > After installing PostgreSQL I

Re: [GENERAL] I lost my password

2015-07-26 Thread papa
I am using windows 8.1 and what I believe to be the latest version of posgresql from postgresql.org. Would it be better to reinstall postgresql? -Original Message- From: Adrian Klaver Sent: Sunday, July 26, 2015 11:01 PM To: p...@arbolone.ca ; PostGreSQL MailingList Subject: Re: [GENER

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

2015-07-26 Thread Adrian Klaver
On 07/26/2015 05:32 PM, krz...@gmail.com wrote: # 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 con

Re: [GENERAL] I lost my password

2015-07-26 Thread Adrian Klaver
On 07/26/2015 08:05 PM, p...@arbolone.ca wrote: I am using windows 8.1 and what I believe to be the latest version of posgresql from postgresql.org. Would it be better to reinstall postgresql? So what password are you talking about? I doubt this requires reinstalling. -Original Message--

Re: [GENERAL] I lost my password

2015-07-26 Thread papa
OK, I think I should tell you folks that I am a newbie. I am using postgresql to learn the SQL for the purpose of learning storing the data in my c++ application. I have near zero knowledge of SQL or PostgreSQL for that matter. When I type C:\pgsql, I am asked to entered a password, but I don't

[GENERAL] Splitting a string containing a numeric value in to three parts

2015-07-26 Thread Sanjaya Vithanagama
I want to split a given string which could possibly contain a numeric value, using regexp_matches. The numeric value may contain an optional positive or negative sign, an optional decimal place. The result should *also* report the non-matching parts before and after the identified numeric values

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

2015-07-26 Thread Tom Lane
"krz...@gmail.com " writes: > # grep -i ssl config.log > configure:13056: gcc -o conftest -Wall -Wmissing-prototypes > -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels > -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing > -fwrapv -O2 -D_GNU_SOURCE -L/usr/openssl-0.9.8

Re: [GENERAL] I lost my password

2015-07-26 Thread Adrian Klaver
On 07/26/2015 08:15 PM, p...@arbolone.ca wrote: OK, I think I should tell you folks that I am a newbie. I am using postgresql to learn the SQL for the purpose of learning storing the data in my c++ application. I have near zero knowledge of SQL or PostgreSQL for that matter. When I type C:\pgsql,

Re: [GENERAL] Using the database to validate data

2015-07-26 Thread Allan Kamau
To add onto what others a have said. I would use a bash script (and awk) to prepared each record of the raw CSV file with a dataset name, name of the file, timestamp and a serial number and place the newly generated data into a new file. In this bash script, the value of the dataset name, name of f