pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
large objects missing
2+ messages / 2 participants
[nested] [flat]

* large objects missing
@ 2004-02-17 17:10  Warren Little <wlittle@securitylending.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Warren Little @ 2004-02-17 17:10 UTC (permalink / raw)
  To: pgsql-admin

In an attempt to migrate from 7.3 to 7.4 doing a pg_dumpall I did not
get any of my large objects.  Is there a special process which needs to
take place and is there a way to simple copy the large objects
seperately?

-- 
Warren Little
Senior Vice President
Secondary Marketing
Security Lending Wholesale, LC
www.securitylending.com
Tel: 866-369-7763
Fax: 866-849-8082



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: large objects missing
@ 2004-02-17 23:59  Tom Lane <tgl@sss.pgh.pa.us>
  parent: Warren Little <wlittle@securitylending.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Tom Lane @ 2004-02-17 23:59 UTC (permalink / raw)
  To: Warren Little <wlittle@securitylending.com>; +Cc: pgsql-admin

Warren Little <wlittle@securitylending.com> writes:
> In an attempt to migrate from 7.3 to 7.4 doing a pg_dumpall I did not
> get any of my large objects.  Is there a special process which needs to
> take place and is there a way to simple copy the large objects
> seperately?

pg_dumpall doesn't handle large objects, because it can only do textual
output format and pg_dump doesn't have a way to dump large objects
textually.  What you have to do at the moment is use pg_dump
individually on each DB that contains large objects, specifying either
-Fc or -Ft (I'd recommend the former) plus -b to dump blobs.  Then
pg_restore each of these dumps.  I think you can use pg_restore's list
option to select just the blobs to be restored, but I'm not sure how
well that really works when the destination DB has already been modified
to some extent.  You'd be well advised to experiment in a scratch copy
of the database before you try it on your live DB.

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2004-02-17 23:59 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-02-17 17:10 large objects missing Warren Little <wlittle@securitylending.com>
2004-02-17 23:59 ` Tom Lane <tgl@sss.pgh.pa.us>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox