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 backups are working (the device name will change from /dev/sdc1 to /dev/sdd1), or if a… View Article

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 with 3 decimal places money type. Tested in Postgresql 8.4.6. Windows However the above set… View Article

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 sessionpostgres=# set timezone_abbreviations to ‘Australia’;change it for databasepostgres=# alter database DATABASENAME set timezone_abbreviations to ‘Australia’;

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 close3) restart postgresql service:    net restart postgresql