iver

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

iver

Determine SSL cert expiration date from a PEM file:

$ openssl x509 -enddate -noout -in file.pem

Check many files:

for pem in /etc/ssl/certs/*.pem; do 

iver

Common Options

-#, --progress-bar Make curl display a simple progress bar instead of the more informational standard meter.

-b, --cookie <name=data> Supply cookie with request. If no =, then specifies the cookie file to use (see -c).

-c, --cookie-jar <file name> File to save response cookies to.

iver

#!/bin/bash
export PROJECT=stats
export RELEASE=${PROJECT}.tar.gz

PROG_NAME=$(basename $0)

while getopts :s:v: OPTION
do
  case ${OPTION} in
      s) TARGET=${OPTARG};;

iver

SHELL := /bin/bash
ACTUAL := $(shell pwd)
MIX_ENV=dev

export MIX_ENV
export ACTUAL

all: release

clean:

iver

SELECT
    'select pg_catalog.setval(pg_get_serial_sequence('''||
        pg_class.relname || ''', ''' ||
        pg_attribute.attname || '''), (SELECT MAX(' || pg_attribute.attname || ') FROM ' ||
        pg_class.relname || ') +1 ); '
    FROM pg_index, pg_class, pg_attribute
    WHERE
      pg_class.oid = pg_class.relname::regclass AND
      indrelid = pg_class.oid AND
       pg_attribute.attrelid = pg_class.oid AND

iver

package main

import "fmt"
import "time"

func main() {
	birth, _ := time.Parse("2006-01-02", "2000-11-10")
	duration := time.Since(birth)
	t1 := time.Unix(0,duration.Nanoseconds())
	// Remember, Thursday, 1 January 1970 is defined as first unix day

iver

-----------
-- Drop database connections
-----------

SELECT pg_terminate_backend(pg_stat_activity.pid)
FROM pg_stat_activity
WHERE pg_stat_activity.datname = 'database_name'
  AND pid <> pg_backend_pid();
  
-----------