Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 87B911337BB9 for ; Thu, 2 Dec 2010 05:10:40 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 59004-07 for ; Thu, 2 Dec 2010 09:10:32 +0000 (UTC) X-Greylist: delayed 00:05:40.952921 by SQLgrey-1.7.6 Received: from aa002msb.fastweb.it (aa002msb.fastweb.it [85.18.95.81]) by mail.postgresql.org (Postfix) with ESMTP id 6A0F31337BB3 for ; Thu, 2 Dec 2010 05:10:32 -0400 (AST) Received: from mail.cidsoftware.it (89.97.205.103) by aa002msb.fastweb.it (8.5.016.6) id 4CD8A68A023560D4 for pgsql-admin@postgresql.org; Thu, 2 Dec 2010 10:04:49 +0100 Received: (qmail 18997 invoked by uid 501); 2 Dec 2010 09:04:48 -0000 Received: from 127.0.0.1 by mail.cidsoftware.it (envelope-from , uid 92) with qmail-scanner-2.06 (clamdscan: 0.95.2/9496. spamassassin: 3.2.5. Clear:RC:1(127.0.0.1):. Processed in 0.032475 secs); 02 Dec 2010 09:04:48 -0000 Received: from unknown (HELO localhost) (127.0.0.1) by mail.cidsoftware.it with SMTP; 2 Dec 2010 09:04:48 -0000 Received: from 192.168.1.100 ([192.168.1.100]) by mail.cidsoftware.it (Horde MIME library) with HTTP; Thu, 02 Dec 2010 10:04:48 +0100 Message-ID: <20101202100448.gbzcl1dkcgcscok0@mail.cidsoftware.it> Date: Thu, 02 Dec 2010 10:04:48 +0100 From: Luca Santaniello To: pgsql-admin@postgresql.org Subject: restore dump sun solaris to linux MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; DelSp="Yes"; format="flowed" Content-Disposition: inline Content-Transfer-Encoding: quoted-printable User-Agent: Internet Messaging Program (IMP) H3 (4.1.6) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.8 tagged_above=-10 required=5 tests=BAYES_50=0.8, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201012/23 X-Sequence-Number: 36252 Hi, I have problem to restore my dump. I have generated my dump from sun =20 solaris platform and I want start restore on linux platform. My dump =20 contains postgis and pgrouting tables. I create dump using this command: pg_dump my_db > my_dump.dump I restore my dump using this command: createdb my_new_db psql my_new_db < my_dump.dump Restore generate many errors. How Can I solve it? --=20 Luca Santaniello [AVVISO DI RISERVATEZZA] Questo messaggio, i suoi contenuti ed i =20 contenuti dei suoi allegati sono riservati e confidenziali. Se non =20 siete i destinatari del messaggio o lo avete ricevuto per errore, Vi =20 preghiamo di darcene comunicazione e di rimuovere il messaggio stesso =20 e gli allegati dal Vostro sistema; i contenuti di questo messaggio e =20 degli allegati non devono essere copiati o diffusi in alcun modo. Sono =20 riservati tutti i diritti relativi al messaggio ed ai documenti =20 allegati. [CONFIDENTIALITY NOTICE] This message is confidential and may be =20 legally privileged or otherwise protected from disclosure. If you are =20 not the intended recipient, please telephone or email the sender and =20 delete this message and any attachment from your system; you must not =20 copy or disclose the contents of this message or any attachment to any =20 other person. Copyright in documents created by or on behalf of this =20 firm remains vested in the firm, and we assert our moral rights. Prima di stampare, pensa all'ambiente ** Think about the environment =20 before printing