pg_restore many errors - Mailing list pgsql-bugs

Hi,
I created a new database in the win32 version of 8.0 beta1 and added some
functions.
I then did a pg_dump like so:
C:\Program Files\PostgreSQL\8.0-beta1\bin>pg_dump --username=postgres
--format=c
 --file=c:\testdb.bak testdb

the backup is created successfully.

I then try to restore with pg_restore like this:

and I get tons of errors (see below)

I then go to the database in PGAdmin III and the only thing that is there
is the tables and types, no functions where restored.

I then did another dump, this time with --inserts and no compression and
pasted it into a Pgadmin III query window and it all worked fine.
as plain text all objects where created.


pg_restore: [archiver (db)] could not execute query: ERROR:  schema
"admin" does
 not exist
ng, character varying) does not exist
pg_restore: [archiver (db)] could not execute query: ERROR:  function
spsys_user
_insert(character varying, character varying, character varying, character
varyi
ng, character varying) does not exist
pg_restore: [archiver (db)] could not execute query: ERROR:  function
spsys_user
_logoff(integer) does not exist
pg_restore: [archiver (db)] could not execute query: ERROR:  function
spsys_user
_logoff(integer) does not exist
pg_restore: [archiver (db)] could not execute query: ERROR:  function
spsys_user
_logoff(integer) does not exist
pg_restore: [archiver (db)] could not execute query: ERROR:  function
spsys_user
_logoff(integer) does not exist
pg_restore: [archiver (db)] could not execute query: ERROR:  function
spsys_user
_logoff(integer) does not exist
pg_restore: [archiver (db)] could not execute query: ERROR:  function
spsys_user
_logon(character varying, character varying, integer, character varying,
charact
er varying) does not exist
pg_restore: [archiver (db)] could not execute query: ERROR:  function
spsys_user
_logon(character varying, character varying, integer, character varying,
charact
er varying) does not exist
pg_restore: [archiver (db)] could not execute query: ERROR:  function
spsys_user
_logon(character varying, character varying, integer, character varying,
charact
er varying) does not exist
pg_restore: [archiver (db)] could not execute query: ERROR:  function
spsys_user
_logon(character varying, character varying, integer, character varying,
charact
er varying) does not exist
pg_restore: [archiver (db)] could not execute query: ERROR:  function
spsys_user
_logon(character varying, character varying, integer, character varying,
charact
er varying) does not exist
pg_restore: [archiver (db)] could not execute query: ERROR:  function
spsys_user
_password_change(integer, character varying, character varying) does not
exist
pg_restore: [archiver (db)] could not execute query: ERROR:  function
spsys_user
_password_change(integer, character varying, character varying) does not
exist
pg_restore: [archiver (db)] could not execute query: ERROR:  function
spsys_user
_password_change(integer, character varying, character varying) does not
exist
pg_restore: [archiver (db)] could not execute query: ERROR:  function
spsys_user
_password_change(integer, character varying, character varying) does not
exist
pg_restore: [archiver (db)] could not execute query: ERROR:  function
spsys_user
_password_change(integer, character varying, character varying) does not
exist
pg_restore: [archiver (db)] could not execute query: ERROR:  function
spsys_user
_update(character varying, character varying, character varying, character
varyi
ng, character varying, integer) does not exist
pg_restore: [archiver (db)] could not execute query: ERROR:  function
spsys_user
_update(character varying, character varying, character varying, character
varyi
ng, character varying, integer) does not exist
pg_restore: [archiver (db)] could not execute query: ERROR:  function
spsys_user
_update(character varying, character varying, character varying, character
varyi
ng, character varying, integer) does not exist
pg_restore: [archiver (db)] could not execute query: ERROR:  function
spsys_user
_update(character varying, character varying, character varying, character
varyi
ng, character varying, integer) does not exist
pg_restore: [archiver (db)] could not execute query: ERROR:  function
spsys_user
_update(character varying, character varying, character varying, character
varyi
ng, character varying, integer) does not exist
pg_restore: [archiver (db)] could not execute query: ERROR:  function
spsys_user
_update_gui_info(integer, integer, integer, integer) does not exist
pg_restore: [archiver (db)] could not execute query: ERROR:  function
spsys_user
_update_gui_info(integer, integer, integer, integer) does not exist
pg_restore: [archiver (db)] could not execute query: ERROR:  function
spsys_user
_update_gui_info(integer, integer, integer, integer) does not exist
pg_restore: [archiver (db)] could not execute query: ERROR:  function
spsys_user
_update_gui_info(integer, integer, integer, integer) does not exist
pg_restore: [archiver (db)] could not execute query: ERROR:  function
spsys_user
_update_gui_info(integer, integer, integer, integer) does not exist
--
-- PostgreSQL database dump complete
--

WARNING, errors ignored on restore: 2790

C:\Program Files\PostgreSQL\8.0-beta1\bin>





Tony Caduto
Senior Programmer/Analyst
M&I Trust and Investment Management