goncha

-- show running queries (pre 9.2)
SELECT procpid, age(clock_timestamp(), query_start), usename, current_query 
FROM pg_stat_activity 
WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%' 
ORDER BY query_start desc;

-- show running queries (9.2)
SELECT pid, age(clock_timestamp(), query_start), usename, query 
FROM pg_stat_activity 
WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%' 

goncha

.PHONY: _pwd_prompt decrypt_conf encrypt_conf

CONF_FILE=conf/settings.json

# 'private' task for echoing instructions
_pwd_prompt:
  @echo "Contact [email protected] for the password."

# to create conf/settings.json
decrypt_conf: _pwd_prompt

goncha

apply plugin: 'eclipse'
apply plugin: 'idea'
apply plugin: 'java'

project.version = "1.0"

try {
    new ByteArrayOutputStream().withStream { os ->
        def result = exec {
        	executable = 'svn'

goncha

@echo off

D:\ffmpeg\bin\ffmpeg.exe  -i %1 -f mp4 -c:v mpeg4 -b:v 2000k -g 300 -bf 2 -pass 1 -an -f rawvideo -y NUL
D:\ffmpeg\bin\ffmpeg.exe  -i %1 -f mp4 -c:v mpeg4 -b:v 2000k -g 300 -bf 2 -pass 2 -c:a copy %2

goncha

#!/bin/sh

FLAC="${1:-Disc.flac}"
CUE="${FLAC%%.flac}.cue"


if [ ! -r "$CUE" ]
then
    echo "Cannot read '$CUE'"
    exit 1

goncha

apply plugin: 'eclipse'
apply plugin: 'idea'
apply plugin: 'java'

project.version = "1.0"

try {
    new ByteArrayOutputStream().withStream { os ->
        def result = exec {
        	executable = 'svn'

goncha

#!/bin/sh

cd $HOME/public_html/voanews

SENEWS=$(date '+%y%m%d')_SE_NEWS.mp3
HLNEWS=$(date '+%y%m%d')_HL_NEWS.mp3

wget -O "${SENEWS}" \
        "http://www.voanews.com/mp3/voa/english/spec/SPECIAL_ENGLISH_NEWS.mp3"

goncha

;; This buffer is for notes you don't want to save, and for Lisp evaluation.
;; If you want to create a file, visit that file with C-x C-f,
;; then enter the text in that file's own buffer.

(setq temp-articles '(
"progbot.html"
"lwba.html"
"avg.html"
"javacover.html"
"popular.html"

goncha

backend host1
        mode http
        server  inst1 host1:port1

backend host2
        mode http
        server  inst1 host2:port2

frontend http-in
        bind :80

goncha

System

1. Disable SELinux in `/etc/selinux/config` (need reboot)
2. Install RPMFusion free&nofree repos rpm
3. Install Wifi BCM4313 driver `yum install kmod-wl` after Step 2
4. Install Adobe and Google repos rpm
5. Install 163 mirror repos (http://mirrors.163.com/.help/fedora.html)
6. Install build-essential alternative, `yum install make automake gcc gcc-c++ kernel-devel` or `yum-builddep sqlite` or `yum groupinstall “Development Tools”`
7. Configure yum use proxy in /etc/yum.conf