restore dump sun solaris to linux

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

restore dump sun solaris to linux

От:
Luca Santaniello <lsantaniello@cidsoftware.it>
Дата:
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 <gabriele.bartolini@2ndQuadrant.it>
Дата:
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

FAQ