pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Bradley Miller <bmiller@nuvio.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Postgres List <pgsql-sql@postgresql.org>
Subject: Re: pg_restore problem
Date: Thu, 3 Feb 2005 08:16:01 -0600
Message-ID: <21AFCC70-75EE-11D9-AC7D-000D932ED682@nuvio.com> (raw)
In-Reply-To: <6725.1107379479@sss.pgh.pa.us>
References: <74EFBC01-7557-11D9-AC7D-000D932ED682@nuvio.com>
	<6725.1107379479@sss.pgh.pa.us>

So in the current version I'm running (7.4.6) and I do a pg_dump I have 
to then manually manipulate the order by doing a -l to get a table of 
contents and then reorder (just changing the first number; or the oid 
also??) just to get it to work right?   Does anyone else have these 
issues?  How exactly can I use this on a mission critical app with 
flaws like this?   How do other people work with this?  Do they just 
not dump the files and restore?


On Feb 2, 2005, at 3:24 PM, Tom Lane wrote:

> Bradley Miller <bmiller@nuvio.com> writes:
>> I'm attempting to restore a dump from one server to another (one is a
>> Mac and one is a Linux base, if that makes any difference).  I keep
>> running into issues like this:
>
>> pg_restore: [archiver (db)] could not execute query: ERROR:  function
>> public.random_page_link_id_gen() does not exist
>
> Is this a problem of items in the dump being in the wrong order (ie,
> there's a forward reference to random_page_link_id_gen())?
>
>> Any suggestions on how to get around this problem?
>
> Use 8.0 ... or use pg_restore's -L/-l options to manually adjust the
> load order.  Pre-8.0 versions of pg_dump are easily fooled if you use
> ALTER to make earlier-created objects reference later-created objects.
>
> 			regards, tom lane
>
>
Bradley Miller
NUVIO CORPORATION
Phone: 816-444-4422 ext. 6757
Fax: 913-498-1810
http://www.nuvio.com
bmiller@nuvio.com

view thread (9+ messages)  latest in thread

Message-ID: <21AFCC70-75EE-11D9-AC7D-000D932ED682@nuvio.com>
Permalink:  ../21AFCC70-75EE-11D9-AC7D-000D932ED682@nuvio.com/
Also on:    postgresql.org/message-id/21AFCC70-75EE-11D9-AC7D-000D932ED682@nuvio.com

 · 

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 using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: bmiller@nuvio.com, tgl@sss.pgh.pa.us
  Subject: Re: pg_restore problem
  In-Reply-To: <21AFCC70-75EE-11D9-AC7D-000D932ED682@nuvio.com>

* 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