Re: upgrading a database with large objects - Mailing list pgsql-general

From Tom Lane
Subject Re: upgrading a database with large objects
Date
Msg-id 281.991667850@sss.pgh.pa.us
Whole thread Raw
In response to upgrading a database with large objects  ("Henry T. So Jr." <henryso@earthling.net>)
List pgsql-general
"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

pgsql-general by date:

Previous
From: "Daniel A. Melo"
Date:
Subject: problem with Timestamp
Next
From: Uro Gruber
Date:
Subject: use of Function