Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group