Re: running initdb on running database

From: "Jim C(dot) Nasby" <jim(at)nasby(dot)net>
To: "Ben K(dot)" <bkim(at)coe(dot)tamu(dot)edu>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: running initdb on running database
Date: 2006-11-14 17:17:15
Message-ID: 20061114171715.GX90133@nasby.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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(at)nasby(dot)net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Jim C. Nasby 2006-11-14 17:18:35 Re: replication?
Previous Message Andy Shellam (Mailing Lists) 2006-11-14 16:25:35 Re: Finding out free space?