Bookmarked. Definitely could've used this post when I was just starting with PostgreSQL!
I'm planning to cover more things about PostgreSQL, mostly using pg_dump, pg_restore, pg_upgrade, initdb etc., just the regular things you should know when using it on your own VPS.