> [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] 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
