Thread: Errors during dump/restore

Errors during dump/restore

From
Jani Averbach
Date:
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



Re: Errors during dump/restore

From
Jani Averbach
Date:
On Wed, 24 Apr 2002, Jani Averbach wrote:

To be more clear: These error occured during restore.

BR, Jani
>
> 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
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>

--
Jani Averbach