Nekrasov Pavel freeart

freeart / gist:7621594

Last active December 29, 2015 05:28 — forked from ivanvanderbyl/gist:4222308

	sudo add-apt-repository ppa:pitti/postgresql
	sudo apt-get update
	sudo apt-get install postgresql-9.3 postgresql-server-dev-9.3 postgresql-contrib-9.3

	sudo su -l postgres
	psql -d template1 -p 5433
	CREATE EXTENSION IF NOT EXISTS hstore;
	CREATE EXTENSION IF NOT EXISTS "uuid-ossp";
	\q
	/usr/lib/postgresql/9.3/bin/pg_upgrade -b /usr/lib/postgresql/9.1/bin -B /usr/lib/postgresql/9.3/bin -d /var/lib/postgresql/9.1/main/ -D /var/lib/postgresql/9.3/main/ -O "-c config_file=/etc/postgresql/9.3/main/postgresql.conf" -o "-c config_file=/etc/postgresql/9.1/main/postgresql.conf"

freeart / test-uuid-v5.js

Created August 25, 2014 22:48 — forked from hmalphettes/test-uuid-v5.js

	var expect = require('chai').expect;
	var UUID = require('./uuid-v5');
	describe('When generating a uuid v5', function() {
	it('must generate the expected uuids from 3 examples on the web', function() {
	var testUrl = UUID.v5(UUID.URL, 'www.example.org');
	var testDns = UUID.v5(UUID.DNS, 'www.example.org');
	var testDns2 = UUID.v5(UUID.DNS, 'php.net');
	// see the examples here: http://jsfiddle.net/rexmac/F3pwA/
	expect(testDns).to.equal('74738ff5-5367-5958-9aee-98fffdcd1876');
	expect(testUrl).to.equal('abe19220-c90c-5288-b33a-58772250d428');

freeart / upgrade-postgres-9.5-to-9.6.md

Created April 18, 2018 14:19 — forked from delameko/upgrade-postgres-9.5-to-9.6.md

Upgrading PostgreSQL from 9.5 to 9.6 on Ubuntu 16.04

TL;DR

Install Postgres 9.5, and then:

sudo pg_dropcluster 9.6 main --stop
sudo pg_upgradecluster 9.5 main
sudo pg_dropcluster 9.5 main