This is a multipart message in MIME format.
--=_alternative 007FE77786256EED_=
Content-Type: text/plain; charset="US-ASCII"

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
--=_alternative 007FE77786256EED_=
Content-Type: text/html; charset="US-ASCII"


<br><font size=2 face="sans-serif">Hi,</font>
<br><font size=2 face="sans-serif">I created a new database in the win32
version of 8.0 beta1 and added some functions.</font>
<br><font size=2 face="sans-serif">I then did a pg_dump like so:</font>
<br><font size=2 face="sans-serif">C:\Program Files\PostgreSQL\8.0-beta1\bin&gt;pg_dump
--username=postgres --format=c</font>
<br><font size=2 face="sans-serif">&nbsp;--file=c:\testdb.bak testdb</font>
<br>
<br><font size=2 face="sans-serif">the backup is created successfully.</font>
<br>
<br><font size=2 face="sans-serif">I then try to restore with pg_restore
like this:</font>
<br>
<br><font size=2 face="sans-serif">and I get tons of errors (see below)</font>
<br>
<br><font size=2 face="sans-serif">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.</font>
<br>
<br><font size=2 face="sans-serif">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.</font>
<br><font size=2 face="sans-serif">as plain text all objects where created.</font>
<br>
<br>
<br><font size=2 face="sans-serif">pg_restore: [archiver (db)] could not
execute query: ERROR: &nbsp;schema &quot;admin&quot; does</font>
<br><font size=2 face="sans-serif">&nbsp;not exist</font>
<br><font size=2 face="sans-serif">ng, character varying) does not exist</font>
<br><font size=2 face="sans-serif">pg_restore: [archiver (db)] could not
execute query: ERROR: &nbsp;function spsys_user</font>
<br><font size=2 face="sans-serif">_insert(character varying, character
varying, character varying, character varyi</font>
<br><font size=2 face="sans-serif">ng, character varying) does not exist</font>
<br><font size=2 face="sans-serif">pg_restore: [archiver (db)] could not
execute query: ERROR: &nbsp;function spsys_user</font>
<br><font size=2 face="sans-serif">_logoff(integer) does not exist</font>
<br><font size=2 face="sans-serif">pg_restore: [archiver (db)] could not
execute query: ERROR: &nbsp;function spsys_user</font>
<br><font size=2 face="sans-serif">_logoff(integer) does not exist</font>
<br><font size=2 face="sans-serif">pg_restore: [archiver (db)] could not
execute query: ERROR: &nbsp;function spsys_user</font>
<br><font size=2 face="sans-serif">_logoff(integer) does not exist</font>
<br><font size=2 face="sans-serif">pg_restore: [archiver (db)] could not
execute query: ERROR: &nbsp;function spsys_user</font>
<br><font size=2 face="sans-serif">_logoff(integer) does not exist</font>
<br><font size=2 face="sans-serif">pg_restore: [archiver (db)] could not
execute query: ERROR: &nbsp;function spsys_user</font>
<br><font size=2 face="sans-serif">_logoff(integer) does not exist</font>
<br><font size=2 face="sans-serif">pg_restore: [archiver (db)] could not
execute query: ERROR: &nbsp;function spsys_user</font>
<br><font size=2 face="sans-serif">_logon(character varying, character
varying, integer, character varying, charact</font>
<br><font size=2 face="sans-serif">er varying) does not exist</font>
<br><font size=2 face="sans-serif">pg_restore: [archiver (db)] could not
execute query: ERROR: &nbsp;function spsys_user</font>
<br><font size=2 face="sans-serif">_logon(character varying, character
varying, integer, character varying, charact</font>
<br><font size=2 face="sans-serif">er varying) does not exist</font>
<br><font size=2 face="sans-serif">pg_restore: [archiver (db)] could not
execute query: ERROR: &nbsp;function spsys_user</font>
<br><font size=2 face="sans-serif">_logon(character varying, character
varying, integer, character varying, charact</font>
<br><font size=2 face="sans-serif">er varying) does not exist</font>
<br><font size=2 face="sans-serif">pg_restore: [archiver (db)] could not
execute query: ERROR: &nbsp;function spsys_user</font>
<br><font size=2 face="sans-serif">_logon(character varying, character
varying, integer, character varying, charact</font>
<br><font size=2 face="sans-serif">er varying) does not exist</font>
<br><font size=2 face="sans-serif">pg_restore: [archiver (db)] could not
execute query: ERROR: &nbsp;function spsys_user</font>
<br><font size=2 face="sans-serif">_logon(character varying, character
varying, integer, character varying, charact</font>
<br><font size=2 face="sans-serif">er varying) does not exist</font>
<br><font size=2 face="sans-serif">pg_restore: [archiver (db)] could not
execute query: ERROR: &nbsp;function spsys_user</font>
<br><font size=2 face="sans-serif">_password_change(integer, character
varying, character varying) does not exist</font>
<br><font size=2 face="sans-serif">pg_restore: [archiver (db)] could not
execute query: ERROR: &nbsp;function spsys_user</font>
<br><font size=2 face="sans-serif">_password_change(integer, character
varying, character varying) does not exist</font>
<br><font size=2 face="sans-serif">pg_restore: [archiver (db)] could not
execute query: ERROR: &nbsp;function spsys_user</font>
<br><font size=2 face="sans-serif">_password_change(integer, character
varying, character varying) does not exist</font>
<br><font size=2 face="sans-serif">pg_restore: [archiver (db)] could not
execute query: ERROR: &nbsp;function spsys_user</font>
<br><font size=2 face="sans-serif">_password_change(integer, character
varying, character varying) does not exist</font>
<br><font size=2 face="sans-serif">pg_restore: [archiver (db)] could not
execute query: ERROR: &nbsp;function spsys_user</font>
<br><font size=2 face="sans-serif">_password_change(integer, character
varying, character varying) does not exist</font>
<br><font size=2 face="sans-serif">pg_restore: [archiver (db)] could not
execute query: ERROR: &nbsp;function spsys_user</font>
<br><font size=2 face="sans-serif">_update(character varying, character
varying, character varying, character varyi</font>
<br><font size=2 face="sans-serif">ng, character varying, integer) does
not exist</font>
<br><font size=2 face="sans-serif">pg_restore: [archiver (db)] could not
execute query: ERROR: &nbsp;function spsys_user</font>
<br><font size=2 face="sans-serif">_update(character varying, character
varying, character varying, character varyi</font>
<br><font size=2 face="sans-serif">ng, character varying, integer) does
not exist</font>
<br><font size=2 face="sans-serif">pg_restore: [archiver (db)] could not
execute query: ERROR: &nbsp;function spsys_user</font>
<br><font size=2 face="sans-serif">_update(character varying, character
varying, character varying, character varyi</font>
<br><font size=2 face="sans-serif">ng, character varying, integer) does
not exist</font>
<br><font size=2 face="sans-serif">pg_restore: [archiver (db)] could not
execute query: ERROR: &nbsp;function spsys_user</font>
<br><font size=2 face="sans-serif">_update(character varying, character
varying, character varying, character varyi</font>
<br><font size=2 face="sans-serif">ng, character varying, integer) does
not exist</font>
<br><font size=2 face="sans-serif">pg_restore: [archiver (db)] could not
execute query: ERROR: &nbsp;function spsys_user</font>
<br><font size=2 face="sans-serif">_update(character varying, character
varying, character varying, character varyi</font>
<br><font size=2 face="sans-serif">ng, character varying, integer) does
not exist</font>
<br><font size=2 face="sans-serif">pg_restore: [archiver (db)] could not
execute query: ERROR: &nbsp;function spsys_user</font>
<br><font size=2 face="sans-serif">_update_gui_info(integer, integer, integer,
integer) does not exist</font>
<br><font size=2 face="sans-serif">pg_restore: [archiver (db)] could not
execute query: ERROR: &nbsp;function spsys_user</font>
<br><font size=2 face="sans-serif">_update_gui_info(integer, integer, integer,
integer) does not exist</font>
<br><font size=2 face="sans-serif">pg_restore: [archiver (db)] could not
execute query: ERROR: &nbsp;function spsys_user</font>
<br><font size=2 face="sans-serif">_update_gui_info(integer, integer, integer,
integer) does not exist</font>
<br><font size=2 face="sans-serif">pg_restore: [archiver (db)] could not
execute query: ERROR: &nbsp;function spsys_user</font>
<br><font size=2 face="sans-serif">_update_gui_info(integer, integer, integer,
integer) does not exist</font>
<br><font size=2 face="sans-serif">pg_restore: [archiver (db)] could not
execute query: ERROR: &nbsp;function spsys_user</font>
<br><font size=2 face="sans-serif">_update_gui_info(integer, integer, integer,
integer) does not exist</font>
<br><font size=2 face="sans-serif">--</font>
<br><font size=2 face="sans-serif">-- PostgreSQL database dump complete</font>
<br><font size=2 face="sans-serif">--</font>
<br>
<br><font size=2 face="sans-serif">WARNING, errors ignored on restore:
2790</font>
<br>
<br><font size=2 face="sans-serif">C:\Program Files\PostgreSQL\8.0-beta1\bin&gt;</font>
<br>
<br>
<br>
<br>
<br><font size=2 face="sans-serif"><br>
Tony Caduto<br>
Senior Programmer/Analyst<br>
M&amp;I Trust and Investment Management</font>
--=_alternative 007FE77786256EED_=--