Postgres Pro
Downloads
Home   >   mailing lists

Re: running initdb on running database - Mailing list pgsql-admin

From Jim C. Nasby
Subject Re: running initdb on running database
Date
Msg-id 20061114171715.GX90133@nasby.net
Whole thread Raw
In response to running initdb on running database  ("Ben K." <bkim@coe.tamu.edu>)
Responses Re: running initdb on running database  ("Ben K." <bkim@coe.tamu.edu>)
List pgsql-admin
Tree view 
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)

pgsql-admin by date:

Previous
From: "Andy Shellam (Mailing Lists)"
Date:
Subject: Re: Finding out free space?
Next
From: "Jim C. Nasby"
Date:
Subject: Re: replication?