public inbox for [email protected]
help / color / mirror / Atom feedFrom: Ian Barwick <[email protected]>
To: Thomas O'Connell <[email protected]>
To: [email protected]
To: [email protected]
To: [email protected]
Subject: Re: 7.2.x -> 7.3 upgrade docs?
Date: Wed, 11 Dec 2002 23:25:56 +0100
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
On Wednesday 11 December 2002 21:43, Thomas O'Connell wrote:
> has anyone put together a Sensible Strategies for Upgrading document
> when moving from 7.2.x to 7.3?
Some replies to some of your questions:
> 2. is it necessary, strongly recommended, recommended, or irrelevant to
> upgrade DBD::Pg for people accessing postgres via the Perl DBI?
Short answer: no urgent need.
Long answer: Unfortunately DBD::Pg is "out of sync" with the PostgreSQL
release process and hasn't yet been upgraded to take into account of
the changes in 7.3.
_Basically_ a Perl application using DBD::Pg with 7.3 should work out of the
box if you retain all objects in the default PUBLIC schema; AFAICS there are
no problems using other schemas; where you may run into problems is with
DBD::Pg functions querying database meta-data (anything that accesses the
system catalogs). Definitively broken is the DBD::Pg-specific function
"table_attributes", though I am in the process of submitting a patch to fix
that.
> speaking
> of which, are there docs about what changed in the latest DBD::Pg?
The latest DBD::Pg (v1.20) includes a "Changes" file.
I haven't seen anything specific on using it with PostgreSQL 7.3. I've
run into the same issue myself and have a draft commentary and
possibly some further patches which I'll make available ASAP.
On a practical note: I´ve just upgraded a mod_perl/DBD::Pg application to
PostgreSQL 7.3 and have not encountered any DBD::Pg-related problems. The
application doesn't know about schemas yet though (all objects are in the
default PUBLIC schema).
> 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?
A typical dump/restore puts everything in the default PUBLIC schema.
> is it possible to move existing tables into
> user-created schemas? i didn't see an ALTER TABLE SET SCHEMA...
I don't think so; you may need to manually alter the pg_dump files
before restoring. Maybe someone more knowledgable will come up with
a more qualified answer.
> 4. are there other important considerations i might be overlooking?
I would recommend thorough testing before you commit to an upgrade ;-)
Ian Barwick
[email protected]
view thread (4+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected]
Subject: Re: 7.2.x -> 7.3 upgrade docs?
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox