pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feeddata 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>
2008-01-09 18:43 ` Re: data transfer/migrate from win to linux Peter Koczan <pjkoczan@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 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>
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