From: | tony <tony(at)tgds(dot)net> |
---|---|
To: | Hannes Dorbath <light(at)theendofthetunnel(dot)de> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: upgrading a three year old server |
Date: | 2005-12-19 10:29:18 |
Message-ID: | 1134988158.2847.220.camel@hush.localdomain |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Le lundi 19 décembre 2005 à 09:20 +0100, Hannes Dorbath a écrit :
> On 18.12.2005 18:49, tony wrote:
> > createdb xxx -E LATIN1 <- old version had this encoding (intranet server
> > dates from 2000 upgrade to 7.2 done in 2002)
> > psql -d xxxx -U postgres -f xxxx.out.1 <- this being my daily dump
>
> Hm, there have been no error messages from psql during the import?
OK I have run a vacuum on the database and that fixed the invisible
tuples.
> > The data is there (read using nedit on the dump file) but not being read by either of the interfaces I usually use for basic data control.
>
> You mean the data is in the dump file, but the restore failed?
Restore succeeded but there were error messages about encoding (see
below).
> > And my JSP webapp is choking on the French accents.
>
> Are you sure about the LATIN1 encoding of your old dump? :)
Two apps out of three work OK now that I have vacuumed. The third one
has encoding problems.
Can I change the encoding to UTF-8 easily?
Thanks
Tony
--
Tony Grant
www.tgds.net - vente d'ordinateurs mini-itx en ligne
www.tgds.net/epiaix1.html - A fedora Core 4 based live CD for VIA Epia-M
From | Date | Subject | |
---|---|---|---|
Next Message | Dick Visser | 2005-12-19 11:51:45 | Re: upgrading a three year old server |
Previous Message | Hannes Dorbath | 2005-12-19 08:20:55 | Re: upgrading a three year old server |