pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
restore dump sun solaris to linux
2+ messages / 2 participants
[nested] [flat]

* restore dump sun solaris to linux
@ 2010-12-02 09:04  Luca Santaniello <lsantaniello@cidsoftware.it>
  0 siblings, 1 reply; 2+ messages in thread

From: Luca Santaniello @ 2010-12-02 09:04 UTC (permalink / raw)
  To: pgsql-admin

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





^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: restore dump sun solaris to linux
@ 2010-12-03 06:38  Gabriele Bartolini <gabriele.bartolini@2ndQuadrant.it>
  parent: Luca Santaniello <lsantaniello@cidsoftware.it>
  0 siblings, 0 replies; 2+ messages in thread

From: Gabriele Bartolini @ 2010-12-03 06:38 UTC (permalink / raw)
  To: Luca Santaniello <lsantaniello@cidsoftware.it>; +Cc: pgsql-admin

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




^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2010-12-03 06:38 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-12-02 09:04 restore dump sun solaris to linux Luca Santaniello <lsantaniello@cidsoftware.it>
2010-12-03 06:38 ` Gabriele Bartolini <gabriele.bartolini@2ndQuadrant.it>

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