Forum OpenACS Q&A: Re: 3.2.5 with 4.6 on same Linux/Postgres install -- delurk

I dumped an OpenACS 3.2.5 database from version 7.1.2 (RH 7.1, Postgresql 7.1.2 rpm version) with a lot of blobs using this command:
pg_dump -Ft -b mydb > mydb.tar,

which produced a 30 MB tarball.

I installed RH 7.3 and PostgreSQL 7.2.4 rpm version.

I created a pristine database:

createdb -T template0 newdb


pg_restore -d mydb.tar newdb

This produced a lot of notices, until:

pg_restore: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'event_info_pkey' for table 'event_info'
pg_restore: ERROR:  copy: line 389, Cannot insert a duplicate key into unique index user_group_map_pkey
pg_restore: lost synchronization with server, resetting connection
pg_restore: [archiver (db)] error returned by PQendcopy

And that was it.

psql -V output:

psql (PostgreSQL) 7.2.4
contains support for: readline, history, multibyte
Portions Copyright (c) 1996-2001, PostgreSQL Global Development Group
Portions Copyright (c) 1996, Regents of the University of California
Read the file COPYRIGHT or use the command \copyright to see the
usage and distribution terms.

A smaller OpenACS 3.2.5 database does load without errors and is OK.

An OpenACS4 database did not load at all:

$ pg_restore -d oacs oacs46-12mrt.tar
pg_restore: [archiver (db)] could not execute query: ERROR:  Function 'tree_ancestor_keys(varbit, int4)' does not exist
    Unable to identify a function that satisfies the given argument types
    You may need to add explicit typecasts

Anybody got a clue? Thanks!

P.S. Maybe I should post this at the PostgreSQL forum as well...