pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
data transfer/migrate from win to linux
2+ messages / 2 participants
[nested] [flat]

* data transfer/migrate from win to linux
@ 2008-01-09 10:01  Antonio Muñoz <amrrfr@gmail.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Antonio Muñoz @ 2008-01-09 10:01 UTC (permalink / raw)
  To: pgsql-admin

Hello.

After looking for a way to transfer PostgreSQL/PostGIS data from windowsXP
to linux (Ubuntu 7.10), I did not find it.
Please, does anyone know an easy way or free tool for it.

Thanks in advance
Best regards

Antonio

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

* Re: data transfer/migrate from win to linux
@ 2008-01-09 18:43  Peter Koczan <pjkoczan@gmail.com>
  parent: Antonio Muñoz <amrrfr@gmail.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Peter Koczan @ 2008-01-09 18:43 UTC (permalink / raw)
  To: Antonio Muñoz <amrrfr@gmail.com>; +Cc: pgsql-admin

>  After looking for a way to transfer PostgreSQL/PostGIS data from windowsXP
> to linux (Ubuntu 7.10), I did not find it.
>  Please, does anyone know an easy way or free tool for it.

Are pg_dump/pg_restore somehow insufficient for your needs?
(http://www.postgresql.org/docs/current/interactive/backup.html)

You'll have to dump your database to a file, transfer said file to
your linux server, and then restore the database (I don't think you
can directly pipe the output, but I could be wrong). You'll also have
to make sure that PostGIS is installed on the linux side, but this
should work modulo any major version discrepancies.

If you run into an error while doing this, let us know.

Peter



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


end of thread, other threads:[~2008-01-09 18:43 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-01-09 10:01 data transfer/migrate from win to linux Antonio Muñoz <amrrfr@gmail.com>
2008-01-09 18:43 ` Peter Koczan <pjkoczan@gmail.com>

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