Re: pg_dump & BLOBs ?

It can be found at ftp://ftp.postgresql.org/pub/dev

7.1 is not yet released as stable. That release is comming soon.

PS: Remember to reply to the list as well so others can benifit from
your questions

"Mark, Terry" wrote:
>
> Hi,
>
> Thanks for the information. However, I am still confused. I don't see a
> 7.1 for download anywhere on postgresql.org, and the site says the latest
> version is 7.0.3.
>
> Where do I find 7.1 (and is it a 'stable' release, or bleeding-edge only ?)
> ?
>
> Thank you,
> terry
>
> -----Original Message-----
> From: Randy Hall [mailto:rhall(at)greatbridge(dot)com]
> Sent: Friday, March 16, 2001 12:11 PM
> To: Mark, Terry
> Cc: pgsql-novice(at)postgresql(dot)org
> Subject: Re: [NOVICE] 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(at)home(dot)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
> > >
> > >

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