Skip to content

Instantly share code, notes, and snippets.

Andrew Dunstan adunstan

Block or report user

Report or block adunstan

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
@adunstan
adunstan / libpq-fix-nossl-builds.patch
Created Dec 1, 2019
libpq-fix-nossl-builds.patch
View 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
View 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;
+
View 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;
View 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
View 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
@adunstan
adunstan / barman_provision.sh
Created Oct 31, 2018
vagrant provisioner for barman recipes
View 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 \
@adunstan
adunstan / appveyor-cranges.yml
Last active Oct 15, 2017
setup for cranges appveyor
View 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
@adunstan
adunstan / appveyor.yml
Last active Jun 3, 2018
Setup for appveyor builds
View 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
View 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
@adunstan
adunstan / gist:fbbdfe646427710233ecb67569665de9
Created Mar 13, 2017
Buildfarm recent timings 2017-03-13
View 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
You can’t perform that action at this time.