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

7.2.x -> 7.3 upgrade docs?

From: Thomas O'Connell <tfo(at)monsterlabs(dot)com>
To: pgsql-admin(at)postgresql(dot)org, pgsql-docs(at)postgresql(dot)org,pgsql-general(at)postgresql(dot)org
Subject: 7.2.x -> 7.3 upgrade docs?
Date: 2002-12-11 20:43:27
Message-ID: tfo-44E9FD.14432711122002@news.hub.org (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-docspgsql-general
has anyone put together a Sensible Strategies for Upgrading document 
when moving from 7.2.x to 7.3?

for instance, i've read in a few different places that not all 
dependencies will be appropriately created.

as an admin, my biggest questions are:

1. is it necessary, strongly recommended, recommended, or irrelevant to 
run contrib/adddepend?

2. is it necessary, strongly recommended, recommended, or irrelevant to 
upgrade DBD::Pg for people accessing postgres via the Perl DBI? speaking 
of which, are there docs about what changed in the latest DBD::Pg?

3. what is the default environment as far as schemas are concerned for 
databases that have been migrated? is there just a public schema created 
for all objects? is it possible to move existing tables into 
user-created schemas? i didn't see an ALTER TABLE SET SCHEMA...

4. are there other important considerations i might be overlooking?

i've read the new docs, but the upgrade section remains much the same as 
previous versions, despite the fact that there seem to be enough catalog 
changes between 7.2 and 7.3 that admins ought to be paying attention to 
more details than are presented there. so far, the reading i've done has 
provided a varying amount of detail in a variety of places: the new 
version of the docs, the HISTORY file, the mailing lists; but nothing 
i've yet seen gives a complete picture of the important details to be 
considered when upgrading. maybe the details aren't as important as i'm 
guessing? i kind of feel otherwise, though.

thanks!

-tfo

Thomas F. O'Connell
DBA | Systems Programmer
Monster Labs, Inc.
http://www.monsterlabs.com/
110 30th Avenue North, Suite 1
Nashville, TN 37203
phone: 615-301-2600 x132
fax: 615-301-2602

Responses

pgsql-docs by date

Next:From: Ian BarwickDate: 2002-12-11 22:25:56
Subject: Re: 7.2.x -> 7.3 upgrade docs?
Previous:From: Bruce MomjianDate: 2002-12-06 05:18:56
Subject: Re: minor doc fix

pgsql-admin by date

Next:From: Ian BarwickDate: 2002-12-11 22:25:56
Subject: Re: 7.2.x -> 7.3 upgrade docs?
Previous:From: Nick FankhauserDate: 2002-12-11 20:03:19
Subject: Re: PKs for dictionary tables

pgsql-general by date

Next:From: Toby TremayneDate: 2002-12-11 21:59:03
Subject: refursor from dynamic query
Previous:From: Samuel J. SutjionoDate: 2002-12-11 20:15:47
Subject: Re: Recovery Mode

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