You where right. It's ok now, it was the old one "If you want it to be
done correctly do it yourself".
Tks a lot.
Jose Roberto M. Garcia, MSc
Analista de Sistemas - Grupo Banco de Dados
Fone: (12) 3186-8405
A luta contra o aquecimento global depende de cada um de nós, faça sua parte, economize recursos naturais.
Tom Lane wrote:
> =?ISO-8859-1?Q?Jos=E9_Roberto_Motta_Garcia?= <garcia(at)cptec(dot)inpe(dot)br> writes:
>> We're having problems restoring the characters correctly here. We have a
>> 8.1 PG on Suse created with LATIN1 and pt_BR. As a latin language we use
>> several special chars like á, ã, ç, í, etc.
>> We made a dump -a and after restoring it to an also 8.1 PG on Suse
>> created with LATIN1 and pt_BR we noticed that a lot of these special
>> chars weren't restored correctly. We couldn't notice any rule for that,
> It seems highly unlikely that you actually had the same encoding in both
> cases, since if that were the case no conversion would have occurred.
> Please double-check the two database encodings. Also, what encoding is
> called out in the first few lines of the dump file?
> regards, tom lane
In response to
pgsql-admin by date
|Next:||From: Jose Calderon||Date: 2007-11-26 20:16:55|
|Subject: database cluster missing|
|Previous:||From: Medi Montaseri||Date: 2007-11-26 18:52:52|
|Subject: Re: Migrating from 32 to 64 bit|