[SL] Errors restoring Database

[Stan W. <st...@ba...>]

Hi.

I'm using Sql-Ledger 2.8.8 and Postgres 8.1.9. Every night I do a =

database dump using the following command:

pg_dump dataset =96U username | gzip > filename.gz

Today I dropped my database then recreated it in Sql-Ledger Administration.

When I try to resore the database using to following:

psql dataset =96U username < input file name

I get the following errors:

[root@bacstx ~]# psql bayarea -U sql-ledger < bayareadb
SET
SET
SET
ERROR: must be owner of schema public
ERROR: must be superuser to create procedural language
SET
CREATE FUNCTION
ALTER FUNCTION
SET
SET
ERROR: relation "acc_trans" already exists
ALTER TABLE
ERROR: relation "addressid" already exists
ALTER TABLE
setval
--------
155
(1 row)

ERROR: relation "address" already exists
ALTER TABLE
ERROR: relation "id" already exists
ALTER TABLE
setval
--------
11054
(1 row)

ERROR: relation "ap" already exists
ALTER TABLE
ERROR: relation "ar" already exists
ALTER TABLE
ERROR: relation "assemblyid" already exists
ALTER TABLE
setval
--------
16
(1 row)..............
ERROR: duplicate key violates unique constraint "curr_pkey"
CONTEXT: COPY curr, line 1: "1 USD 2"
ERROR: multiple primary keys for table "address" are not allowed
ERROR: multiple primary keys for table "br" are not allowed
ERROR: multiple primary keys for table "contact" are not allowed
ERROR: multiple primary keys for table "curr" are not allowed
ERROR: multiple primary keys for table "customer" are not allowed
ERROR: multiple primary keys for table "paymentmethod" are not allowed
ERROR: multiple primary keys for table "vendor" are not allowed
ERROR: relation "acc_trans_chart_id_key" already exists
ERROR: relation "acc_trans_source_key" already exists
ERROR: relation "acc_trans_trans_id_key" already exists
ERROR: relation "acc_trans_transdate_key" already exists
ERROR: relation "ap_employee_id_key" already exists
ERROR: relation "ap_id_key" already exists
ERROR: relation "ap_invnumber_key" already exists
ERROR: relation "ap_ordnumber_key" already exists
ERROR: relation "ap_quonumber_key" already exists
ERROR: relation "ap_transdate_key" already exists
ERROR: relation "ap_vendor_id_key" already exists
ERROR: relation "ar_customer_id_key" already exists
ERROR: relation "ar_employee_id_key" already exists
ERROR: relation "ar_id_key" already exists
ERROR: relation "ar_invnumber_key" already exists
ERROR: relation "ar_ordnumber_key" already exists
ERROR: relation "ar_quonumber_key" already exists
ERROR: relation "ar_transdate_key" already exists
ERROR: relation "assembly_id_key" already exists
ERROR: relation "audittrail_trans_id_key" already exists
ERROR: relation "cargo_id_key" already exists
ERROR: relation "chart_accno_key" already exists
ERROR: relation "chart_category_key" already exists
ERROR: relation "chart_gifi_accno_key" already exists
ERROR: relation "chart_id_key" already exists
ERROR: relation "chart_link_key" already exists
ERROR: relation "customer_contact_key" already exists
ERROR: relation "customer_customer_id_key" already exists
ERROR: relation "customer_customernumber_key" already exists
ERROR: relation "customer_name_key" already exists
ERROR: relation "department_id_key" already exists
ERROR: relation "employee_id_key" already exists
ERROR: relation "employee_login_key" already exists
ERROR: relation "employee_name_key" already exists
ERROR: relation "exchangerate_ct_key" already exists
ERROR: relation "gifi_accno_key" already exists
ERROR: relation "gl_description_key" already exists
ERROR: relation "gl_employee_id_key" already exists
ERROR: relation "gl_id_key" already exists
ERROR: relation "gl_reference_key" already exists
ERROR: relation "gl_transdate_key" already exists
ERROR: relation "inventory_parts_id_key" already exists
ERROR: relation "invoice_id_key" already exists
ERROR: relation "invoice_trans_id_key" already exists
ERROR: relation "jcitems_id_key" already exists
ERROR: relation "language_code_key" already exists
ERROR: relation "makemodel_make_key" already exists
ERROR: relation "makemodel_model_key" already exists
ERROR: relation "makemodel_parts_id_key" already exists
ERROR: relation "oe_employee_id_key" already exists
ERROR: relation "oe_id_key" already exists
ERROR: relation "oe_ordnumber_key" already exists
ERROR: relation "oe_transdate_key" already exists
ERROR: relation "orderitems_trans_id_key" already exists
ERROR: relation "parts_description_key" already exists
ERROR: relation "parts_id_key" already exists
ERROR: relation "parts_partnumber_key" already exists
ERROR: relation "partscustomer_customer_id_key" already exists
ERROR: relation "partscustomer_parts_id_key" already exists
ERROR: relation "partsgroup_id_key" already exists
ERROR: relation "partsgroup_key" already exists
ERROR: relation "partstax_parts_id_key" already exists
ERROR: relation "partsvendor_parts_id_key" already exists
ERROR: relation "partsvendor_vendor_id_key" already exists
ERROR: relation "pricegroup_id_key" already exists
ERROR: relation "pricegroup_pricegroup_key" already exists
ERROR: relation "project_id_key" already exists
ERROR: relation "projectnumber_key" already exists
ERROR: relation "shipto_trans_id_key" already exists
ERROR: relation "status_trans_id_key" already exists
ERROR: relation "translation_trans_id_key" already exists
ERROR: relation "vendor_contact_key" already exists
ERROR: relation "vendor_name_key" already exists
ERROR: relation "vendor_vendornumber_key" already exists
ERROR: relation "vendortax_vendor_id_key" already exists
ERROR: constraint "vr_br_id_fkey" for relation "vr" already exists
WARNING: no privileges could be revoked
REVOKE
WARNING: no privileges could be revoked
REVOKE
WARNING: no privileges were granted
GRANT
WARNING: no privileges were granted
GRANT


Complete errors attached as a text file

Can anyone help?

Thanks,

Stan Williams


-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: dberrors.txt