Re: Dump/Restore Large Object OID

Lists: pgsql-general
From: Norberto Delle <betodelle(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Dump/Restore Large Object OID
Date: 2007-11-29 19:23:18
Message-ID: 474F11A6.9080609@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-general

Hi all

If I don't use the --oids option when dumping a database with pg_dump,
can I assure that the "loid" field of the pg_largeobject table will keep
it's value when restoring?

Thanks in advance

Norberto

From: "Gurjeet Singh" <singh(dot)gurjeet(at)gmail(dot)com>
To: "Norberto Delle" <betodelle(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Dump/Restore Large Object OID
Date: 2007-12-02 03:49:10
Message-ID: 65937bea0712011949o7c6888bel8c020f21a116756c@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-general

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...

Best regards,
--
gurjeet[(dot)singh](at)EnterpriseDB(dot)com
singh(dot)gurjeet(at){ gmail | hotmail | indiatimes | yahoo }.com

EnterpriseDB http://www.enterprisedb.com

17° 29' 34.37"N, 78° 30' 59.76"E - Hyderabad
18° 32' 57.25"N, 73° 56' 25.42"E - Pune
37° 47' 19.72"N, 122° 24' 1.69" W - San Francisco *

Mail sent from my BlackLaptop device

On 11/29/07, Norberto Delle <betodelle(at)gmail(dot)com> wrote:
>
> Hi all
>
> If I don't use the --oids option when dumping a database with pg_dump,
> can I assure that the "loid" field of the pg_largeobject table will keep
> it's value when restoring?
>
> Thanks in advance
>
> Norberto
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>

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
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