View curl-fc-repo.txt
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
$ curl sfc-repo.snowflakecomputing.com -v | |
% Total % Received % Xferd Average Speed Time Time Time Current | |
Dload Upload Total Spent Left Speed | |
0 0 0 0 0 0 0 0 --:--:-- --:--:-- --:--:-- 0* Trying 99.84.41.12... | |
* TCP_NODELAY set | |
* Connected to sfc-repo.snowflakecomputing.com (99.84.41.12) port 80 (#0) | |
> GET / HTTP/1.1 | |
> Host: sfc-repo.snowflakecomputing.com | |
> User-Agent: curl/7.64.1 |
View curl-sfc-repo-docker.sh
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# # In docker container | |
# curl -v sfc-repo.snowflakecomputing.com/index.html | |
* Expire in 0 ms for 6 (transfer 0x5560e6f4ef50) | |
* Expire in 1 ms for 1 (transfer 0x5560e6f4ef50) | |
* Expire in 0 ms for 1 (transfer 0x5560e6f4ef50) | |
* Expire in 2 ms for 1 (transfer 0x5560e6f4ef50) | |
* Expire in 1 ms for 1 (transfer 0x5560e6f4ef50) | |
* Expire in 1 ms for 1 (transfer 0x5560e6f4ef50) | |
* Expire in 4 ms for 1 (transfer 0x5560e6f4ef50) | |
* Expire in 2 ms for 1 (transfer 0x5560e6f4ef50) |
View purge_old_deltas.sql
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
DO $$ | |
DECLARE | |
target TEXT; | |
BEGIN | |
FOR target IN | |
SELECT table_name | |
FROM information_schema.tables | |
WHERE table_schema = 'bucardo' | |
AND table_name LIKE 'track_%' | |
LOOP |
View limit-lowercase.patch
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
--- a/bucardo.schema | |
+++ b/bucardo.schema | |
@@ -73,8 +73,9 @@ RETURNS TRIGGER | |
LANGUAGE plpgsql | |
AS $bc$ | |
BEGIN | |
- | |
- NEW.setting = LOWER(NEW.setting); | |
+ IF NEW.name <> ALL('{log_conflict_file,warning_file,email_debug_file,flatfile_dir,reason_file,stats_script_url,stopfile,log_timer_format}') THEN | |
+ NEW.setting = LOWER(NEW.setting); |
View no-lc.patch
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
--- a/bucardo | |
+++ b/bucardo | |
@@ -8755,7 +8755,8 @@ sub config { | |
for my $noun (@nouns) { | |
$noun =~ /(\w+)=(.+)/ or die $setusage; | |
- my ($setting,$val) = (lc $1,$2); | |
+ my $setting = lc $1; | |
+ my $val = $setting eq 'log_timer_format' ? $2 : lc $2; | |
View gist:306590e6ae88f9fd3d11f28092c33bc7
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# Installs build dependency. | |
$ cpanm --quiet -L try --notest DBI | |
Successfully installed Test-Simple-1.302140 | |
Successfully installed DBI-1.641 | |
2 distributions installed | |
# Installs configure dependency. | |
$ cpanm --quiet -L try --notest Widget::Meta | |
Successfully installed Module-Build-0.4224 | |
Successfully installed Widget-Meta-0.06 |
View Dockerfile
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
FROM alpine:latest | |
RUN apk add --update less | |
ENV TERM xterm-256color | |
ENTRYPOINT echo -e "Color me \033[31mRED" | less |
View pgenv.sh
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#!/bin/bash | |
# Versions: | |
# 10.4 9.6.9 9.5.13 9.4.18 9.3.23 9.2.24 9.1.24 9.0.19 8.4.22 8.3.23 8.2.23 8.1.23 8.0.26 | |
BASE=$HOME/pg | |
PGSQL=$BASE/pgsql | |
PG_DATA=$PGSQL/data | |
PG_CTL="$PGSQL/bin/pg_ctl -D $PG_DATA" |
View pg.patch
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
diff --git a/lib/App/Sqitch/Engine/pg.pm b/lib/App/Sqitch/Engine/pg.pm | |
index 71a8d2cc..11e55ca1 100644 | |
--- a/lib/App/Sqitch/Engine/pg.pm | |
+++ b/lib/App/Sqitch/Engine/pg.pm | |
@@ -45,15 +45,22 @@ has _psql => ( | |
my $self = shift; | |
my $uri = $self->uri; | |
my @ret = ( $self->client ); | |
- for my $spec ( | |
- [ username => $self->username ], |
View plv8-centos7-output.txt
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
+ make PG_CONFIG=/usr/pgsql-9.4/bin/pg_config -j16 | |
sed -e 's/^#undef PLV8_VERSION/#define PLV8_VERSION "2.1.0"/' plv8_config.h.in > plv8_config.h | |
echo "extern const unsigned char coffee_script_binary_data[] = {" >coffee-script.cc | |
echo "extern const unsigned char livescript_binary_data[] = {" >livescript.cc | |
sed -e 's/@PLV8_VERSION@/2.1.0/g' plv8.control.common | g++ -E -P -DLANG_plv8 - > plv8.control | |
sed -e 's/@LANG_NAME@/plv8/g' plv8.sql.common | sed -e 's/@PLV8_VERSION@/2.1.0/g' | g++ -E -P -I. -I./ -I/usr/pgsql-9.4/include/server -I/usr/pgsql-9.4/include/internal -D_GNU_SOURCE -I/usr/include/libxml2 -I/usr/include -DLANG_plv8 - > plv8--2.1.0.sql | |
sed -e 's/@PLV8_VERSION@/2.1.0/g' plv8.control.common | g++ -E -P -DLANG_plcoffee - > plcoffee.control | |
sed -e 's/@LANG_NAME@/plcoffee/g' plv8.sql.common | sed -e 's/@PLV8_VERSION@/2.1.0/g' | g++ -E -P -I. -I./ -I/usr/pgsql-9.4/include/server -I/usr/pgsql-9.4/include/internal -D_GNU_SOURCE -I/usr/include/libxml2 -I/usr/include -DLANG_plcoffee - > plcoffee--2.1.0.sq |
NewerOlder