29 September 2010

How to import Google Earth POI.KML file into IGO8

POI (from POIplaza)

1 Turn off the write protection of the Dreimgo Memory Card.
2 Connect the memory card or the navigation device to PC,
then create the following path on the memory card: igo8/content/userdata/POI.
3 Download, unzip and copy the the downloaded .kml files to the above map.
4 Restart your navigation device.
5 Run the navigation software and swich to Advanced mode. Choose the Manage POI icon.
6 Choose downloaded POIs (kml file); then choose Edit and set the distance of POI icon visibility.
The default icon is Google Earth’s globe.
7 In the Navigation menu choose Find POI, and choose as Destination.

Note: some POIs might not be reachable on the map, if the map is not detailed enough.

Speedcam iGO8

1 Download as speedcam the iGO8_txt.zip file to a folder on your PC.
2 Unzip the two files, speedcam.txt and POIplaza-iG08 Notes.txt.
3 Copy the speedcam.txt file to the Storage card/igo8/content/speedcam.
4 Restart iGO8, the file will automatically update the database.
5 There will now be three files in the speedcam directory, speedcam.spdb, speedcam.txt and SpeedcamUpdates.spud.
6 Allow the device to detect a GPS signal. When this is done the speedcam locations will be active.
7 Check Settings/Warnings has Speed Camera Warning enabled.

Note: conversion of speedcam files is time consuming especially in case of a large file.
During conversion an 'init warning messages' message is visible.

18 September 2010

pgtray - PostgreSQL Tray Monitor

In working with the PostgreSQL server, there is no Tray Monitor, as in the MySQL database server. I searched the Internet, but such a project in pgFoundry is very outdated and in version 1.0. I thought I'd make this little tool on my own, and here's how it looks ...

You can download it here.

17 September 2010

PostgreSQL - Manual (silent) instalation

PostgreSQL - Manual (silent) instalation
1) Download postgresql-*.*.zip.
Here we’ll use c:\pgsql as the target directory, so
2) Extract the archive to that directory.
Go to that folder and type in command prompt
3) initdb c:\pgsql\data
4) pg_ctl register -N postgres -D c:\pgsql\data
5) net start postgres
net user postgres postgres /add /expires:never
6) createdb database_name
createdb -E unicode --template template0 database_name
7) createuser -d -s user_name (postgres)
8) psql -U user_name -d database_name -f file.backup
and then, if needed
pg_restore --host localhost --port 5432 --username postgres --dbname database_name --verbose file.sql
9) pg_ctl unregister -N postgres

Change database encoding to UTF-8

vacuumdb --full --analyze --username postgres --dbname MYDB
pg_dump MYDB -Ft -v -U postgres -f tmp/MYDB.tar
dropdb MYDB --username postgres
createdb --encoding UNICODE MYDB --username postgres
pg_restore tmp/MYDB.tar | psql --dbname MYDB --username postgres
vacuumdb --full --analyze --username postgres --dbname MYDB