From: Luca Santaniello <lsantaniello@cidsoftware.it>
To: pgsql-admin@postgresql.org
Subject: restore dump sun solaris to linux
Date: Thu, 02 Dec 2010 10:04:48 +0100
Message-ID: <20101202100448.gbzcl1dkcgcscok0@mail.cidsoftware.it> (raw)
Hi,
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.
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?
--
Luca Santaniello
[AVVISO DI RISERVATEZZA] Questo messaggio, i suoi contenuti ed i
contenuti dei suoi allegati sono riservati e confidenziali. Se non
siete i destinatari del messaggio o lo avete ricevuto per errore, Vi
preghiamo di darcene comunicazione e di rimuovere il messaggio stesso
e gli allegati dal Vostro sistema; i contenuti di questo messaggio e
degli allegati non devono essere copiati o diffusi in alcun modo. Sono
riservati tutti i diritti relativi al messaggio ed ai documenti
allegati.
[CONFIDENTIALITY NOTICE] This message is confidential and may be
legally privileged or otherwise protected from disclosure. If you are
not the intended recipient, please telephone or email the sender and
delete this message and any attachment from your system; you must not
copy or disclose the contents of this message or any attachment to any
other person. Copyright in documents created by or on behalf of this
firm remains vested in the firm, and we assert our moral rights.
Prima di stampare, pensa all'ambiente ** Think about the environment
before printing
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: lsantaniello@cidsoftware.it
Subject: Re: restore dump sun solaris to linux
In-Reply-To: <20101202100448.gbzcl1dkcgcscok0@mail.cidsoftware.it>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox