dcai

Hey! I saw this has been indexed by the search engines. It is a first draft of a post I ended up publishing on my blog at: Scaling PostgreSQL With Pgpool and PgBouncer

Thanks for stopping by!

PostgreSQL and Pgpool Architecture

Install the latest JRE from Oracle
In the Java Control Panel, go to the Security tab and make sure 'Enable Java Content' is checked
Open Safari
Go to the ATO Business portal site https://bp.ato.gov.au/BpStatics/homepage.htm
Click Login
A dialog will apear asking you 'Do you want to trust the website “authentication.business.gov.au” to use the “Java” plug-in?'
Click 'Trust'
Now you will be asked 'Do you want to run this application?'
Click 'Run'
Another dialog will appear asking you to 'Allow access to the following application from this website?'

	<?php

	/**
	* Redis based session handler.
	*
	* @copyright 2015 Dongsheng Cai {@link http://dongsheng.org}
	* @license http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
	*/

	/**

	echo "deb http://apt.postgresql.org/pub/repos/apt/ precise-pgdg main" \| sudo tee /etc/apt/sources.list.d/pgdg.list
	wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc \| sudo apt-key add -
	sudo apt-get update
	sudo apt-get install postgresql-9.3 postgresql-server-dev-9.3 postgresql-contrib-9.3 -y

	sudo su - postgres -c "psql template1 -p 5433 -c 'CREATE EXTENSION IF NOT EXISTS hstore;'"
	sudo su - postgres -c "psql template1 -p 5433 -c 'CREATE EXTENSION IF NOT EXISTS \"uuid-ossp\";'"
	sudo su - postgres -c "service postgresql stop"
	sudo su - postgres -c '/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"'

	#!/bin/sh
	# Command-line world clock
	# Taken from http://stackoverflow.com/questions/370075/command-line-world-clock

	# .worldclock.zones file looks like:
	# US/Pacific
	# Europe/Berlin
	# Chile/Continental

	: ${WORLDCLOCK_ZONES:=$HOME/.worldclock.zones}