Skip to content

Instantly share code, notes, and snippets.

@mnencia
mnencia / Dockerfile
Created October 26, 2017 12:32
xenial-dev container
FROM ubuntu:xenial
RUN set -x \
&& apt-get update \
&& env DEBIAN_FRONTEND=noninteractive apt-get -y --force-yes install \
eatmydata \
pbuilder \
devscripts \
devscripts-el \
aptitude \
@mnencia
mnencia / pyenv-osx-install
Created October 26, 2017 12:30
Wrapper to use pyenv with homebrew and gnu binaries
#!/bin/sh
# Add updated software from homebrew
export CFLAGS="-I/usr/local/include"
export LDFLAGS="-L/usr/local/lib"
for pkg in openssl readline gdbm; do
export CFLAGS="-I$(brew --prefix $pgk)/include $CFLAGS"
export LDFLAGS="-L$(brew --prefix $pkg)/lib $LDFLAGS"
done
#!/usr/bin/env python
from __future__ import print_function
import os
import sys
import time
from barman.lockfile import LockFile, LockFileBusy
if __name__ == '__main__':
@mnencia
mnencia / test1.py
Created April 16, 2016 08:35
pglogical decodin in python
from __future__ import print_function
import sys
import psycopg2
import psycopg2.extras
conn = psycopg2.connect(
'host=localhost user=postgres port=5495',
connection_factory=psycopg2.extras.LogicalReplicationConnection)
cur = conn.cursor()
replication_options = {
@mnencia
mnencia / pg-install-no-create.sh
Last active October 9, 2015 10:34
Easy recipe to install PostgreSQL on Debian/Ubuntu without creating a cluster (apt.postgresql.org repository packages)
#!/bin/sh
# assumes apt.postgresql.org repository is already configured
TMP_PG_COMMON_CONF=$(mktemp -d)
echo create_main_cluster = false > "$TMP_PG_COMMON_CONF"/createcluster.conf
export PGSYSCONFDIR="$TMP_PG_COMMON_CONF"
apt-get install postgresql-12
unset PGSYSCONFDIR
rm -fr "$TMP_PG_COMMON_CONF"