Thread: upgrading a database with large objects

upgrading a database with large objects

From

"Henry T. So Jr."

Date:

04 June 2001, 13:41:21

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?

Henry.

Re: upgrading a database with large objects

From

Lamar Owen

Date:

04 June 2001, 14:08:16

-----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-----

Re: upgrading a database with large objects

From

Tom Lane

Date:

04 June 2001, 14:58:37

"Henry T. So Jr." <henryso@earthling.net> writes:
> 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?

The easiest way is to use 7.1.2 or later pg_dump to dump your old
database; pg_dump now knows about LOs, and it will still talk to your
old server.  Read the man page though; I don't believe that LO dumping
is on by default.

            regards, tom lane

Re: upgrading a database with large objects

From

Lee Kwok Shing

Date:

11 June 2001, 12:55:11

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@postgresql.org

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

Attachment

kslee.vcf