X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id AD3C08B9C1D
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed,  2 Feb 2005 20:18:10 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 40578-05
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed,  2 Feb 2005 20:17:59 +0000 (GMT)
Received: from lothos.nuvio.com (lothos.ojc.nuvio.com [63.77.68.101])
	by svr1.postgresql.org (Postfix) with ESMTP id DEFC58B9BD0
	for <pgsql-sql@postgresql.org>; Wed,  2 Feb 2005 20:17:59 +0000 (GMT)
Received: from [63.77.68.30] ([63.77.68.30]) by lothos.nuvio.com with
	Microsoft SMTPSVC(5.0.2195.6713); Wed, 2 Feb 2005 14:19:54 -0600
Mime-Version: 1.0 (Apple Message framework v619)
To: Postgres List <pgsql-sql@postgresql.org>
Message-Id: <74EFBC01-7557-11D9-AC7D-000D932ED682@nuvio.com>
Content-Type: multipart/alternative; boundary=Apple-Mail-11-219228041
From: Bradley Miller <bmiller@nuvio.com>
Subject: pg_restore problem
Date: Wed, 2 Feb 2005 14:17:26 -0600
X-Mailer: Apple Mail (2.619)
X-OriginalArrivalTime: 02 Feb 2005 20:19:54.0703 (UTC)
	FILETIME=[8ECBD5F0:01C50964]
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.131 tagged_above=0 required=5 tests=AWL
X-Spam-Level: 
X-Archive-Number: 200502/46
X-Sequence-Number: 20157


--Apple-Mail-11-219228041
Content-Transfer-Encoding: 7bit
Content-Type: text/plain;
	charset=US-ASCII;
	format=flowed

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

This is what I'm using to restore the files with:

pg_restore -O -x -s -N -d nuvio mac_postgres_2_2_2005_13_24

Any suggestions on how to get around this problem?  It's a huge pain so 
far just to sync my two servers up.

Bradley Miller
NUVIO CORPORATION
Phone: 816-444-4422 ext. 6757
Fax: 913-498-1810
http://www.nuvio.com
bmiller@nuvio.com
--Apple-Mail-11-219228041
Content-Transfer-Encoding: 7bit
Content-Type: text/enriched;
	charset=US-ASCII

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


This is what I'm using to restore the files with:


pg_restore -O -x -s -N -d nuvio mac_postgres_2_2_2005_13_24 


Any suggestions on how to get around this problem?  It's a huge pain
so far just to sync my two servers up.


Bradley Miller

<bold><fontfamily><param>Arial</param><color><param>1313,0000,FFFF</param><x-tad-bigger>NUVIO
CORPORATION</x-tad-bigger></color></fontfamily></bold><fontfamily><param>Arial</param><x-tad-bigger>

Phone: 816-444-4422 ext. 6757

Fax: 913-498-1810

</x-tad-bigger><color><param>0000,0000,FFFF</param><x-tad-bigger>http://www.nuvio.com</x-tad-bigger></color><x-tad-bigger>

</x-tad-bigger><color><param>0000,0000,FFFF</param><x-tad-bigger>bmiller@nuvio.com</x-tad-bigger></color></fontfamily>
--Apple-Mail-11-219228041--