Re: SOLVED: [Gnumed-devel] Problems with bootstrap and recovery

[Karsten Hilbert]

On Fri, Oct 30, 2009 at 01:27:21PM +0100, Jerzy Luszawski wrote:
> Subject: Re: SOLVED: [Gnumed-devel] Problems with bootstrap and recovery
> User-Agent: KMail/1.9.10
> 
> > > Restore databases to the new cluster or bootstrap gnumed database.
> > > 
> > > Warning: I'm not sure, but if you have other databases, changing the 
> > > locale may affect their restoration,
> > 
> > It will but the dump file contains a directive
> > 
> >     set client_encoding to ...
> > 
> > for each of them so when the cluster is utf-8 eventually
> > that shouldn't pose a problem.
> 
> The important thing is, that we destroy a cluster, so if a
> user has another databases in it, they will be erased.
> Restoring them under different locale will require special
> attention. So I just put a warning.

That's correct. I was just pointing out that since pg_dump
puts a "set client_encoding to ..." into the backups
restoring them into a utf8 cluster should work just fine -
for whatever "should" means in IT.

Karsten
-- 
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346