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 …


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 …

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…

Under windows:

1) open postgresdatapg_hba.conf
    Add “host all all 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…