Обсуждение: restore dump sun solaris to linux

Поиск
Список
Период
Сортировка

restore dump sun solaris to linux

От
Luca Santaniello
Дата:
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



Re: restore dump sun solaris to linux

От
Gabriele Bartolini
Дата:
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