"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
In response to
pgsql-admin by date
|Next:||From: Andrea Fanfani||Date: 2001-03-31 09:11:13|
|Subject: Re: Help - Index on pg_shadow corruption!! Database down!!|
|Previous:||From: Bruce Momjian||Date: 2001-03-31 01:14:50|
|Subject: Re: [SQL] Re: pg_dump potential bug -UNIQUE INDEX on PG_SHADOW Dont!!