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
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 |