Clairton Luz clairtonluz

clairtonluz / postgres_queries_and_commands.sql

Created April 23, 2019 13:36 — forked from rgreenjr/postgres_queries_and_commands.sql

Useful PostgreSQL Queries and Commands

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

clairtonluz / autopgsqlbackup

Created February 18, 2018 13:58 — forked from matthewlehner/autopgsqlbackup

Auto PostgreSQL backup script.

	#!/bin/bash
	#
	# PostgreSQL Backup Script Ver 1.0
	# http://autopgsqlbackup.frozenpc.net
	# Copyright (c) 2005 Aaron Axelsen <[email protected]>
	#
	# This script is based of the AutoMySQLBackup Script Ver 2.2
	# It can be found at http://sourceforge.net/projects/automysqlbackup/
	#
	# The PostgreSQL changes are based on a patch agaisnt AutoMySQLBackup 1.9

clairtonluz / jdk_download.sh

Last active August 29, 2015 14:07 — forked from P7h/jdk_download.sh

	# Get the actual url from http://www.oracle.com/technetwork/java/index.html
	# And replace the download.oracle.com portion from the below string.

	# http://stackoverflow.com/questions/10268583
	# wget --no-check-certificate --no-cookies - --header "Cookie: oraclelicense=accept-securebackup-cookie" http://download.oracle.com/otn-pub/java/jdk/7u51-b13/jdk-7u51-linux-x64.tar.gz


	#JDK8u20
	BASE_URL=http://download.oracle.com/otn-pub/java/jdk/8u20-b26/jdk-8u20
	wget --no-check-certificate --no-cookies - --header "Cookie: oraclelicense=accept-securebackup-cookie" "${BASE_URL}-apidocs.zip"