Full / Complete / Standalone Google Chrome Offline Installer

Standalone

http://www.google.com/chrome/eula.html?standalone=1

Multi-user

http://www.google.com/chrome/eula.html?system=true&standalone=1

PostgreSQL Backup and Restore

SQL Dump

pg_dump dbname > outfile 

psql -f infile postgres

pg_dump dbname | gzip > filename.gz

gunzip -c filename.gz | psql dbname 

pg_dump -Fc dbname > filename

pg_restore -d dbname filename 

File System Level Backup

tar -cf backup.tar /usr/local/pgsql/data

Continuous Archiving

archive_command = 'test ! -f /var/lib/pgsql/backup_in_progress || (test ! -f /var/lib/pgsql/archive/%f && cp %p /var/lib/pgsql/archive/%f)'

touch /var/lib/pgsql/backup_in_progress
psql -c "select pg_start_backup('hot_backup');"
tar -cf /var/lib/pgsql/backup.tar /var/lib/pgsql/data/
psql -c "select pg_stop_backup();"
rm /var/lib/pgsql/backup_in_progress
tar -rf /var/lib/pgsql/backup.tar /var/lib/pgsql/archive/

Eclipse : Unbound classpath container: JRE System Library [JavaSE-1.7]

Eclipse Errors:

The project cannot be buoilt until build path errors are resolved.
Unbound classpath container: 'JRE System Library [JavaSE-1.7]' in project

Resolution:

Add Java 1.7 JREs to Eclipse's JRE definitions.

Eclipse->Window->Preferences->Java->Installed JREs->Search.. Point to directory of Java

Can't Install downloaded Distribution Provisioning Profile Xcode 5.x nothing happens

Goto Xcode->Preferences..

Select Accounts.. or Add your Developer Account if not exists.

View Details.. Provisioning Profiles should be visible already

Unable to auto-detect email address when using Git repository for Xcode

Need to setup Git global config first.

Open Terminal

git config --global user.email "you@example.com"
git config --global user.name "Your Name"

Direct download Xcode 5.1 without App Store

Use Safari (for resumable feature) and Download from

https://developer.apple.com/downloads/index.action#

Enable Debug Menu of AppStore

Open Terminal.

Execute the following command.

defaults write com.apple.appstore ShowDebugMenu -bool TRUE

Transfer/Copy diagrams from OpenOffice Draw to Impress

From Draw, select diagrams/objects to copy.

Then right click, select Convert-> To Polygon

Then copy to clipboard.

From Impress, paste from clipboards.