pg_restore many errors

From: anthony(dot)caduto(at)micorp(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: pg_restore many errors
Date: 2004-08-11 23:16:27
Message-ID: OF4DA8D28A.6A6D93BF-ON86256EED.007F03F8-86256EED.007FE77A@micorp.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-bugs by date

  From Date Subject
Next Message PostgreSQL Bugs List 2004-08-12 00:08:36 BUG #1215: Call sql function from plpgsql results vary.
Previous Message Tom Lane 2004-08-11 22:51:59 Re: BUG #1214: ecpg regression in 8.0.0beta1