Re: Moving the database from winxp to linux - Mailing list pgsql-general

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/