Re: what kind of upgrade path is this

From: Andrew Sullivan <andrew(at)libertyrms(dot)info>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: what kind of upgrade path is this
Date: 2003-02-20 18:11:17
Message-ID: 20030220131117.K3235@mail.libertyrms.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Feb 20, 2003 at 09:09:02AM -0800, Nathan Suderman wrote:
> "typprtlen" not found
>
> when trying to use pg_dump from another box(7.1.1). Not only does this
> break almost every form of data manipulation we have here but it totally
> voids our backup. Apparently someone made the decision to remove these

Does this mean you are trying to do pg_dump with a version of pg_dump
which does not match the server?

If so, it's a bad idea. The _later_ versions can generally dump
earlier servers, but earlier versions of pg_dump cannot be expected
to be able to dump later servers. Indeed, the latest version of the
manual for pg_dump includes this caveat:

-i
--ignore-version

Ignore version mismatch between pg_dump and the database server.

pg_dump can handle databases from previous releases of PostgreSQL,
but very old versions are not supported anymore (currently prior to
7.0). Use this option if you need to override the version check (and
if pg_dump then fails, don't say you weren't warned).

> communicating to each other. And this move to 7.3 has been so time
> consuming that it will takes months to upgrade every box because so many
> changes have been made that every box has to be re-evaluated to make
> sure it still works. And this is just for the obvious known changes.

I agree that the differences between versions can be pretty daunting,
and it causes an swful lot of pain when upgrading. At the same time,
the PostgreSQL project moves pretty quickly, and since they warn us
that a major version is where the interfaces, system catalogue, and
such will change, it is only fair to expect that you need to do quite
a bit of evaluation when changing major versions.

> I am looking for any help on getting a dump out of this box.

You need a 7.3 pg_dump, I think.

A

--
----
Andrew Sullivan 204-4141 Yonge Street
Liberty RMS Toronto, Ontario Canada
<andrew(at)libertyrms(dot)info> M2P 2A8
+1 416 646 3304 x110

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Beutin 2003-02-20 18:14:48 Re: max connections
Previous Message Williams, Travis L, NPONS 2003-02-20 18:05:11 Re: max connections