pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Warren Little <wlittle@securitylending.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: large objects missing
Date: Tue, 17 Feb 2004 18:59:51 -0500
Message-ID: <19063.1077062391@sss.pgh.pa.us> (raw)
In-Reply-To: <1077037848.5869.5.camel@localhost.localdomain>
References: <1077037848.5869.5.camel@localhost.localdomain>

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



view thread (2+ messages)

Message-ID: <19063.1077062391@sss.pgh.pa.us>
Permalink:  ../19063.1077062391@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/19063.1077062391@sss.pgh.pa.us

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: tgl@sss.pgh.pa.us, wlittle@securitylending.com
  Subject: Re: large objects missing
  In-Reply-To: <19063.1077062391@sss.pgh.pa.us>
  References: <1077037848.5869.5.camel@localhost.localdomain> <19063.1077062391@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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