Andrew Dunstan adunstan

## libpq-fix-nossl-builds.patch
diff --git a/src/interfaces/libpq/fe-secure.c b/src/interfaces/libpq/fe-secure.c
index e55b375c51..994605d0be 100644
--- a/src/interfaces/libpq/fe-secure.c
+++ b/src/interfaces/libpq/fe-secure.c
@@ -432,6 +432,24 @@ PQsslAttributeNames(PGconn *conn)

 	return result;
 }
+
+PQsslKeyPassHook_type

## testlib-close-stdin.patch
diff --git a/src/test/perl/TestLib.pm b/src/test/perl/TestLib.pm
index 905d0d178f..df39671700 100644
--- a/src/test/perl/TestLib.pm
+++ b/src/test/perl/TestLib.pm
@@ -87,6 +87,8 @@ our @EXPORT = qw(

 our ($windows_os, $tmp_check, $log_path, $test_logfile);

+my @no_stdin;
+

## ssl-passphrase-callback-2.patch
diff --git a/src/backend/libpq/be-secure-openssl.c b/src/backend/libpq/be-secure-openssl.c
index 629919cc6e..bf4493c94a 100644
--- a/src/backend/libpq/be-secure-openssl.c
+++ b/src/backend/libpq/be-secure-openssl.c
@@ -45,6 +45,9 @@
 #include "utils/memutils.h"


+ssl_passphrase_func_cb ssl_passphrase_function = NULL;
+bool ssl_passphrase_function_supports_reload = false;

## gist:bc906855f73c4aa60c5bfa48622332c4
      0 [main] pg_regress (32588) child_copy: cygheap read copy failed, 0x180317408..0x18032A988, done 0, windows pid 32588, Win32 error 6
   1703 [main] pg_regress (32588) C:\tools\msys64\home\Administrator\bf\root\HEAD\pgsql.build\src\test\regress\pg_regress.exe: *** fatal error - ccalloc would have returned NULL

## scrub_strings.pl
perl -p -e "local \$/ = undef; my \$log = <>; \$log =~ s/('|\\\$[a-zA-Z0-9_]*\\\$)(.*)\$1/\$1 . (q[X] x length(\$2)) . \$1/gme; print \$log;" /tmp/logsamp

## barman_provision.sh
#!/bin/sh

HOST=$1
echo provisioning $HOST

yum install -y https://download.postgresql.org/pub/repos/yum/10/redhat/rhel-7-x86_64/pgdg-centos10-10-2.noarch.rpm

if [ "$HOST" = 'postgres' ] ; then
	yum install -y \
		postgresql10 \

## appveyor-cranges.yml
#  appveyor.yml

before_build:
  - set PATH=C:\Program Files\PostgreSQL\9.6\bin;%PATH%
  - cmake -G "Visual Studio 14 2015 Win64"
  - dir
  - pg_config

build:
  project: cranges.sln

## appveyor.yml
#  appveyor.yml
install:
  - cinst winflexbison
  - '"C:\Program Files\Microsoft SDKs\Windows\v7.1\Bin\SetEnv.cmd" /x64'

before_build:
  - net user testuser Blurfl9426! /add
  - rename c:\ProgramData\chocolatey\bin\win_flex.exe flex.exe
  - rename c:\ProgramData\chocolatey\bin\win_bison.exe bison.exe
  - curl -S -O https://gist.githubusercontent.com/adunstan/7f18e5db33bb2d73f69ff8c9337a4e6c/raw/buildsetup.pl

## dll2lib.bat
@echo off
rem see http://stackoverflow.com/questions/9946322/how-to-generate-an-import-library-lib-file-from-a-dll#9946390

rem see also http://www.postgresql-archive.org/MSVC-pl-perl-error-message-is-not-verbose-enough-td5913411.html
rem see also  https://postgr.es/m/CABcP5fjEjgOsh097cWnQrsK9yCswo4DZxp-V47DKCH-MxY9Gig@mail.gmail.com


REM Usage: dll2lib [32|64] some-file.dll
REM
REM Generates some-file.lib from some-file.dll, making an intermediate

## gist:fbbdfe646427710233ecb67569665de9
pgbfprod=> select s.branch, s.log_stage, count(*), avg(extract(epoch from stage_duration)::numeric(15,2))::numeric(15,1), stddev(extract(epoch from stage_duration)::numeric(15,2))::numeric(15,1) from public.build_status_log s where sysname <> 'crake' and snapshot > now() - interval '10 days'  and log_stage !~ 'start|stop' group by s.branch, s.log_stage having count(*) > 20 and avg(extract(epoch from stage_duration)::numeric(15,2)) > 20 order by log_stage, branch <> 'HEAD', branch desc
;
    branch     |                   log_stage                   | count |  avg   | stddev
---------------+-----------------------------------------------+-------+--------+--------
 HEAD          | bin-check.log                                 |   388 | 1739.0 | 1758.5
 REL9_6_STABLE | bin-check.log                                 |    91 | 1430.5 | 1287.9
 REL9_5_STABLE | bin-check.log                                 |    87 | 1140.0 |  994.1
 REL9_4_STABLE | bin-check.log                                 |    72 |  751.0 |  66