Skip to content

Instantly share code, notes, and snippets.

View gplv2's full-sized avatar
😁

Glenn Plas gplv2

😁
View GitHub Profile
@gplv2
gplv2 / upgrade-postgresql-service-ubuntu.md
Created July 3, 2023 22:17 — forked from ShvaykaD/upgrade-postgresql-service-ubuntu.md
Upgrading PostgreSQL service from 9.x or 10.x to 11 version on Ubuntu server

TL;DR

Create a backup:

sudo -Hiu postgres pg_dumpall > mybackup.sql

Install Postgres 11, and then:

@ahmpro
ahmpro / haproxy.cfg
Created September 8, 2017 16:41 — forked from arkady-emelyanov/haproxy.cfg
haproxy check: postgresql is master
# 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:
@arkady-emelyanov
arkady-emelyanov / haproxy.cfg
Last active October 25, 2023 22:02
haproxy check: postgresql is master
# 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:
@gplv2
gplv2 / downgrade.sh
Last active July 13, 2017 16:46 — forked from jcowley/downgrade.sh
Downgrade Apache + PHP on Ubuntu 14.04
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 \
@ZhangYiJiang
ZhangYiJiang / ResetPassword.php
Created May 5, 2016 12:19
Reset user password command for Laravel
<?php
namespace App\Console\Commands;
use App\User;
use Illuminate\Console\Command;
use Illuminate\Contracts\Auth\UserProvider;
class ResetPassword extends Command
{
@deanrather
deanrather / ErrorHandler.js
Created February 11, 2016 07:18
NodeJS Error Handler
process.on
(
'uncaughtException',
function (err)
{
var stack = err.stack;
var timeout = 1;
// print note to logger
logger.log("SERVER CRASHED!");
@tkambler
tkambler / hubot_plugin.js
Last active October 7, 2015 10:49
A simple script that demonstrates how you can create a Hubot plugin with raw JavaScript (i.e. without CoffeeScript)
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:
@msurguy
msurguy / List.md
Last active September 8, 2023 04:07
List of open source projects made with Laravel

Other people's projects:

My projects (tutorials are on my blog at http://maxoffsky.com):

@matteobertozzi
matteobertozzi / psql-srv.py
Created November 27, 2013 05:17
postgres "server" wire protocol example
# 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
# ---+---
@bertspaan
bertspaan / README.md
Last active March 17, 2018 17:40
TileMill project and SQL script to generate map tiles as seen on http://citysdk.waag.org/buildings/

Buildings in the Netherlands by year of construction

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.

Download and import BAG data

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