Date posted: March 22, 2012 | Posted by: Andrew Hill

When dealing with USB backups, I would traditionally just mount and rsync to the device, with a simple script like this :

mount /dev/sdc1 /mnt

rsync /home /mnt

umount /dev

This approach fails though when the device is unplugged while …

Date posted: February 5, 2011 | Posted by: Andrew Hill

Linux

Under Linux, type command in postgres database:

set lc_monetary to 'ar_BH.utf8';

ar_BH represents Arabic (Bahrain) locale, the above command change the locale monetary setting on-the-fly in postgresql database, then let do a test:

select 34.888::text::money;

You will get 34.888 …

Date posted: August 25, 2010 | Posted by: Andrew Hill

In west Australia, like Perth, when you are using postgresql database, you may need to change the time zone abbreviations to Australia:

change it for a session

postgres=# set timezone_abbreviations to ‘Australia’;

change it for database

postgres=# alter database DATABASENAME…

Date posted: April 7, 2010 | Posted by: Andrew Hill

Under windows:

1) open postgresdatapg_hba.conf
    Add “host all all 0.0.0.0/0 md5” , save and close;

2) open postgresql.conf
    change listen_addresses=’localhost’
            to  listen_addresses=’*’
    save and close

3) restart postgresql service:
    net restart postgresql…