Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 0ED001337BC5 for ; Fri, 3 Dec 2010 02:38:38 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 44039-02 for ; Fri, 3 Dec 2010 06:38:30 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from delta01.pnet.xcon.it (delta01.pnet.xcon.it [62.48.53.16]) by mail.postgresql.org (Postfix) with ESMTP id 3D6461337BC4 for ; Fri, 3 Dec 2010 02:38:29 -0400 (AST) Received: from localhost (localhost [127.0.0.1]) by delta01.pnet.xcon.it (Postfix) with ESMTP id 7EC60182BD31; Fri, 3 Dec 2010 07:38:28 +0100 (CET) X-Virus-Scanned: Debian amavisd-new at delta01.pnet.xcon.it Received: from delta01.pnet.xcon.it ([127.0.0.1]) by localhost (delta01.pnet.xcon.it [127.0.0.1]) (amavisd-new, port 10024) with LMTP id iiO+WibCxwkG; Fri, 3 Dec 2010 07:38:25 +0100 (CET) Received: from macbook-di-gabriele-bartolini.local (CPE-124-189-160-150.rsqv1.lon.bigpond.net.au [124.189.160.150]) (Authenticated sender: gabriele.bartolini@devise.it) by delta01.pnet.xcon.it (Postfix) with ESMTPSA id 6753B180D992; Fri, 3 Dec 2010 07:38:23 +0100 (CET) Message-ID: <4CF8905C.9030608@2ndQuadrant.it> Date: Fri, 03 Dec 2010 17:38:20 +1100 From: Gabriele Bartolini User-Agent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.5; it; rv:1.9.2.12) Gecko/20101027 Thunderbird/3.1.6 MIME-Version: 1.0 To: Luca Santaniello CC: pgsql-admin@postgresql.org Subject: Re: restore dump sun solaris to linux References: <20101202100448.gbzcl1dkcgcscok0@mail.cidsoftware.it> In-Reply-To: <20101202100448.gbzcl1dkcgcscok0@mail.cidsoftware.it> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.6 tagged_above=-10 required=5 tests=BAYES_00=-1.9, RCVD_IN_DNSWL_LOW=-0.7 X-Spam-Level: X-Archive-Number: 201012/27 X-Sequence-Number: 36256 Hi, Il 02/12/10 20:04, Luca Santaniello ha scritto: > I have problem to restore my dump. I have generated my dump from sun > solaris platform and I want start restore on linux platform. My dump > contains postgis and pgrouting tables. Are you using the same versions of PostgreSQL and PostGIS or did you upgrade any of those? > How Can I solve it? I suspect you are from Italy. So it may be a good idea to try and come to PGDay Italia next week in Rome (www.pgday.it) to start with. :) Cheers, Gabriele -- Gabriele Bartolini - 2ndQuadrant Italia PostgreSQL Training, Services and Support gabriele.bartolini@2ndQuadrant.it | www.2ndQuadrant.it