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