Re: transfer database from Linux to Windows

From: Oleg <evdakov(at)iwk(dot)uka(dot)de>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: transfer database from Linux to Windows
Date: 2005-12-20 16:52:44
Message-ID: 43A836DC.1030906@iwk.uka.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Tom, Jaime
Thank you very much for your help.
It works like this:
1. Under Linux: pg_dump fgm_gis_2 > fgm_gis_2_dump
2. Under Windows:
a) Create database
b) check whether plpgsql is enabled. if not then: createlang plpgsql fgm_gis_02
c) psql -f (lw)postgis.sql -d fgm_gis_02
d) psql -f fgm_gis_2_dump -d fgm_gis_02 -U postgres

I am getting lots of Errors like
Duplicating primary key is no allowed
etc.
Can I ignore them?
Best regards
Oleg

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Danjel Jungersen 2005-12-20 16:54:51 Re: Login problem
Previous Message Jaime Casanova 2005-12-20 16:20:49 Re: transfer database from Linux to Windows