March 12, 2012

Enable remote access for PostgreSQL

Remote access to a Postgtres Database In the last days i have worked a lot with PostgreSQL.

March 7, 2012

rsync - the better scp

Regard this Post, i make this post. First: scp is great.

February 24, 2012

Howto fix libgeos_c.so not found

I'm working with Python Django and PostGIS. When i try to add the Geo support to the Project, i hit this error message: OSError: /usr/local/lib/libgeos_c.

January 3, 2012

Debian PostgreSQL 8.4 can't create Database with UTF-8 Encoding

The Problem I encounter a problem with fresh Debian VM. I create this VM for our developer, during the installation script following problem appears and stop the script: new encoding (UTF8) is incompatible with the encoding of the template database (SQL_ASCII) HINT: Use the same encoding as in the template database, or use template0 as template.