Thread: running initdb on running database
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? Thanks. Ben K. Developer http://benix.tamu.edu
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@nasby.net EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
On Tue, 14 Nov 2006, Jim C. Nasby wrote: > 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@nasby.net > EnterpriseDB http://enterprisedb.com 512.569.9461 (cell) Thanks. I guess then the next upgrade may be the best opportunity to change the encoding. Regards, Ben K. Developer http://benix.tamu.edu