Postgres Pro
Downloads
Home   >   mailing lists

Thread: pg_dump & BLOBs ?

pg_dump & BLOBs ?

From
"Mark, Terry"
Date:
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
>
>

pg_dump & BLOBs ?

From
brew@theMode.com
Date:

> What's the status of pg_dump et al., and BLOBs ?

And on a (maybe) related topic I did a pg_dump and the output has a few
lines that ask for input from stdin, which I'm confused about.  Could that
possibly be BLOB data?  I'm trying to port a database from one 7.0.3
postgres to 7.0.3 on another machine that somebody else.

brew

 ==========================================================================
                  Strange Brew   (brew@theMode.com)
     Check out my Musician's Online Database Exchange (The MODE Pages)
                        http://www.TheMode.com
 ==========================================================================

Re: pg_dump & BLOBs ?

From
Randy Hall
Date:
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