Re: data transfer/migrate from win to linux - Mailing list pgsql-admin

From Peter Koczan
Subject Re: data transfer/migrate from win to linux
Date
Msg-id 4544e0330801091043q2cf62c79qaec163e4e5f1698c@mail.gmail.com
Whole thread Raw
In response to data transfer/migrate from win to linux  ("Antonio Muñoz" <amrrfr@gmail.com>)
List 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

pgsql-admin by date:

Previous
From: Richard Ray
Date:
Subject: pg_dumpall --exclude
Next
From: Bruce Momjian
Date:
Subject: Re: pg_dumpall --exclude