pg_restore problem

From: Bradley Miller <bmiller(at)nuvio(dot)com>
To: Postgres List <pgsql-sql(at)postgresql(dot)org>
Subject: pg_restore problem
Date: 2005-02-02 20:17:26
Message-ID: 74EFBC01-7557-11D9-AC7D-000D932ED682@nuvio.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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(at)nuvio(dot)com

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Joel Fradkin 2005-02-02 20:46:46 Re: pg_restore problem
Previous Message Theodore Petrosky 2005-02-02 16:02:12 locale with os x