On Mon, Nov 13, 2006 at 03:10:14PM -0600, Ben K. wrote: > > Admins, > > I'm reading this post: > > http://archives.postgresql.org/pgsql-novice/2005-04/msg00221.php > > Is it possible and safe to run initdb again on a running database to > change encoding from SQL_ASCII to UTF8? > > Will it affect new databases only or existing databases as well? Pretty much guaranteed to be unsafe. It's also not possible unless you hack initdb. -- Jim Nasby jim@xxxxxxxxx EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)