Skip site navigation (1) Skip section navigation (2)

Re: Backing up large objects

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Martijn de Munnik" <m(dot)h(dot)m(dot)demunnik(at)phys(dot)uu(dot)nl>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Backing up large objects
Date: 2001-03-31 05:17:12
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
"Martijn de Munnik" <m(dot)h(dot)m(dot)demunnik(at)phys(dot)uu(dot)nl> writes:
> im unsing PostgreSQL as a database backend for my website and therefore it
> stores image's and other large objects. As far as I know pg_dump(all) isn't
> capable of backing up large objects. So I was wondering how to backup the
> image's etc. Is there a script or such which does do the job?

7.1 pg_dump can handle large objects, but in prior versions you have to
use some additional code.  Attached is some code that will work in 7.0.
(I think it works in 6.5 too, but have not tested.)

			regards, tom lane

Attachment: pg_dumplo_70.tar.gz
Description: application/octet-stream (7.2 KB)

In response to

pgsql-admin by date

Next:From: Andrea FanfaniDate: 2001-03-31 09:11:13
Subject: Re: Help - Index on pg_shadow corruption!! Database down!!
Previous:From: Bruce MomjianDate: 2001-03-31 01:14:50
Subject: Re: [SQL] Re: pg_dump potential bug -UNIQUE INDEX on PG_SHADOW Dont!! HELP

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group