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
_______________________________________________