Forum OpenACS Q&A: rebuilding postgres for multibyte support

Collapse
1: rebuilding postgres for multibyte support
Posted by Janine Ohmer on 10/09/01 07:08 PM
Has anyone rebuilt Postgres to turn on multi-byte encoding support *after* they already have databases created?  If so, did the old databases still work?  And if not, what did you have to do to bring them back online?  I have to do this on a production system and I'm trying to get a feel for how nasty it's going to be before I start.

Thanks in advance,

Collapse
2: Response to rebuilding postgres for multibyte support (response to 1)
Posted by Tilmann Singer on 10/10/01 03:11 PM
Re-running configure, make, make install worked for me. The one existing database in SQL_ASCII encoding still seems to work (although there was no chance to do real testing because there's only one empty table in it).
Collapse
3: Response to rebuilding postgres for multibyte support (response to 1)
Posted by Janine Ohmer on 10/10/01 03:35 PM
Thanks, Tilman, that gives me some hope at least.  Guess I'll have to try it (after making dumps of everything!) and see what happens.