rgreenjr

-- 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%' 

jgn

Stuff I learned about Puppet

Chef vs Puppet

• My blink is that in 2012 Puppet is safer and more productive.
• Puppet is declarative, Chef procedural.
• Puppet brings system into compliance (state), Chef "does" things (recipes).
• Puppet has strong security practices; Chef has a toleration for loose security in Chef itself.
• Puppet makes it very hard to get "outside the lines" or violate its strong opinions; in Chef this is routine.

wjrogers

@ECHO OFF
REM -- Automates cygwin installation

SETLOCAL

REM -- Change to the directory of the executing batch file
CD %~dp0

REM -- Configure our paths
SET SITE=http://mirrors.kernel.org/sourceware/cygwin/