Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 728079FB295 for ; Mon, 13 Nov 2006 17:18:51 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 88757-10 for ; Mon, 13 Nov 2006 21:18:47 +0000 (UTC) X-Greylist: delayed 00:06:11.780457 by SQLgrey- Received: from coe.tamu.edu (edsun.coe.tamu.edu [165.91.232.6]) by postgresql.org (Postfix) with ESMTP id 1AAA49FB28E for ; Mon, 13 Nov 2006 17:18:35 -0400 (AST) Received: (from root@localhost) by coe.tamu.edu (8.11.7p2+Sun/8.12.11) id kADLAZZ02412 for pgsql-admin@postgresql.org; Mon, 13 Nov 2006 15:10:35 -0600 (CST) Received: from coe.tamu.edu (coe.tamu.edu [165.91.232.6]) by coe.tamu.edu (8.11.7p2+Sun/8.12.11) with ESMTP id kADLAEF02379 for ; Mon, 13 Nov 2006 15:10:14 -0600 (CST) Date: Mon, 13 Nov 2006 15:10:14 -0600 (CST) From: "Ben K." To: pgsql-admin@postgresql.org Subject: running initdb on running database Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Virus-Scanned: by AMaViS 0.3.12 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/125 X-Sequence-Number: 23652 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