Guilherme Caraciolo gcaraciolo

(wherever it says url.com, use your server's domain or IP)

Login to new server as root, then add a deploy user

sudo useradd --create-home -s /bin/bash deploy
sudo adduser deploy sudo
sudo passwd deploy

And Update the new password

	worker_processes 1;

	error_log logs/rtmp_error.log debug;
	pid logs/nginx.pid;

	events {
	worker_connections 1024;
	}

	http {

	-- show running queries (pre 9.2)
	SELECT procpid, age(query_start, clock_timestamp()), usename, current_query
	FROM pg_stat_activity
	WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%'
	ORDER BY query_start desc;

	-- show running queries (9.2)
	SELECT pid, age(query_start, clock_timestamp()), usename, query
	FROM pg_stat_activity
	WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%'

	#ifdef ENABLE_DEBUG
	#define DebugLog(format, args...) \
	NSLog(@"%s, line %d: " format "\n", \
	__func__, __LINE__, ## args);
	#else
	#define DebugLog(format, args...) do {} while(0)
	#endif

	// sample use
	DebugLog("number: %d ; class %p", count, className);