pfigue

Connect and Select

connect()

The shortest connect:

from psycopg2 import connect
psql_conn = connect("dbname=XXX user=XXX password=XXX host=localhost sslmode=require")
psql_conn.close()

pfigue

Ubuntu PPA cheatsheet

Installing a new PPA

With this command:

sudo add-apt-repository ppa:<ppa_name>

which needs an extra software package:

• On Ubuntu >=14.04: sudo apt-get install software-properties-common

pfigue

Show active and idle connections grouped by state and client address for all the databases in the server:

SELECT count(datid), state, client_addr FROM pg_stat_activity group by state, client_addr;

pfigue

FROM phusion/baseimage:0.9.16
RUN apt-get update
RUN apt-get install -y ruby1.9.3 ruby-dev postgresql-9.3 postgresql-server-dev-9.3 make g++
RUN gem install bundler gitrob
RUN bash -c 'service postgresql start; sleep 5;' && sudo -u postgres psql -c "CREATE USER gitrob WITH PASSWORD 'gitrob';"
RUN bash -c 'service postgresql start; sleep 5;' && sudo -u postgres psql -c "CREATE DATABASE gitrob WITH OWNER gitrob;"
ADD gitrobrc.yml /root/.gitrobrc
EXPOSE 9393
CMD service postgresql start

pfigue

psql -c "SELECT pg_is_in_recovery();"  # true for standby, false for master
psql -c "SELECT txid_current_snapshot();"
psql -c "select pg_last_xlog_receive_location()"  # from standby
psql -c "select pg_last_xlog_replay_location()"  # from standby
psql -c "SELECT pg_current_xlog_location()"   # from master

pfigue

Show virtual hosts:

sudo rabbitmqctl list_vhosts

Show who is connected where:

sudo rabbitmqctl -n rabbit@node list_connections user vhost peer_host

Check credentials (requires management plugin enabled):

pfigue

#!/usr/bin env python
#coding: utf-8

import re
from json import dumps
from sys import (stdin, exit)


DEBUG_LEVEL = 0x0
PARSER = 0x01

pfigue

# Installing fpm in Ubuntu 14.04

sudo apt-get install ruby-dev gcc build-essential  # build-essential is for make
sudo gem install fpm

pfigue

# Build requirements: wget, gcc, make, fpm, tcl (>=8.5)

SOURCE=https://github.com/antirez/redis/archive/3.0.0-beta8.tar.gz
VERSION=3.0.0beta8
ARCH=amd64
BUILD_DIR=/home/ubuntu/builder/

cd $BUILD_DIR
rm -rf redis-$VERSION
wget $SOURCE -O redis-$VERSION.tar.gz

pfigue

forge "https://forgeapi.puppetlabs.com"

mod 'puppetlabs/apt', '1.5.1'