Export/Import existing database from Unix to Windows 8.0-beta2-dev3
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!
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