Re: Linux PostgreSQL to Windows PostgreSQL

Hi  ,


>
> We have to move from Linux based PostgreSQL to Windows based PostgreSQL.
> Highly appreciated for Any ideas of smooth export/import


On Linux

1. Backup everything make a file system bacup of the PostgreSQL
database (plz make sutre to shut down PostgreSQL before doing this)
2. Backup data.
3. Backup Schema

Windows Install PostgreSQL

1. Restore schema in new system from the backup
2. Restore database from backup
3. Run PostgreSQL.


Note: Your both post must have gone to Novice list

--
With Best Regards,
Vishal Kashyap.
Lead Software Developer,
http://saihertz.com,
http://vishalkashyap.tk