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

2 minute read 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.
psql:./__cre_database.sql:76: \connect: FATAL:  database "db" does not exist
psql: FATAL:  database "db" does not exist
All database in postgres was created with SQL_ASCII The Solution You have to take care that you have a right UTF-8 setting in your bash environment. When you no LC option set, the default POSFIX will be used. 
postgres=# \l
List of databases
Name    |  Owner   | Encoding  | Collation | Ctype |   Access privileges  
-----------+----------+-----------+-----------+-------+-----------------------
postgres  | postgres | SQL_ASCII | C         | C     | : postgres=CTc/postgres
template0 | postgres | SQL_ASCII | C         | C     | =c/postgres                                                      
template1 | postgres | SQL_ASCII | C         | C     | =c/postgres
                                                       : postgres=CTc/postgres(3 rows)
A check on the locale show's me that there is no UTF-8 support. The Solution is very easy. Enable UTF-8 on the Bash:
export LANG="en_US.UTF-8"
Note: You should add this to your /etc/profile! After  this, re-install postgres via apt-get:
apt-get remove --purge postgresql-8.4 && apt-get install apt-get install postgresql-8.4
Now your Postgres Databases are in UTF-8.

Skypetab-ng on Gentoo

1 minute read

A lots of people dislike the Skype Software but have to use it. Many of my coworkers and friends using Skype. However, the Skype GUI is quite free "feature" and does provide it difficulties to deal with it. Thanks to skypetab-ng it get at least some "usability".

I tried to run this by Hand, but for some reason the Compile wasn't able to create a 32-bit library.I just found a nice Overlay for  Skypetab-ng, thanks to the Gentoo Forum!
To work with the Overlay, just add the rion overlay to your system:
layman -a rion
All what's left to do is a eix-sync and just install with emerge skypetab-ng
Sources:

Gentoo Forums Post about Skypetabs

Overlay Webpage for Skypetabs-ng
skypetabs-ng

My Blog

1 minute read

Welcome to my blog! I was planning to create a blog for a long time now. Here are some thoughts about this blog: The main purpose is to document.

I will try to post as much as possible. The goal for this blog: It’s main purpose is documentation. Documentation about my work and problem of the everyday struggle.

About me: My Name is Akendo and I’m the system-administrator of a small company that’s located in Berlin. Since August I’m working there full time. The work is not limited to administration only, but also implies work as a Python developer.

I take care about the Mail and Web Servers. All of this systems are running in a virtual environments based on Xen. But also lots of small gems of the IT world like Git, Jabber, Asterisk, Django and Postgresql. Also some bad one, like Orace 10g or Windows Server 2003. But overall it’s a dream job.

€dit:2017 - The grammar of the original post were bad. I re-wrote this post with prober language.

€dit:2018 - Revise for better understandability