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();
  
-----------

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

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

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

export MIX_ENV
export ACTUAL

all: release

clean:

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

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

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

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

NOTES: After automatically updating Postgres to 10.0 via Homebrew, the pg_ctl start command didn't work. The error was "The data directory was initialized by PostgreSQL version 9.6, which is not compatible with this version 10.0."

Database files have to be updated before starting the server, here are the steps that had to be followed:

• Need to have both 9.6.x and latest 10.0 installed, and keep 10.0 as default

brew unlink postgresql
brew install postgresql@9.6
brew unlink postgresql@9.6

iver

PSQL

Magic words:

$ psql -U postgres

or

$ sudo -u postgres psql