wavle

NOTE

These are NOT product / license keys that are valid for Windows activation.
These keys only select the edition of Windows to install during setup, but they do not activate or license the installation.

Index

Windows 11
RTM Generic Keys

M3 Demo

This repository contains a docker-compose file which can be used to setup a demo of the M3 stack. It runs the following containers:

M3DB
M3Coordinator
Prometheus
Grafana

Setup

Ansible variable precedence

Source: http://docs.ansible.com/ansible/latest/playbooks_variables.html#variable-precedence-where-should-i-put-a-variable

From least to most important

command line values (for example, -u my_user, these are not variables)
role defaults (defined in role/defaults/main.yml)
inventory file or script group vars
inventory group_vars/all

TL;DR

9.4 -> 9.5:

sudo pg_dropcluster 9.5 main --stop
sudo service postgresql stop
sudo pg_upgradecluster -m upgrade -k 9.4 main
sudo su postgres -c "/usr/lib/postgresql/9.5/bin/vacuumdb --all --analyze-in-stages"
sudo pg_dropcluster 9.4 main

Combining two git repositories

Use case: You have repository A with remote location rA, and repository B (which may or may not have remote location rB). You want to do one of two things:

preserve all commits of both repositories, but replace everything from A with the contents of B, and use rA as your remote location
actually combine the two repositories, as if they are two branches that you want to merge, using rA as the remote location

NB: Check out git subtree/git submodule and this Stack Overflow question before going through the steps below. This gist is just a record of how I solved this problem on my own one day.

Before starting, make sure your local and remote repositories are up-to-date with all changes you need. The following steps use the general idea of changing the remote origin and renaming the local master branch of one of the repos in order to combine the two master branches.

	http://104.28.1.30:8080/announce

	http://104.28.16.69/announce

	http://107.150.14.110:6969/announce

	http://109.121.134.121:1337/announce

	http://114.55.113.60:6969/announce

	-----------------------------------------------
	-- Set up
	-----------------------------------------------

	local hyper = {"cmd", "alt", "ctrl"}

	hs.window.animationDuration = 0.05

	-----------------------------------------------
	-- hyper left for left one half window

	SELECT
	now()-pg_postmaster_start_time() "Uptime", now()-stats_reset "Since stats reset",
	round(100.0*checkpoints_req/total_checkpoints,1) "Forced checkpoint ratio (%)",
	round(np.min_since_reset/total_checkpoints,2) "Minutes between checkpoints",
	round(checkpoint_write_time::numeric/(total_checkpoints*1000),2) "Average write time per checkpoint (s)",
	round(checkpoint_sync_time::numeric/(total_checkpoints*1000),2) "Average sync time per checkpoint (s)",
	round(total_buffers/np.mp,1) "Total MB written",
	round(buffers_checkpoint/(np.mp*total_checkpoints),2) "MB per checkpoint",
	round(buffers_checkpoint/(np.mpnp.min_since_reset60),2) "Checkpoint MBps",
	round(buffers_clean/(np.mpnp.min_since_reset60),2) "Bgwriter MBps",

	WITH temp_dirs AS (
	SELECT s1.dir \|\| s1.version \|\| '/pgsql_tmp' AS dir_name
	FROM
	(
	SELECT
	'pg_tblspc/' \|\| spc.oid::text \|\| '/' AS dir,
	l.version
	FROM
	(
	SELECT spc1.oid

	-- View pg_stat_activity with temporary files informations (file list and total file size)
	-- version 0.3

	SELECT
	pg_stat_activity.pid AS pid,
	CASE WHEN LENGTH(pg_stat_activity.datname) > 16
	THEN SUBSTRING(pg_stat_activity.datname FROM 0 FOR 6)\|\|'...'\|\|SUBSTRING(pg_stat_activity.datname FROM '........$')
	ELSE pg_stat_activity.datname
	END
	AS database,