X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 9B3799DC80C for ; Mon, 19 Dec 2005 04:21:28 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 87635-01 for ; Mon, 19 Dec 2005 04:21:29 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by postgresql.org (Postfix) with ESMTP id 97F939DC826 for ; Mon, 19 Dec 2005 04:21:26 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.13.1/8.13.1) with ESMTP id jBJ8LOIk063613 for ; Mon, 19 Dec 2005 08:21:24 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.13.1/8.13.1/Submit) id jBJ8JQxP063082 for pgsql-admin@postgresql.org; Mon, 19 Dec 2005 08:19:26 GMT (envelope-from news) From: Hannes Dorbath X-Newsgroups: pgsql.admin Subject: Re: upgrading a three year old server Date: Mon, 19 Dec 2005 09:20:55 +0100 Organization: Hub.Org Networking Services Lines: 19 Message-ID: <43A66D67.3090701@theendofthetunnel.de> References: <1134928154.2847.203.camel@hush.localdomain> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@news.hub.org To: tony User-Agent: Thunderbird 1.4 (Windows/20050908) In-Reply-To: <1134928154.2847.203.camel@hush.localdomain> To: pgsql-admin@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=-1.44 required=5 tests=[ALL_TRUSTED=-1.44] X-Spam-Score: -1.44 X-Spam-Level: X-Archive-Number: 200512/196 X-Sequence-Number: 19916 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? > 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? > And my JSP webapp is choking on the French accents. Are you sure about the LATIN1 encoding of your old dump? :) -- Regards, Hannes Dorbath