Re: BLOBS (ODBC lo object) and pg_restore

Hi Tom,

Thanks for this - I'm really impressed with the response.  In the end I used
lo_export and PL/PGSQL procedure to dump all the files (60000 of them!) to
disk and I bz2 that up to backup each night.  I'll revisit pg_restore/pg_dump
when I get a chance.

I realise that you guys probably have plenty of developers but I'm wanting to
get my C/C++ back up to scratch again and I love Postgres - anything that you
guys need someone to sink their teeth into that I could have a shot at?

Cheers,

Jason

On Monday 10 March 2003 06:41, Tom Lane wrote:
> Jason Godden <jasongodden@optushome.com.au> writes:
> > ./pg_restore -p5431 -dsomedb -Ft -N -X disable-triggers
> > /var/db/backup/data.tar
> > ERROR: Relation "BLOBs" does not exist
>
> Here's the patch if you need it.
>
>             regards, tom lane
>
> *** src/bin/pg_dump/pg_backup_archiver.c~    Sat Feb  1 17:07:14 2003
> --- src/bin/pg_dump/pg_backup_archiver.c    Sun Mar  9 14:36:40 2003
> ***************
> *** 293,299 ****
>                        * Maybe we can't do BLOBS, so check if this node is
>                        * for BLOBS
>                        */
> !                     if ((strcmp(te->desc, "BLOBS") == 0) && !_canRestoreBlobs(AH))
>                       {
>                           ahprintf(AH, "--\n-- SKIPPED \n--\n\n");
>
> --- 293,300 ----
>                        * Maybe we can't do BLOBS, so check if this node is
>                        * for BLOBS
>                        */
> !                     if ((strcmp(te->desc, "BLOBS") == 0) &&
> !                         !_canRestoreBlobs(AH))
>                       {
>                           ahprintf(AH, "--\n-- SKIPPED \n--\n\n");
>
> ***************
> *** 445,450 ****
> --- 446,455 ----
>       if (!ropt->dataOnly || !ropt->disable_triggers)
>           return;
>
> +     /* Don't do it for the BLOBS TocEntry, either */
> +     if (te && strcmp(te->desc, "BLOBS") == 0)
> +         return;
> +
>       oldUser = strdup(AH->currUser);
>       oldSchema = strdup(AH->currSchema);
>
> ***************
> *** 506,511 ****
> --- 511,520 ----
>
>       /* This hack is only needed in a data-only restore */
>       if (!ropt->dataOnly || !ropt->disable_triggers)
> +         return;
> +
> +     /* Don't do it for the BLOBS TocEntry, either */
> +     if (te && strcmp(te->desc, "BLOBS") == 0)
>           return;
>
>       oldUser = strdup(AH->currUser);
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html