From: | Jason Godden <jasongodden(at)optushome(dot)com(dot)au> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: BLOBS (ODBC lo object) and pg_restore |
Date: | 2003-03-11 09:05:54 |
Message-ID: | 200303112005.54778.jasongodden@optushome.com.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)optushome(dot)com(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Huxton | 2003-03-11 09:18:52 | Re: mapping user name to group name |
Previous Message | Martijn van Oosterhout | 2003-03-11 09:01:16 | Re: unlock Select for update |