Home > mailing lists

Load DB - Conversion from 8.1.4 to 8.2.4 - Mailing list pgsql-admin

From	Campbell, Lance
Subject	Load DB - Conversion from 8.1.4 to 8.2.4
Date	June 24, 2007 18:54:56
Msg-id	A3AC4FA47DC0B1458C3E5396E685E63302395E82@SAB-DC1.sab.uiuc.edu Whole thread Raw
Responses	Re: Load DB - Conversion from 8.1.4 to 8.2.4
List	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

From: Tom Lane
Date: 23 June 2007, 04:42:35
Subject: Re: How to move a tablespace?

From: Tommy Gildseth
Date: 24 June 2007, 20:32:26
Subject: Re: Load DB - Conversion from 8.1.4 to 8.2.4