Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id DF4E3632E12 for ; Tue, 9 Feb 2010 05:32:25 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 14813-08 for ; Tue, 9 Feb 2010 09:32:10 +0000 (UTC) X-Greylist: delayed 00:34:13.209177 by SQLgrey-1.7.6 Received: from mo-p00-ob.rzone.de (mo-p00-ob.rzone.de [81.169.146.162]) by mail.postgresql.org (Postfix) with ESMTP id 08DC3632FFF for ; Tue, 9 Feb 2010 05:32:14 -0400 (AST) DKIM-Signature: v=1; a=rsa-sha1; c=relaxed/relaxed; t=1265707931; l=312; s=domk; d=4c-ag.de; h=Content-Transfer-Encoding:Content-Type:Mime-Version:Subject:To:From: Date:X-RZG-CLASS-ID:X-RZG-AUTH; bh=8gCA3D+udJTWj5xGrQhgGQYPeOA=; b=D9WFw2YLobPStLDO10tSD4GliOdv3Y/PqGMvsJY2eCcA2jiKC5Vj1nO1AJmNcNAvOAm 79IatEX20Hgo+K9BySVsmF4o4jLuXhj74kPhpbB/9q6FJ2omGNC+NnAawSy83Ug+h+kho f67n2TZX0Qla6WDb3+ZwDgoGQ7NfvX6S7Ac= X-RZG-AUTH: :ICIXYUWhdf07X6m/b2XtAlrlJW5vzQNIp+WDp5lRVhY+t6aUn/IJXTddHpcPM4uN X-RZG-CLASS-ID: mo00 Received: from localhost (p54AAAE02.dip.t-dialin.net [84.170.174.2]) by post.strato.de (fruni mo64) (RZmta 22.6) with ESMTP id t0435fm198KtCe for ; Tue, 9 Feb 2010 09:46:56 +0100 (MET) Date: Tue, 9 Feb 2010 09:48:31 +0100 From: Lutz Steinborn To: pgsql-admin@postgresql.org Subject: migration problem 8.1.17 --> 8.4.2 Message-Id: <20100209094831.22eece8c.l.steinborn@4c-ag.de> Organization: 4c AG X-Mailer: Sylpheed 2.6.0 (GTK+ 2.16.6; x86_64-pc-linux-gnu) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.11 tagged_above=-10 required=5 tests=BAYES_05=-1.11 X-Spam-Level: X-Archive-Number: 201002/66 X-Sequence-Number: 33669 Hi, then importing an pg_dump result from a 8.1.17 to a 8.4.2 some varchar fields are not imported and left blank. I've checked the dump file if the fields are correct dumped and they are. So it looks like the import is not working as expected. Any idea what the problem is ? Kindly regards Lutz