Re: Compile psql 9.6 with SSL Version 1.1.0

2018-10-12 Thread Adrian Klaver
On 10/12/18 8:06 AM, Ádám Maracska wrote: Please reply to list also. Ccing list. Hi, Thanks for the short answer and thanks for reminding me for the most essential details that I missed.:) >What OS and version of same are you compiling in? So I would like to compile it for windows 10 x64

Re: Compile psql 9.6 with SSL Version 1.1.0

2018-10-12 Thread Pratik Parikh
Thanks for providing the insight needed to make this work on Windows. On Fri, Oct 12, 2018, 12:17 PM Tom Lane wrote: > Pratik Parikh writes: > > I have seen the same failure on windows build. I can only use > > openssl 1.02(x). > > Hmm ... looking at it closer, I realize that part of the

Re: Compile psql 9.6 with SSL Version 1.1.0

2018-10-12 Thread Tom Lane
Pratik Parikh writes: > I have seen the same failure on windows build. I can only use > openssl 1.02(x). Hmm ... looking at it closer, I realize that part of the problem is that with 1.1.0 you need HAVE_BIO_METH_NEW to be defined, and there's no mechanism for doing that in the MSVC build code.

French translation of CoC

2018-10-12 Thread Lætitia Avrot
Hi, You'll find enclosed a french translation (reviewed by the community on the french mailing-list) of the Code Of Conduct. Regards, Lætitia -- *Think! Do you really need to print this email ? * *There is no Planet B.* # Introduction Le projet PostgreSQL est fier de la qualité de son code,

Re: Compile psql 9.6 with SSL Version 1.1.0

2018-10-12 Thread Pratik Parikh
I have seen the same failure on windows build. I can only use openssl 1.02(x). On Fri, Oct 12, 2018 at 11:32 AM Tom Lane wrote: > =?UTF-8?B?w4Fkw6FtIE1hcmFjc2th?= writes: > > Currently I am trying to compile my pqlib with SSL version 1.1.0, but I > get > > the following errors: > >

Re: Compile psql 9.6 with SSL Version 1.1.0

2018-10-12 Thread Tom Lane
=?UTF-8?B?w4Fkw6FtIE1hcmFjc2th?= writes: > Currently I am trying to compile my pqlib with SSL version 1.1.0, but I get > the following errors: > *fe-secure-openssl.c(1582): error C2037: left of 'ptr' specifies undefined > struct/union 'bio_st'* > [etc] That certainly ought to work, and does work

Re: Compile psql 9.6 with SSL Version 1.1.0

2018-10-12 Thread Adrian Klaver
On 10/12/18 7:15 AM, Ádám Maracska wrote: Hi, Currently I am trying to compile my pqlib with SSL version 1.1.0, but I get the following errors: / / /fe-secure-openssl.c(1582): error C2037: left of 'ptr' specifies undefined struct/union 'bio_st'/ /fe-secure-openssl.c(1582): error C2198:

Compile psql 9.6 with SSL Version 1.1.0

2018-10-12 Thread Ádám Maracska
Hi, Currently I am trying to compile my pqlib with SSL version 1.1.0, but I get the following errors: *fe-secure-openssl.c(1582): error C2037: left of 'ptr' specifies undefined struct/union 'bio_st'* *fe-secure-openssl.c(1582): error C2198: 'pqsecure_raw_read': too few arguments for call*

Re: Advice on logging strategy

2018-10-12 Thread Mike Martin
Thanks! On Fri, 12 Oct 2018 at 14:33, David Steele wrote: > On 10/11/18 11:26 AM, Mike Martin wrote: > > > > This results in enormous log files which take ages to import using copy > > becuase each execute statement is logged with the parameters chosen > > > > Is there any way around this? > >

Re: RHEL 7 (systemd) reboot

2018-10-12 Thread Adrian Klaver
On 10/11/18 10:43 AM, Bryce Pepper wrote: I disabled and removed the CTM_Postgre.service as it didn't help (and I didn't want too many moving parts left out there). I did find a post https://superuser.com/questions/1016827/how-do-i-run-a-script-before-everything-else-on-shutdown-with-systemd

Re: Advice on logging strategy

2018-10-12 Thread David Steele
On 10/11/18 11:26 AM, Mike Martin wrote: This results in enormous log files which take ages to import using copy becuase each execute statement is logged with the parameters chosen Is there any way around this? I cant find any way to filter dml statements pgAudit

Re: Want to acquire lock on tables where primary of one table is foreign key on othere

2018-10-12 Thread Abhishek Tripathi
Thank you for your response. I am explaining my situation there is table A on which I have taken a row lock and the primary key of table A is related with table B as a foreign key so automatically I can not insert new row with that foreign key now the primary key of table B is used as foreign

Re: how to identify the timeline of specified recovery_target_time when do multiple PITR

2018-10-12 Thread magodo
On Thu, 2018-10-11 at 19:53 +0200, Laurenz Albe wrote: > Indeed, your sentence > > > if , for example, it recovered to "A" at "o1", then > > the switched WAL(in case of stop-then-recover) or .partial > > corresponding WAL(in case of promote) is the last WAL of the > > timeline1 > > seems to

Re: Want to acquire lock on tables where primary of one table is foreign key on othere

2018-10-12 Thread Alban Hertroys
You forgot to CC the list. Also, top-posting is generally not appreciated here. > On Thu, Oct 11, 2018 at 8:26 PM Alban Hertroys wrote: > On Thu, 11 Oct 2018 at 16:38, Abhishek Tripathi > wrote: > > Actually I have acquired a "Select for Update" on a table whose id is > > refrence as a foreign