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

Load DB - Conversion from 8.1.4 to 8.2.4

From: "Campbell, Lance" <lance(at)uiuc(dot)edu>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Load DB - Conversion from 8.1.4 to 8.2.4
Date: 2007-06-24 18:55:54
Message-ID: A3AC4FA47DC0B1458C3E5396E685E63302395E82@SAB-DC1.sab.uiuc.edu (view raw or flat)
Thread:
Lists: pgsql-admin
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.

 

Thanks,

 

Lance Campbell

Project Manager/Software Architect

Web Services at Public Affairs

University of Illinois

217.333.0382

http://webservices.uiuc.edu

 

Responses

pgsql-admin by date

Next:From: Tommy GildsethDate: 2007-06-24 20:06:58
Subject: Re: Load DB - Conversion from 8.1.4 to 8.2.4
Previous:From: Tom LaneDate: 2007-06-23 04:42:29
Subject: Re: How to move a tablespace?

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