tomka

#!/usr/bin/env sh
# Watch Al Jazeera live stream with mplayer. You can specify the
# quality as argument by passing either "low", "high" or "veryhigh"
# to the script. If nothing is given it defaults to "veryhigh".

function printUsage() {
        echo "Please pass no arguments or either \"low\", \"high\" or \"veryhigh\". No arguments defaults to \"veryhigh\"."
}

# default quality

tomka

-- show running queries (pre 9.2)
SELECT procpid, age(query_start, clock_timestamp()), 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(query_start, clock_timestamp()), usename, query 
FROM pg_stat_activity 
WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%' 

tomka

NOTE: requires an EFI bios, so zfs will not use the whole disk as this is a single disk scenario.



/*\
|* Prerequisite: preare archiso with zfs support
\*****************************************************************************/

// 0. Do everything as root.

tomka

NOTE: requires an EFI bios, so zfs will not use the whole disk as this is a single disk scenario.



/*\
|* Prerequisite: preare archiso with zfs support
\*****************************************************************************/

// 0. Do everything as root.