Thread: Export/Import existing database from Unix to Windows 8.0-beta2-dev3

Export/Import existing database from Unix to Windows 8.0-beta2-dev3

From
Sudhakar Kurumella
Date:
Hi,
 
I have recently downloaded, PostgreSql 8.0-beta2-dev3 windows version. I am a newbie to postgresql, i have one question, How can i import or export the existing postgresql database running under unix flavour to windows based postgresql (8.0-beta2-dev3). Is there any facility under the new windows version ?
 
It is highly appreciated, if any one could show some light on this.
 
thanks,
kuru


Do you Yahoo!?
vote.yahoo.com - Register online to vote today!

Re: Export/Import existing database from Unix to Windows

From
Andrew Dunstan
Date:

Sudhakar Kurumella wrote:

> Hi,
>  
> I have recently downloaded, PostgreSql 8.0-beta2-dev3 windows version. 
> I am a newbie to postgresql, i have one question, How can i import or 
> export the existing postgresql database running under unix flavour to 
> windows based postgresql (8.0-beta2-dev3). Is there any facility under 
> the new windows version ?
>  
> It is highly appreciated, if any one could show some light on this.
>  
>
Exporting on Unix using pg_dump and importing on Windows using psql or 
pg_restore as appropriate should work just fine.

cheers

andrew