Re: Moving the database from winxp to linux

> [mailto:pgsql-general-owner(at)postgresql(dot)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