pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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



view thread (2+ messages)

Message-ID: <4544e0330801091043q2cf62c79qaec163e4e5f1698c@mail.gmail.com>
Permalink:  ../4544e0330801091043q2cf62c79qaec163e4e5f1698c@mail.gmail.com/
Also on:    postgresql.org/message-id/4544e0330801091043q2cf62c79qaec163e4e5f1698c@mail.gmail.com

 · 

reply

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