Re: upgrading a database with large objects

Hello,

Sorry to break in, since I encounters the same problem...

I tried this method, but the pg_dumplo complains that

pg_dumplo: Failed to get LO OIDs:
ERROR: Relation 'pg_largeobject' does not exist

Exported 0 large objects.

Thanks a lot !
Lee Kwok Shing

Lamar Owen wrote:

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> On Monday 04 June 2001 10:09, Henry T. So Jr. wrote:
> > Is there a howto or some other sort of document that details what I should
> > do to upgrade my PostgreSQL 7.0.x database (which has large objects) to a
> > 7.1.x database? Do I have to write a progrem to do it? Or am I just too
> > worried about it because it will be handled auto-magically?
>
> It will not be handled automagically -- PostgreSQL upgrades aren't _that_
> easy.
>
> You will need to build the pg_dumplo utility found in the contrib area of the
> source distribution,and follow the instructions found with it, as well as
> found in the 7.1.x documentation under the Installation section.
> - --
> Lamar Owen
> WGCR Internet Radio
> 1 Peter 4:11
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.0.4 (GNU/Linux)
> Comment: For info see http://www.gnupg.org
>
> iD8DBQE7G6HF5kGGI8vV9eERApb+AKDk9miD7HhmtibLMWq98rhzOncOjgCfZwXa
> nxclVO7Xz7qHHkYkscM7jIk=
> =aGgE
> -----END PGP SIGNATURE-----
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org

--
Lee Kwok Shing (***)
http://www.geocities.com/lkslee.geo