Evgeniy Shurmin jpascal

A zoomable candlestick chart.

General

If you want to see your client website region, you can install GeoIP module on Nginx
The project I've worked on, using (Filebeat, Logstash, Elasticsearch) after GeoIP is installed then visualized using Kibana or Grafana :

sudo apt update
sudo apt install libnginx-mod-http-geoip

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

	#!/bin/bash
	# Runs Restic backup on a schedule via cron, emails with status
	# 1. add a cred file with your repo logins to /etc/restic/cred
	# 2.

	FROM="restic@$(hostname)"
	EMAIL="[email protected]"
	LOG="/var/log/restic.log"
	RDIR="/etc/restic"

	provider "cloudflare" {
	api_token = var.cf_api_token
	}
	variable "cf_api_token" {}
	variable "account_id" {}

	resource "random_id" "tunnel_secret" {
	byte_length = 35
	}