| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Peter Pilsl <pilsl(at)goldfisch(dot)at> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: backup with blobs |
| Date: | 2001-04-18 22:07:33 |
| Message-ID: | 16602.987631653@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Peter Pilsl <pilsl(at)goldfisch(dot)at> writes:
> I'm currently using postgreSQL 7.0.2 and have big tables with a lot of
> blobs. pg_dump does not cover this blobs.
> When my system crashes or when I want to migrate to 7.1, will a pure
> file-backup be enough or will I have to write my own tools for backup
> and restore of this blobs and their oid's in the corresponding tables.
No need to re-invent the wheel; use the attached.
BTW, 7.1's pg_dump is capable of dumping BLOBs. There has been talk of
hacking it up so that it could be used against a 7.0 database, which
would probably be a nicer solution than the attached code, but AFAIK
that's not done yet.
regards, tom lane
| Attachment | Content-Type | Size |
|---|---|---|
| pg_dumplo_old.tar.gz | application/octet-stream | 7.2 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Glen Eustace | 2001-04-18 22:52:31 | Problems with new DBD |
| Previous Message | Stoppel, Brett W | 2001-04-18 22:01:24 | RE: Inheritance question |