TL;DR
Create a backup:
sudo -Hiu postgres pg_dumpall > mybackup.sql
Install Postgres 11, and then:
TL;DR
Create a backup:
sudo -Hiu postgres pg_dumpall > mybackup.sql
Install Postgres 11, and then:
# Sample haproxy postgresql master check | |
# | |
# haproxy listen: 5431 | |
# pg, instance #1 listen: 5432 (master node) | |
# pg, instance #2 listen: 5433 (replica node) | |
# external failover, promoting replica to master in case of failure | |
# passwordless auth for user web | |
# template1 database is accessible by user web | |
# | |
# haproxy will pass connection to postgresql master node: |
# Sample haproxy postgresql master check | |
# | |
# haproxy listen: 5431 | |
# pg, instance #1 listen: 5432 (master node) | |
# pg, instance #2 listen: 5433 (replica node) | |
# external failover, promoting replica to master in case of failure | |
# passwordless auth for user web | |
# template1 database is accessible by user web | |
# | |
# haproxy will pass connection to postgresql master node: |
cat <<EOF >> /etc/apt/sources.list | |
deb http://archive.ubuntu.com/ubuntu precise main restricted universe | |
deb http://archive.ubuntu.com/ubuntu precise-updates main restricted universe | |
deb http://security.ubuntu.com/ubuntu precise-security main restricted universe multiverse | |
EOF | |
apt-get update | |
apt-get remove \ | |
apache2 \ |
<?php | |
namespace App\Console\Commands; | |
use App\User; | |
use Illuminate\Console\Command; | |
use Illuminate\Contracts\Auth\UserProvider; | |
class ResetPassword extends Command | |
{ |
process.on | |
( | |
'uncaughtException', | |
function (err) | |
{ | |
var stack = err.stack; | |
var timeout = 1; | |
// print note to logger | |
logger.log("SERVER CRASHED!"); |
var util = require('util'); | |
/** | |
* A simple script that demonstrates how you can create a Hubot plugin with raw | |
* JavaScript (i.e. without CoffeeScript) | |
*/ | |
var Plugin = function(robot) { | |
/** | |
* Instruct Hubot to respond when a message is directed at him, like so: |
Other people's projects:
My projects (tutorials are on my blog at http://maxoffsky.com):
# th30z@u1310:[Desktop]$ psql -h localhost -p 55432 | |
# Password: | |
# psql (9.1.10, server 0.0.0) | |
# WARNING: psql version 9.1, server version 0.0. | |
# Some psql features might not work. | |
# Type "help" for help. | |
# | |
# th30z=> select foo; | |
# a | b | |
# ---+--- |
Map can be seen on http://citysdk.waag.org/buildings/. The map shows all 9,866,539 buildings in the Netherlands, shaded according to year of construction. Data from BAG, via CitySDK. Map made with TileMill by Bert Spaan, Waag Society, inspired by BKLYNR.
This README file explains how to get the data, create the map and export high-res PNG and PDF files.
First, install PostgreSQL and PostGIS. To download and import the latest BAG data into a local database, you can use the data, tools and tutorials provided