Re: How to backup db with large objects?
От | Robert B. Easter |
---|---|
Тема | Re: How to backup db with large objects? |
Дата | |
Msg-id | 00060611075309.18270@comptechnews обсуждение исходный текст |
Ответ на | How to backup db with large objects? ("Ignas Saltis" <ignas.saltis@sintegra.lt>) |
Ответы |
Re: How to backup db with large objects?
|
Список | pgsql-general |
On Tue, 06 Jun 2000, Ignas Saltis wrote: > Hello, > > I have database with large objects? > > I did following: > > pg_dump database1 > database.out > createdb database2 > psql -e database2 < database.out > > And I can not access any large objects on database2. > > > database2=# select lo_export(picture_immage, '/home/postgres/image2.jpg') > from pictures where picture_id = 6; > ERROR: Relation 390625 does not exist > > > > Do I need to make backup using some special ways? > I can't find anything in docs. > > Any suggestions. pg_dump/all do not dump the large objects (AFAIK). ftp://ftp2.zf.jcu.cz/users/zakkr/pg/pg_dumplo-0.0.4.tar.gz might help you -- Robert B. Easter reaster@comptechnews.com
В списке pgsql-general по дате отправления: