Skip to content

Instantly share code, notes, and snippets.

@eknkc
eknkc / postgres_metrics.sql
Created February 27, 2016 00:49 — forked from sorentwo/postgres_metrics.sql
Postgres metric select statements
-- bgwriter
SELECT checkpoints_timed FROM pg_stat_bgwriter;
SELECT checkpoints_req FROM pg_stat_bgwriter;
SELECT write_time FROM pg_stat_bgwriter;
SELECT sync_time FROM pg_stat_bgwriter;
SELECT buffers_checkpoint FROM pg_stat_bgwriter;
SELECT buffers_clean FROM pg_stat_bgwriter;
SELECT maxwritten_clean FROM pg_stat_bgwriter;
SELECT buffers_backend FROM pg_stat_bgwriter;
SELECT buffers_backend_fsync FROM pg_stat_bgwriter;
@eknkc
eknkc / vpn.sh
Created March 13, 2013 15:25 — forked from alvinl/vpn.sh
#!/bin/bash
apt-get update
apt-get install pptpd -y
echo localip 192.168.240.1 >> /etc/pptpd.conf
echo remoteip 192.168.240.2-9 >> /etc/pptpd.conf
echo ms-dns 8.8.8.8 >> /etc/ppp/pptpd-options
echo ms-dns 8.8.4.4 >> /etc/ppp/pptpd-options
echo "vpn pptpd pass123 *" | tee -a /etc/ppp/chap-secrets
/etc/init.d/pptpd restart