Re: Migrating database from postgresql 7.4.6 to postgresql

From: Achilleus Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>
To: "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Migrating database from postgresql 7.4.6 to postgresql
Date: 2005-11-09 08:35:17
Message-ID: Pine.LNX.4.44.0511091034130.5689-100000@matrix.gatewaynet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

O A. Kretschmer έγραψε στις Nov 9, 2005 :

> am 08.11.2005, um 23:18:35 -0800 mailte Louise Catherine folgendes:
> > Hi,
> > I would like to migrating my database from postgresql
> > 7.4.6 to postgresql 8.0.3.
>
> Why not 8.1.0?
>
>
> > Are there any problem during migrating database? a
> > casting problem or sintax problem, or other problem?
>
> I dont know about problems. Install the new database (on the same
> machine, use a different port), and use the pg_dump from the newer
> version to dump the old db in the new db.

Or better consult HISTORY.
It is in the root of the tarball.

>
>
> HTH, Andreas
>

--
-Achilleus

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message zenith Das 2005-11-09 13:55:18 migratation of database from oracle9i to postgreSQL8.0.3
Previous Message A. Kretschmer 2005-11-09 07:55:00 Re: Migrating database from postgresql 7.4.6 to postgresql 8.0.3