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
Then:
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...
