BryGom brygom

WAL-E needs to be installed on all machines, masters and slaves.

Only one machine, the master, writes WAL segments via continuous archiving. The configuration for the master postgresql.conf is:

archive_mode = on
archive_command = 'envdir /etc/wal-e.d/env wal-e wal-push %p'
archive_timeout = 60

	<!doctype html>
	<title>Site Maintenance</title>
	<style>
	body { text-align: center; padding: 150px; }
	h1 { font-size: 50px; }
	body { font: 20px Helvetica, sans-serif; color: #333; }
	article { display: block; text-align: left; width: 650px; margin: 0 auto; }
	a { color: #dc8100; text-decoration: none; }
	a:hover { color: #333; text-decoration: none; }
	</style>

	public class IMEI{

	public String getIMEI(){
	//add
	//<uses-permission android:name="android.permission.READ_PHONE_STATE" />
	//in manifest
	TelephonyManager tm = (TelephonyManager)getSystemService(TELEPHONY_SERVICE);
	String imei= tm.getDeviceId();
	return imei;

	#!/bin/bash

	# Install Xcode Command Line Tools first (required)
	xcode-select --install

	# Check PHP version `php --version`
	PHP_VER=$(php -v \| head -1 \| awk '{ print $2 }')

	# Extensions directory (default: empty string)
	EXT_DIR=""

	CREATE OR REPLACE FUNCTION ChangeObjectsOwnerShip(text)
	returns text language plpgsql volatile
	AS $f$
	BEGIN
	EXECUTE $1;
	RETURN $1;
	END;
	$f$;

	-- Tables, Sequences and Views

	SELECT zip, primary_city,
	latitude, longitude, distance
	FROM (
	SELECT z.zip,
	z.primary_city,
	z.latitude, z.longitude,
	p.radius,
	p.distance_unit
	* DEGREES(ACOS(COS(RADIANS(p.latpoint))
	* COS(RADIANS(z.latitude))

	CREATE OR REPLACE FUNCTION ChangeObjectsOwnerShip(text)
	returns text language plpgsql volatile
	AS $c$
	BEGIN
	EXECUTE $1;
	RETURN $1;
	END;
	$c$;

	SELECT ChangeObjectsOwnerShip

	sudo /Library/PostgreSQL/9.6/uninstall-postgresql.app/Contents/MacOS/installbuilder.sh
	sudo rm -rf /Library/PostgreSQL
	sudo rm /etc/postgres-reg.ini