From: Tom Lane <tgl@sss.pgh.pa.us>
To: Amrit Angsusingh <amrit@chaiyo.com>
Cc: postgresql admin <pgsql-admin@postgresql.org>
Subject: Re: Blob error after backup and restore [database > 5.5 Gb.]
Date: Tue, 14 Jun 2005 23:53:55 -0400
Message-ID: <27810.1118807635@sss.pgh.pa.us> (raw)
In-Reply-To: <20050615030013.2346.qmail@chaiyo.com>
References: <20050615030013.2346.qmail@chaiyo.com>
"Amrit Angsusingh" <amrit@chaiyo.com> writes:
> after I try to restore it in another server which has the same environment [via nfs] and use the command
> pg_restore -d test test.tar
> The database "test" after restoration has the same data but no blob
> found .
Another thought here: what exactly do you mean by "no blob found"?
The current implementation does not try to restore blobs with the same
OIDs they had in the original database --- rather, it loads them up with
whatever OIDs the new backend cares to assign, and then tries to fix up
database columns of OID and LO types to reference the new OIDs instead
of the old ones.
This is obviously pretty fragile, and we are thinking about changing it
for 8.1, but I wonder if you are getting bit because you are doing
something that pg_restore isn't expecting.
regards, tom lane
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, amrit@chaiyo.com
Subject: Re: Blob error after backup and restore [database > 5.5 Gb.]
In-Reply-To: <27810.1118807635@sss.pgh.pa.us>
References: <20050615030013.2346.qmail@chaiyo.com> <27810.1118807635@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