pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Load DB - Conversion from 8.1.4 to 8.2.4
5+ messages / 4 participants
[nested] [flat]

* Load DB - Conversion from 8.1.4 to 8.2.4
@ 2007-06-24 18:55 Campbell, Lance <lance@uiuc.edu>
  2007-06-24 20:06 ` Re: Load DB - Conversion from 8.1.4 to 8.2.4 Tommy Gildseth <tommy.gildseth@usit.uio.no>
  0 siblings, 1 reply; 5+ messages in thread

From: Campbell, Lance @ 2007-06-24 18:55 UTC (permalink / raw)
  To: 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

 

^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Load DB - Conversion from 8.1.4 to 8.2.4
  2007-06-24 18:55 Load DB - Conversion from 8.1.4 to 8.2.4 Campbell, Lance <lance@uiuc.edu>
@ 2007-06-24 20:06 ` Tommy Gildseth <tommy.gildseth@usit.uio.no>
  2007-06-27 00:14   ` Re: Load DB - Conversion from 8.1.4 to 8.2.4 Peter Koczan <pjkoczan@gmail.com>
  0 siblings, 1 reply; 5+ messages in thread

From: Tommy Gildseth @ 2007-06-24 20:06 UTC (permalink / raw)
  To: Campbell, Lance <lance@uiuc.edu>; +Cc: 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




^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Load DB - Conversion from 8.1.4 to 8.2.4
  2007-06-24 18:55 Load DB - Conversion from 8.1.4 to 8.2.4 Campbell, Lance <lance@uiuc.edu>
  2007-06-24 20:06 ` Re: Load DB - Conversion from 8.1.4 to 8.2.4 Tommy Gildseth <tommy.gildseth@usit.uio.no>
@ 2007-06-27 00:14   ` Peter Koczan <pjkoczan@gmail.com>
  2007-06-27 02:27     ` Re: Load DB - Conversion from 8.1.4 to 8.2.4 Campbell, Lance <lance@uiuc.edu>
  0 siblings, 1 reply; 5+ messages in thread

From: Peter Koczan @ 2007-06-27 00:14 UTC (permalink / raw)
  To: Tommy Gildseth <tommy.gildseth@usit.uio.no>; +Cc: Campbell, Lance <lance@uiuc.edu>; pgsql-admin

Tommy Gildseth wrote:
> 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.
>
>
Two quick addendums:

- pg_dump doesn't dump large objects. You should use the following if 
you use large objects.

pg_dump -h /host1/ –p 1234 -Fc /dbname/ | pg_restore -h /host1 –p 56789/ 
/dbname///

- There might be some other issues with the upgrade. I've run into 
permissions issues, data types that were checked more strictly, and a 
couple broken primary keys in my days as an admin. I'm not saying you'll 
run into these, but if you can, do a dry run of a dump/restore so you 
can solve the problems up front.

Peter



^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Load DB - Conversion from 8.1.4 to 8.2.4
  2007-06-24 18:55 Load DB - Conversion from 8.1.4 to 8.2.4 Campbell, Lance <lance@uiuc.edu>
  2007-06-24 20:06 ` Re: Load DB - Conversion from 8.1.4 to 8.2.4 Tommy Gildseth <tommy.gildseth@usit.uio.no>
  2007-06-27 00:14   ` Re: Load DB - Conversion from 8.1.4 to 8.2.4 Peter Koczan <pjkoczan@gmail.com>
@ 2007-06-27 02:27     ` Campbell, Lance <lance@uiuc.edu>
  2007-06-27 04:14       ` Re: Load DB - Conversion from 8.1.4 to 8.2.4 Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 1 reply; 5+ messages in thread

From: Campbell, Lance @ 2007-06-27 02:27 UTC (permalink / raw)
  To: Peter Koczan <pjkoczan@gmail.com>; Tommy Gildseth <tommy.gildseth@usit.uio.no>; +Cc: pgsql-admin

I was thinking about upgrading from 8.1.4 to 8.1.9.  Then I will do the
upgrade from 8.1.9 to 8.2.4.

Is this a better approach?

Thanks,

Lance Campbell
Project Manager/Software Architect
Web Services at Public Affairs
University of Illinois
217.333.0382
http://webservices.uiuc.edu
 
-----Original Message-----
From: Peter Koczan [mailto:pjkoczan@gmail.com] 
Sent: Tuesday, June 26, 2007 7:14 PM
To: Tommy Gildseth
Cc: Campbell, Lance; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Load DB - Conversion from 8.1.4 to 8.2.4

Tommy Gildseth wrote:
> 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.
>
>
Two quick addendums:

- pg_dump doesn't dump large objects. You should use the following if 
you use large objects.

pg_dump -h /host1/ -p 1234 -Fc /dbname/ | pg_restore -h /host1 -p 56789/

/dbname///

- There might be some other issues with the upgrade. I've run into 
permissions issues, data types that were checked more strictly, and a 
couple broken primary keys in my days as an admin. I'm not saying you'll

run into these, but if you can, do a dry run of a dump/restore so you 
can solve the problems up front.

Peter



^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Load DB - Conversion from 8.1.4 to 8.2.4
  2007-06-24 18:55 Load DB - Conversion from 8.1.4 to 8.2.4 Campbell, Lance <lance@uiuc.edu>
  2007-06-24 20:06 ` Re: Load DB - Conversion from 8.1.4 to 8.2.4 Tommy Gildseth <tommy.gildseth@usit.uio.no>
  2007-06-27 00:14   ` Re: Load DB - Conversion from 8.1.4 to 8.2.4 Peter Koczan <pjkoczan@gmail.com>
  2007-06-27 02:27     ` Re: Load DB - Conversion from 8.1.4 to 8.2.4 Campbell, Lance <lance@uiuc.edu>
@ 2007-06-27 04:14       ` Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 0 replies; 5+ messages in thread

From: Tom Lane @ 2007-06-27 04:14 UTC (permalink / raw)
  To: Campbell, Lance <lance@uiuc.edu>; +Cc: Peter Koczan <pjkoczan@gmail.com>; Tommy Gildseth <tommy.gildseth@usit.uio.no>; pgsql-admin

"Campbell, Lance" <lance@uiuc.edu> writes:
> I was thinking about upgrading from 8.1.4 to 8.1.9.  Then I will do the
> upgrade from 8.1.9 to 8.2.4.

AFAIK there's no point to that.  Just jump to 8.2 in one step.  There
are not any bug fixes in 8.1.9 that you'd not get from 8.2.x.

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 5+ messages in thread


end of thread, other threads:[~2007-06-27 04:14 UTC | newest]

Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-06-24 18:55 Load DB - Conversion from 8.1.4 to 8.2.4 Campbell, Lance <lance@uiuc.edu>
2007-06-24 20:06 ` Tommy Gildseth <tommy.gildseth@usit.uio.no>
2007-06-27 00:14   ` Peter Koczan <pjkoczan@gmail.com>
2007-06-27 02:27     ` Campbell, Lance <lance@uiuc.edu>
2007-06-27 04:14       ` Tom Lane <tgl@sss.pgh.pa.us>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox