crusat

# This file is zentralized to be a Turorial.
# I'm not sure about the full selfish-work.
# We will isntall OpenSSL,NginX,PostgreSQL.
# Than we will isntall Ajenti.
# Than you must configurate Ajenti to not use SSL (we will changethis later back)
# Followed we install Wordpress and you will have to install some plugins for PSQL and Nginx.
# Ready to press words!
# ----------
#remove instalaltion hardware ofthe sources.list
nano /etc/apt/sources.list

crusat

install PostgreSQL 9 in Mac OSX via Homebrew


Mac OS X Snow Leopard
System Version: Mac OS X 10.6.5
Kernel Version: Darwin 10.5.0


Install notes for PostgreSQL 9.0.1 install using Homebrew:
	sh-3.2# brew install postgresql

crusat

PSQL

Magic words:

psql -U postgres

If run with -E flag, it will describe the underlaying queries of the \ commands (cool for learning!).

Most \d commands support additional param of __schema__.name__ and accept wildcards like *.*

crusat

on openTerminal(location, remoteHost, serverPort)
	
	tell application "System Events"
		-- some versions might identify as "iTerm2" instead of "iTerm"
		set isRunning to (exists (processes where name is "iTerm")) or (exists (processes where name is "iTerm2"))
	end tell
	
	tell application "iTerm"
		activate
		set targetTab to ""