• English version
  • Version française
  • Versión española

Forum activity

  • Woops!

Go to forum

Latest projects

  • Woops!

Project's index

Getting help





Panel access

SubscribePassword recover


PostgreSQL upgraded from 8.1 to 8.3

Posted on Friday 17 October 2008, at 22:46 UTC


Due to a user request to use tsearch2, we upgraded PostgreSQL from 8.1 to 8.3 without any other consideration ;) It should have taken a few minutes but of course it would have been too easy, so we fought against bugs and finally spent several hours on it.

There are many changes between these two versions, please read the PostgreSQL release notes ;)

Beside other things, the charset used internally is now based on the system locale, we had some legacy databases from PostreSQL 7.x without any charset set and legacy databases from 8.1 with wrong charset information (database set as LATIN1 with UTF8 characters inside), we converted roughly everything to UTF8. There might be charset glitch, please fix your databases ;-)

If anything else than charset issue is not working as it should, please contact us.


RSS Feed