Skip site navigation (1) Skip section navigation (2)

Re: transfer database from Linux to Windows

From: Jaime Casanova <systemguards(at)gmail(dot)com>
To: Oleg <evdakov(at)iwk(dot)uka(dot)de>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: transfer database from Linux to Windows
Date: 2005-12-20 17:17:40
Message-ID: c2d9e70e0512200917l71a0ca90s4b60f300fdf0c099@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
On 12/20/05, Oleg <evdakov(at)iwk(dot)uka(dot)de> wrote:
> 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
>

Can you us the exact errors, please?

--
regards,
Jaime Casanova
(DBA: DataBase Aniquilator ;)

In response to

Responses

pgsql-novice by date

Next:From: Jaime CasanovaDate: 2005-12-20 17:19:01
Subject: Re: transfer database from Linux to Windows
Previous:From: Tom LaneDate: 2005-12-20 17:05:01
Subject: Re: Login problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group