From: Bradley Miller <bmiller@nuvio.com>
To: Postgres List <pgsql-sql@postgresql.org>
Subject: pg_restore problem
Date: Wed, 2 Feb 2005 14:17:26 -0600
Message-ID: <74EFBC01-7557-11D9-AC7D-000D932ED682@nuvio.com> (raw)
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
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
Subject: Re: pg_restore problem
In-Reply-To: <74EFBC01-7557-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