Re: Dump/Restore Large Object OID

From: Norberto Delle <betodelle(at)gmail(dot)com>
To: Gurjeet Singh <singh(dot)gurjeet(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Dump/Restore Large Object OID
Date: 2007-12-03 11:23:48
Message-ID: 4753E744.60709@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Gurjeet Singh wrote:
<blockquote
cite="mid:65937bea0712011949o7c6888bel8c020f21a116756c(at)mail(dot)gmail(dot)com"
type="cite"><span style="font-family: courier new,monospace;">Why not
give it a try once? Dump and restore once and see for yourself. You'd
have done that by now, but if you haven't do give it a try instead of
waiting any more. You may learn a thing or two in the process...
</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;"></span><br>
<div><span class="gmail_quote">On 11/29/07, <b
class="gmail_sendername">Norberto Delle</b> &lt;<a
moz-do-not-send="true" href="mailto:betodelle(at)gmail(dot)com">betodelle(at)gmail(dot)com</a>&gt;
wrote:
</span>
<blockquote class="gmail_quote"
style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Hi
all<br>
<br>
If I don't use the --oids option when dumping a database with pg_dump,
<br>
can I assure that the "loid" field of the pg_largeobject table will keep<br>
it's value when restoring?<br>
<br>
</blockquote>
</div>
<br>
</blockquote>
Of course, I already done that. I'm using pgAdmin to make database
backups\restores, without checking the "With OIDs" option and it<br>
works well for the most of the cases. But sometimes referenced large
objects are not found after the restore, that's is why I'm asking.<br>
<br>
</body>
</html>

Attachment Content-Type Size
unknown_filename text/html 1.6 KB

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Marco Colombo 2007-12-03 11:24:11 Re: Why LIMIT and OFFSET are commutative
Previous Message Tom Allison 2007-12-03 11:03:40 Re: power failure....