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
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-docs pgsql-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

Browse pgsql-admin by date

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

Browse pgsql-docs by date

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

Browse pgsql-general by date

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