upgrading a database with large objects

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

"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

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