Re: Moving the database from winxp to linux

> [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Chris
> 
> Tomas Lanczos wrote:
> > I am planning within few week to migrate the existing 8.1.4 
> postgresql 
> > database from winxp to 8.2 postgresql installed on linux 
> (ubuntu). Is 
> > there any good tutorial for the task like this, event. do have 
> > somebody summarized some tricks and tips, at least?
> > 
> > many thanks in advance and regards
> 
> If it's just one database, then use pg_dump
> (http://www.postgresql.org/docs/current/static/app-pgdump.html
> ) to create a database dump, then you can pipe it into psql:
> 
> psql < /path/to/dumpfile.
> 
> or use pg_restore
> (http://www.postgresql.org/docs/current/static/app-pgrestore.html).
> 
> If you want to move the whole system, use pg_dumpall to dump 
> all databases.
> 
> http://www.postgresql.org/docs/current/static/app-pg-dumpall.html
> 
> --
> Postgresql & php tutorials
> http://www.designmagick.com/

Thanks. No complications due the move to the higher version (8.2)?

Tomas