Re: Migration from PG 7.1.3 to 8.1.1 with blobs

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Pierre LEBRECH" <pierre(dot)lebrech(at)laposte(dot)net>
Cc: "pgsql-admin" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Migration from PG 7.1.3 to 8.1.1 with blobs
Date: 2006-01-06 14:35:38
Message-ID: 21102.1136558138@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"Pierre LEBRECH" <pierre(dot)lebrech(at)laposte(dot)net> writes:
> I want to migrate a PostgreSQL db from 7.1.3 to PG db 8.1.1.

Wow, that's a big jump. Expect to find a few minor incompatibilities...

> The db contains blobs. Some time ago, I used pg_dumplo to dump
> and restore blobs. But in 8.1.1, I can not find anymore this
> little program to do the job.

I think it's still in contrib/, but you really don't need it. pg_dump
handles blobs just fine these days. Just point 8.1's pg_dump at the
7.1 server.

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message aWiryawan 2006-01-06 14:39:01 Installation Guide for PG 8.1.1
Previous Message Larry Rosenman 2006-01-06 14:34:21 Re: Migration from PG 7.1.3 to 8.1.1 with blobs