"Henry T. So Jr." <henryso(at)earthling(dot)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