Re: data transfer/migrate from win to linux

From: "Harald Armin Massa" <haraldarminmassa(at)gmail(dot)com>
To: Antonio Muñoz <amrrfr(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: data transfer/migrate from win to linux
Date: 2008-01-09 10:28:08
Message-ID: 7be3f35d0801090228r1a3bf47esebd48eecec9a67b9@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Antonio,

> 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.

I do this via

pg_dump on the sender

and

pg_restore or psql -f

on the receiver site. Both are included with PostgreSQL. To avoid
challenges, make sure that the PostgreSQL versions on both systems
match.

best wishes,

Harald

--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Spielberger Straße 49
70435 Stuttgart
0173/9409607
fx 01212-5-13695179
-
EuroPython 2008 will take place in Vilnius, Lithuania - Stay tuned!

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ashish Karalkar 2008-01-09 10:59:53 Insert waiting for update?
Previous Message Antonio Muñoz 2008-01-09 10:00:19 data transfer/migrate from win to linux