running initdb on running database

From: "Ben K(dot)" <bkim(at)coe(dot)tamu(dot)edu>
To: pgsql-admin(at)postgresql(dot)org
Subject: running initdb on running database
Date: 2006-11-13 21:10:14
Message-ID: Pine.GSO.4.64.0611131502290.1474@coe.tamu.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message TomDB 2006-11-13 21:21:40 replication?
Previous Message Jim C. Nasby 2006-11-13 16:53:19 Re: Manual sys catalog constraint setup to avoid downtime?