From: Peter Koczan <pjkoczan@gmail.com>
To: Antonio Muñoz <amrrfr@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: data transfer/migrate from win to linux
Date: Wed, 9 Jan 2008 12:43:24 -0600
Message-ID: <4544e0330801091043q2cf62c79qaec163e4e5f1698c@mail.gmail.com> (raw)
In-Reply-To: <9da429290801090201v5527d672tf1ac63c8fd04b324@mail.gmail.com>
References: <9da429290801090201v5527d672tf1ac63c8fd04b324@mail.gmail.com>
> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: pjkoczan@gmail.com, amrrfr@gmail.com
Subject: Re: data transfer/migrate from win to linux
In-Reply-To: <4544e0330801091043q2cf62c79qaec163e4e5f1698c@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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