Errors during dump/restore - Mailing list pgsql-general

From Jani Averbach
Subject Errors during dump/restore
Date
Msg-id Pine.GSO.4.33.0204241550000.18712-100000@tukki.cc.jyu.fi
Whole thread Raw
Responses Re: Errors during dump/restore
List pgsql-general
Hi!


We just upgrade our database system to the pgsql 7.2.1.
During dump/restore cycle there has following errors.

The dump command was
pg_dumpall -o > outputfile
and restore
psql -d template1 -f outputfile
just like told by install.

Any ideas? Database however is just fine, and there isn't any futher
errors.

btw: These same errors could be generated by dumping just one database,
and restoring it to other name.

BR, Jani

---------- Forwarded message ----------

psql:/srv/db/pgsql_v7.1.2.data:72402: ERROR:  relation "pgadmin_databases"
not found
psql:/srv/db/pgsql_v7.1.2.data:72403: ERROR:  relation "pgadmin_databases"
not found
psql:/srv/db/pgsql_v7.1.2.data:72404: ERROR:  relation "pgadmin_databases"
not found
CREATE
psql:/srv/db/pgsql_v7.1.2.data:72420: ERROR:  relation "pgadmin_checks"
not found
psql:/srv/db/pgsql_v7.1.2.data:72421: ERROR:  relation "pgadmin_checks"
not found
psql:/srv/db/pgsql_v7.1.2.data:72422: ERROR:  relation "pgadmin_checks"
not found
psql:/srv/db/pgsql_v7.1.2.data:72430: ERROR:  No such attribute or
function 'oid'
psql:/srv/db/pgsql_v7.1.2.data:72438: ERROR:  relation "pgadmin_functions"
not found
...

--
Jani Averbach



pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: postgres throughput .
Next
From: Doug McNaught
Date:
Subject: Re: Connections per second?