Dezinger

# Fast server stop
sudo -u postgres /usr/pgsql-9.1/bin/pg_ctl -D /var/lib/pgsql/9.1/data stop -m fast

# To create a database instance, after install do
sudo mkdir -p /opt/local/var/db/postgresql93/defaultdb
sudo chown postgres:postgres /opt/local/var/db/postgresql93/defaultdb
sudo su postgres -c '/opt/local/lib/postgresql93/bin/initdb -D /opt/local/var/db/postgresql93/defaultdb' 
#или
sudo su postgres -c '/opt/local/lib/postgresql93/bin/initdb --locale=ru_RU.UTF-8 --lc-collate=ru_RU.UTF-8 --lc-ctype=ru_RU.UTF-8 --encoding=UTF8 -D /opt/local/var/db/postgresql93/localdb'

Dezinger

ps -ax | grep post

Dezinger

otool -L /usr/lib/libssl.0.9.7.dylib

Dezinger

pkgutil --expand MAMP_2.1.1.pkg /tmp/test/mamp211/

Dezinger

CREATE TABLE foo (c1 integer, c2 text);
INSERT INTO foo
  SELECT i, md5(random()::text)
  FROM generate_series(1, 1000000) AS i;

Dezinger

CREATE OR REPLACE FUNCTION random(numeric, numeric)
RETURNS numeric AS
$$
   SELECT ($1 + ($2 - $1) * random())::numeric;
$$ LANGUAGE 'sql' VOLATILE;


SELECT random(1,10)::int, random(1,10);

Dezinger

mkdir ~/git/website.git && ~/git/cd website.git
git init --bare

mkdir ~/webapps/website
git config core.bare false
git config core.worktree /home/rafi/webapps/website      ; NO TRAILING SLASH!!! Will screw up things real bad.
git config receive.denycurrentbranch ignore
; create a hook
cat > hooks/post-receive
#!/bin/sh

Dezinger

telnet localhost 11211

Command 	Description 	Example
get 	Reads a value 	get mykey
set 	Set a key unconditionally 	set mykey 0 60 5
add 	Add a new key 	add newkey 0 60 5
replace 	Overwrite existing key 	replace key 0 60 5
append 	Append data to existing key 	append key 0 60 15
prepend 	Prepend data to existing key 	prepend key 0 60 15
incr 	Increments numerical key value by given number 	incr mykey 2

Dezinger

-- Запросы по сбору статистики PostgreSql 9.3.x

-- Процессы которые висят более 20 секунд
select * from pg_stat_activity where state != 'idle' and current_timestamp - query_start > '20 sec';

-- К-во update-тов за время с последнего сброса статистики
SELECT relname, n_tup_ins + n_tup_upd + n_tup_del from pg_stat_user_tables order by 2 desc limit 5;

-- Сброс статистики
SELECT pg_stat_reset();

Dezinger

<?php

$retries = 0;

function fetch() {
    global $retries;

    echo "Retry " . $retries . " | ";

    $opts = array(