Backup Postgresql Database on Fedora Linux

I had a need to backup my various databases on my home server.  My environment consists of postgresql running on a fedora 17 server.

Backing up
create a cronjob with the command:
crontab -e

put this entry in the file:
50 23 * * * /bin/pg_dumpall -U postgres > /storage/databases/postgres.backup
this tells it to dump all of the databases using the postgres user and put them in a file out in /storage/databases/

Restore
Run the following command as the postgres user.
psql -f /storage/databases/postgres.backup

I back the /storage area up on a nightly basis to external media.

I may in the future incorporate some compression and a file rotation into a script, but at this juncture I haven't had a need for that.

updating Fedora 15 to 16 using preupgrade-cli

Ok I recently updated my fedora 15 to fedora 16 on my workstation at home.

the really easy way to do this is with preupgrade

I happen to like the command line so I used

 #yum -y install preupgrade  
 #preupgrade-cli "Fedora 16 (Verne)"  

Answer yes to the question of do you want to do this.

Just reboot when done and it will do the upgrade for you.  If you have issues Fedora has a good document at http://fedoraproject.org/wiki/How_to_use_PreUpgrade that has a lot of trouble shooting tips.

How to extract .tar.gz , .tar.bz2, .tgz, and .tar files on linux at the command line

Ok there are lots of flags you can use to extract these but the easiest way that pretty much works for them all is.

 #tar xvf filename  

this should work for all of them on a modern version of linux.

Released Version 1.2 of Expenses Simply

My Expenses Simply App has been updated to version 1.2.  I've added a feature to email your entries in a comma separated form (easy to import into desktop apps).

Here is the original post announcing the applications.

Apps to setup an SSH socks proxy on android

So I had a need to access a website that is on a private home network which resides behind a Linux server. The only way into this box is through an SSH connection that only takes rsa keys.

The two apps I used are sshtunnel and proxydroid. Both of these are available in the market.

My sshtunnel settings

My proxydroid settings

After that just fire up the browser and browse to the site. For quicker access I put the widgets for each application on my desktop so that I can launch them quickly.

Life tracking/hacking

Thought I'd get into a bit of life tracking / hacking and figure out what kind of patterns my body gets into and how they interelate.

First up is to track my sleeping patterns.  I'm going to try to track when I fall asleep initially and when I wake up.  I may follow this up with when I actually get into bed and when I crawl out of bed/hit the sleep alarm.  who knows this might turn into something neat.

I think I might post weekly stats on this blog as I go... who knows.

Released Version 1.1 of Expenses Simply

So this is just a minor bug fix.  I've released version 1.1 of my Android App Expenses Simply.  Please give it a whirl and let me know if you are having any issues with it.