cimmanon

I use PostgreSQL via the psql client. If you use a different client (eg. pgAdmin, etc.), I don't know how much will translate over.

One nice difference between psql and mysql (cli) is that if you press CTRL+C, it won't exit the client.

User administration

Login as superuser (via shell)

psql -U postgres

andreipak

#!/bin/bash
 
/sbin/ss -ant | awk "{if (NR>1) {state[\$1]++}} END {host = \"-\"; \
for (i in state) {s=i; \
sub (/ESTAB/, \"establ\", s); sub (/LISTEN/, \"listen\", s); sub (/SYN-SENT/, \"synsent\", s); \
sub (/SYN-RECV/, \"synrecv\", s); sub (/FIN-WAIT-1/, \"finw1\", s); sub (/FIN-WAIT-2/, \"finw2\", s); \
sub (/CLOSE-WAIT/, \"closew\", s); sub (/TIME-WAIT/, \"timew\", s); print host, \"tcp.\"s, state[i]}}" \
| /usr/bin/zabbix_sender -vv -c /etc/zabbix/zabbix_agentd.conf -i - 2>&1
echo "1"
exit 0

raws

JAVA6_PATH="/System/Library/Java/JavaVirtualMachines/1.6.0.jdk/Contents/Home/bin"
JAVA7_PATH="/Library/Internet Plug-Ins/JavaAppletPlugin.plugin/Contents/Home/bin"

if [ -d "$JAVA6_PATH" ]; then
	ln -sv "${JAVA6_PATH}/java" "/usr/local/bin/java6"
	ln -sv "/usr/local/bin/java6" "/usr/local/bin/java"
else
	echo "Error: Java 6 is not installed at ${JAVA6_PATH}"
fi