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/
