TL;DR
Install Postgres 9.5, and then:
sudo pg_dropcluster 9.5 main --stop
sudo pg_upgradecluster 9.3 main
sudo pg_dropcluster 9.3 main| final=800 | |
| counter=0 | |
| while [ $counter -le $final ]; do | |
| printf "\r %75s/%4s" $counter $final | |
| sleep 1 | |
| ((counter++)); | |
| done | 
TL;DR
Install Postgres 9.5, and then:
sudo pg_dropcluster 9.5 main --stop
sudo pg_upgradecluster 9.3 main
sudo pg_dropcluster 9.3 main| # Source: http://www.jbmurphy.com/2013/09/23/quick-powershell-script-to-check-dns-settings-on-all-servers/ | |
| # Could use error checking to not throw an alert when the server isn't accessible | |
| $AllServers=Get-ADComputer -Filter {OperatingSystem -Like "Windows Server*"} | |
| ForEach ($Server in $AllServers){ | |
| $Result=Get-WmiObject -Class Win32_NetworkAdapterConfiguration -Filter "IPEnabled = 'True'" -Property DNSServerSearchOrder -ComputerName $Server.Name | |
| $output = new-object PSObject | |
| $output | add-member NoteProperty "ComputerName" $Server.Name | |
| $output | add-member NoteProperty "DNSServerSearchOrder" $Result.DNSServerSearchOrder | |
| $output | 
| # http://use-powershell.blogspot.com/2013/04/find-all-domain-controllers-in-domain.html | |
| Get-ADDomainController -Filter * |Select-Object name | 
| #!/bin/bash | |
| # This works only if postfix is running. It is complete, but when dealing with large queues due to spam loads,etc., it can take a long time | |
| #mailq |cut -f 1 -d " "|egrep -v "^\(|^$|^-|\*" |xargs postcat -q |grep "X-PHP-Originating-Script"|sort|uniq | |
| # This will work when postfix is not running. It may run faster, but it may also get stuck due to long argument lists. | |
| postcat /var/spool/postfix/maildrop/* |grep "X-PHP-Originating-Script"|sort|uniq | |
| postcat /var/spool/postfix/*/* |grep "X-PHP-Originating-Script"|sort|uniq | |
| postcat /var/spool/postfix/*/*/* |grep "X-PHP-Originating-Script"|sort|uniq | 
| #/bin/sh | |
| # Prints the uptime of mysql | |
| # Optional: Takes one argument for the servername, default is localhost | |
| # Set $host | |
| if [ $1 ]; then | |
| host=$1 | |
| else | |
| host="localhost" | 
| ### VARIABLES ### \ | |
| SERVER=$(hostname) | |
| MYSQL_CHECK=$(mysql -e "SHOW VARIABLES LIKE '%version%';" || echo 1) | |
| SLAVE_STATUS=$(/usr/bin/mysql -e "SHOW SLAVE STATUS\G"|grep -v row) | |
| LAST_ERRNO=$(echo "${SLAVE_STATUS}" | grep "Last_Errno:" | awk '{ print $2 }' ) | |
| SECONDS_BEHIND_MASTER=$(echo "${SLAVE_STATUS}" | grep "Seconds_Behind_Master:" | awk '{ print $2 }' ) | |
| IO_IS_RUNNING=$(echo "${SLAVE_STATUS}" | grep "Slave_IO_Running:" | awk '{ print $2 }' ) | |
| SQL_IS_RUNNING=$(echo "${SLAVE_STATUS}" | grep "Slave_SQL_Running:" | awk '{ print $2 }' ) | |
| SLAVE_IO_STATE=$(echo "${SLAVE_STATUS}" | grep "Slave_IO_State:" | awk -F':' '{gsub(/^[ \t]+/,"",$2);gsub(/[ \t]+$/,"",$2); print $2 }' ) | |
| ERRORS=() | 
| #!/bin/bash | |
| ### VARIABLES ### \ | |
| [email protected] | |
| SERVER=$(hostname) | |
| MYSQL_CHECK=$(mysql -e "SHOW VARIABLES LIKE '%version%';" || echo 1) | |
| SLAVE_STATUS=$(/usr/bin/mysql -e "SHOW SLAVE STATUS\G"|grep -v row) | |
| LAST_ERRNO=$(echo "${SLAVE_STATUS}" | grep "Last_Errno:" | awk '{ print $2 }' ) | |
| SECONDS_BEHIND_MASTER=$(echo "${SLAVE_STATUS}" | grep "Seconds_Behind_Master:" | awk '{ print $2 }' ) | |
| IO_IS_RUNNING=$(echo "${SLAVE_STATUS}" | grep "Slave_IO_Running:" | awk '{ print $2 }' ) | 
I hereby claim:
To claim this, I am signing this object:
| #!/bin/sh | |
| user=$1 | |
| vpnconf="/etc/openvpn" | |
| rsa="$vpnconf/easy-rsa" | |
| cd $rsa | |
| source vars | |
| ./build-key $user | |
| mkdir ~/$user.vpnfiles |