Re: pg_dump & BLOBs ?

pg_dump in 7.0.3 does not have any BLOB support.  In order to upgrade
from 6.5/7.0 to 7.1, you need to export your blobs with pg_dumplo_old.
This program can be found in the contrib tree of 7.1.  Then you use
pg_dumplo to load the blobs back into 7.1.  pg_dumplo can also be found
in the 7.1 contrib tree.

Once you have gone through this procedure, the 7.1 version of pg_dump
will handle backups and restores of all your blobs.

You are correct that pg_restore did not exist in 7.0.  Restores were
done by piping the dump file in to psql.

"Mark, Terry" wrote:
>
> Hi all,
>
> I did a search and found some pages indeed some man pages) indicating that
> pg_dump and and a (new utility ?) pg_restore now supported BLOBs - one page
> had an example with a --blobs flag.  However after building 7.0.3 I find
> that pg_dump does not accept --blobs, and there is no pg_restoer..  A look
> at the man pages on postgresql.org showed no --blobs option (and no
> pg_restore).
>
> What's the status of pg_dump et al., and BLOBs ?
> thanks,
> terry
>
> > ----------
> > From:         Frank Hilliard[SMTP:frankhilliard@home.com]
> > Sent:         Thursday, March 08, 2001 2:21 PM
> > To:   PostGreSQL Novice List
> > Subject:      PostgreSQL ISP?
> >
> > Can anyone recommend an ISP who uses Cold Fusion and gives you Telnet
> > access into your PostgreSQL account?
> >
> > Frank Hilliard
> >
> >
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html

--
---------------------------------------------------
Randy Hall                    Great Bridge, LLC
Sr. Knowledge Engineer        253 Monticello Avenue
Red Hat Certified Engineer    Norfolk, VA 23510