silver lee agfe2silver

Instructions to Upgrade PostgreSQL to v14 (Ubuntu)

Migration plan
Rollback plan
Playbook
1. Backup

Download InstantClient

mkdir -p /opt/oracle
cd /opt/oracle
wget https://download.oracle.com/otn_software/linux/instantclient/218000/instantclient-basic-linux.x64-21.8.0.0.0dbru.zip
unzip instantclient-basic-linux.x64-21.8.0.0.0dbru.zip

Download SQLPlus

Python installation guide

These are my notes, not a generic solution. They are not meant to work anywhere outside my machines. Update version numbers to whatever are the current ones while you do this.

Install `asdf` and its python plugin, then install Python

asdf lives in https://github.com/asdf-vm/asdf

Follow its installation instructions, which at the moment of writing were:

openssl 🔐

Install

Install the OpenSSL on Debian based systems

sudo apt-get install openssl

About

Vim (Vi IMproved)
created by Bram Moolenaar
initial release 1991 (Vi was released 1976)
still in active development

	1) In your terminal, open the file using vim:

	vim file_name
	2) Remove all BOM characters:

	:set nobomb
	3) Save the file:

	:wq

	{
	// Parser options for extracting HTML, see https://github.com/lokalise/i18n-ally/blob/master/src/extraction/parsers/options.ts
	"i18n-ally.extract.parsers.html": {
	"attributes": ["text", "title", "alt", "placeholder", "label", "aria-label"],
	"ignoredTags": ["script", "style"],
	"vBind": true,
	"inlineText": true
	},
	// Enables hard-coded strings detection automatically whenever opening supported a file
	"i18n-ally.extract.autoDetect": true,

	# Check these threads before proceeding:
	# https://github.com/microsoft/WSL/discussions/5857
	# https://github.com/microsoft/WSL/issues/5821
	if (-Not ([Security.Principal.WindowsPrincipal] [Security.Principal.WindowsIdentity]::GetCurrent()).IsInRole([Security.Principal.WindowsBuiltInRole] 'Administrator')) {
	$CmdLine = "-File `"" + $MyInvocation.MyCommand.Path + "`" " + $MyInvocation.UnboundArguments
	Start-Process -FilePath PowerShell.exe -Verb Runas -ArgumentList $CmdLine
	Exit
	}
	# Restart the Host Network Service
	Restart-Service -Force -Name hns

	{
	"ConnectDDHH_log" : {
	"title" : "ConnectDDHH log format",
	"description" : "Log format used by ConnectDDHH",
	"regex" : {
	"default" : {
	"pattern" : "^\\[(?<timestamp>\\d{4}-\\d{2}-\\d{2} \\d{2}:\\d{2}:\\d{2}(?:\\.\\d+)?)\\] MSG_CONNECT_RESULT RCode:{(?<RCode>(?:-)?\\d+)} (?<body>.*)$"
	}
	},
	"level-field" : "RCode",