Re: Backing up large objects

"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