From: | Patrick Welche <prlw1(at)newn(dot)cam(dot)ac(dot)uk> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Patrick Welche <prlw1(at)newn(dot)cam(dot)ac(dot)uk>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: upgrade path / versioning roles |
Date: | 2005-09-01 18:52:28 |
Message-ID: | 20050901185228.GB27079@quartz.itdept.newn.cam.ac.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Thu, Sep 01, 2005 at 02:31:15PM -0400, Tom Lane wrote:
> Patrick Welche <prlw1(at)newn(dot)cam(dot)ac(dot)uk> writes:
> > I think we still recommend using *new* pg_dump to dump *old* server when
> > upgrading. If one tries that with today's pg_dump (8.1beta1) against
> > a 8.1devel server of 6 May, i.e., predating roles, one gets:
>
> [ shrug... ] The current code is expecting that "8.1" means what it
> means today. For dumping from a between-releases snapshot, you'd better
> use the pg_dump from the same snapshot.
OK - that way around just gets the NOTICE
psql:./huge.db:11: NOTICE: SYSID can no longer be specified
- fair enough.
BTW there was an earlier thread about plpgsql validation. The aforementioned
8.1devel database has a long history and createlang was run against an
early 7 incarnation, with pg_dumpall -> new database all the way to the
present. I tried the fix mentioned in the earlier message to encourage
validation. Now dumping this "fixed" database, and loadinging it into the
new database gives:
ALTER FUNCTION
psql:./huge.db:4403: ERROR: function plpgsql_validator(oid) does not exist
CREATE FUNCTION
ALTER FUNCTION
psql:./huge.db:4517: ERROR: language "plpgsql" does not exist
HINT: You need to use "createlang" to load the language into the database.
now to unfix the fix...
Cheers,
Patrick
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2005-09-01 18:53:12 | Re: Version number in psql banner |
Previous Message | aly.dharshi | 2005-09-01 18:44:50 | Re: Version number in psql banner |