Re: transfer database from Linux to Windows - Mailing list pgsql-novice

From Oleg
Subject Re: transfer database from Linux to Windows
Date
Msg-id 43A836DC.1030906@iwk.uka.de
Whole thread Raw
In response to transfer database from Linux to Windows  (Oleg <evdakov@iwk.uka.de>)
Responses Re: transfer database from Linux to Windows  (Jaime Casanova <systemguards@gmail.com>)
List 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



pgsql-novice by date:

Previous
From: "Danjel Jungersen"
Date:
Subject: Re: Login problem
Next
From: Tom Lane
Date:
Subject: Re: Login problem