Discover gists

Install PostgreSQL on Ubuntu without `sudo`

Being the most advanced open-source relational database, many of us need to install PostgreSQL for some purposes. However, sometimes you may not have sudo privilege on an Ubuntu server. Then, how should you install PostgreSQL in this case?

Compile from source!

Next, we will show a step-by-step guide on how to install PostgreSQL on Ubuntu by compiling it from source.

PostgreSQL Compilation & Installation

Modern Arch linux installation guide

1. The Meaning of Security

1.1. The Cultural Legacy: Business Prevention

Security has a bad reputation for getting in the way of real business
This reputation has developed because of the way security professionals have practised
We need an accurate definition of what we mean by ‘security’
A technical definition of security may not be helpful
Security can be defined only relative to the value and risk propositions of the business

1.2. Measuring and Prioritising Business Risk

Risk is a combination of asset value, business impact, threat and vulnerability
Risk management is a combination of risk assessment and ‘risk mitigation’

How to install virtualenv:

Install pip first

sudo apt-get install python3-pip

Then install virtualenv using pip3

sudo pip3 install virtualenv

	func ip2int(ip net.IP) uint32 {
	if len(ip) == 16 {
	return binary.BigEndian.Uint32(ip[12:16])
	}
	return binary.BigEndian.Uint32(ip)
	}

	func int2ip(nn uint32) net.IP {
	ip := make(net.IP, 4)
	binary.BigEndian.PutUint32(ip, nn)

	RUN apt update
	RUN apt upgrade -y
	RUN apt install -y apt-utils
	RUN a2enmod rewrite
	RUN apt install -y libmcrypt-dev
	RUN docker-php-ext-install mcrypt
	RUN apt install -y libicu-dev
	RUN docker-php-ext-install -j$(nproc) intl
	RUN apt-get install -y libfreetype6-dev libjpeg62-turbo-dev libpng12-dev
	RUN docker-php-ext-configure gd --with-freetype-dir=/usr/include/ --with-jpeg-dir=/usr/include/

	// 3D Dom viewer, copy-paste this into your console to visualise the DOM as a stack of solid blocks.
	// You can also minify and save it as a bookmarklet (https://www.freecodecamp.org/news/what-are-bookmarklets/)
	(() => {
	const SHOW_SIDES = false; // color sides of DOM nodes?
	const COLOR_SURFACE = true; // color tops of DOM nodes?
	const COLOR_RANDOM = false; // randomise color?
	const COLOR_HUE = 190; // hue in HSL (https://hslpicker.com)
	const MAX_ROTATION = 180; // set to 360 to rotate all the way round
	const THICKNESS = 20; // thickness of layers
	const DISTANCE = 10000; // ¯\\_(ツ)_/¯

	<#

	Azure App Settings / Environment Variables to local.settings.json Converter
	\| v1.0.0 \|-----------------------------------------------------------------

	This script will take an Azure App Settings JSON file and convert it to a
	local.settings.json file for use with Azure Functions.

	It also moves some of the Azure specific settings to the top of the file.

	sudo update-alternatives --install /usr/bin/x-terminal-emulator x-terminal-emulator $(which alacritty) 50
	sudo update-alternatives --config x-terminal-emulator