Re: Load DB - Conversion from 8.1.4 to 8.2.4

From: Tommy Gildseth <tommy(dot)gildseth(at)usit(dot)uio(dot)no>
To: "Campbell, Lance" <lance(at)uiuc(dot)edu>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Load DB - Conversion from 8.1.4 to 8.2.4
Date: 2007-06-24 20:06:58
Message-ID: 467ECEE2.9070701@usit.uio.no
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Campbell, Lance wrote:
>
> I will be converting from PostgreSQL 8.1.4 to 8.2.4. Is it OK to do
> the following command in order to load the new database after install?
>
> pg_dump -h /host1/ –p 1234 /dbname/ | psql -h /host1 –p 56789/ /dbname///
>
> Remember that port 1234 is PostgreSQL 8.1.4 and port 5678 is
> PostgreSQL 8.2.4.
>

Should be fine, as long as you ensure that the pg_dump you use, is the
one from your 8.2.4 installation, and not the 8.1.4 version.

--
Tommy Gildseth
DBA, Gruppe for databasedrift
Universitetet i Oslo, USIT
m: +47 45 86 38 50
t: +47 22 85 29 39

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Joe Barwell 2007-06-25 00:53:56 Re: initdb problem
Previous Message Campbell, Lance 2007-06-24 18:55:54 Load DB - Conversion from 8.1.4 to 8.2.4