Postgresql

Jump to bottom Edit New page

kosfar edited this page Mar 10, 2012 · 3 revisions

Postgresql server setting up details

UTF8 encoding support was added to the VPS

uncomment en_US.UTF-8 in /etc/locale.gen

~$ locale-gen en_US.UTF-8

~$ update-locale LANG=en_US.UTF-8

In order to create a database with utf8 locale (and utf8 encoding):

postgres=# CREATE DATABASE testdb with encoding 'utf8' lc_collate 'en_US.UTF-8' lc_ctype 'en_US.UTF-8' template template0;