Menu
▾
▴
Re: [SL] migrating to a new machine
|
From: RYAN M. v. G. <lu...@co...> - 2007-04-13 02:17:01
|
Sorry for the ridiculously long post but i have dont have much experience with databases in fact i used a gui to do the dump and restore seemed much easier. Here is a list of the outputs there are several errors and when i add stuff to sql-ledger it does not save anything.
Allows me to enter data just forgets everything.
D:\Program Files\pgAdmin III\1.6\pg_dump.exe -i -h computerking.ca -p 5432 -U pgsql -F c -b -o -v -f "D:\Documents and Settings\King\king.backup" computerking
pg_dump: reading schemas
pg_dump: reading user-defined functions
pg_dump: reading user-defined types
pg_dump: reading procedural languages
pg_dump: reading user-defined aggregate functions
pg_dump: reading user-defined operators
pg_dump: reading user-defined operator classes
pg_dump: reading user-defined operator families
pg_dump: reading user-defined conversions
pg_dump: reading user-defined tables
pg_dump: reading table inheritance information
pg_dump: reading rewrite rules
pg_dump: reading type casts
pg_dump: finding inheritance relationships
pg_dump: reading column info for interesting tables
pg_dump: finding the columns and types of table "makemodel"
pg_dump: finding the columns and types of table "gl"
pg_dump: finding default expressions of table "gl"
pg_dump: finding the columns and types of table "chart"
pg_dump: finding default expressions of table "chart"
pg_dump: finding the columns and types of table "gifi"
pg_dump: finding the columns and types of table "defaults"
pg_dump: finding default expressions of table "defaults"
pg_dump: finding the columns and types of table "acc_trans"
pg_dump: finding default expressions of table "acc_trans"
pg_dump: finding the columns and types of table "invoice"
pg_dump: finding default expressions of table "invoice"
pg_dump: finding the columns and types of table "customer"
pg_dump: finding default expressions of table "customer"
pg_dump: finding the columns and types of table "parts"
pg_dump: finding default expressions of table "parts"
pg_dump: finding the columns and types of table "assembly"
pg_dump: finding the columns and types of table "ar"
pg_dump: finding default expressions of table "ar"
pg_dump: finding the columns and types of table "ap"
pg_dump: finding default expressions of table "ap"
pg_dump: finding the columns and types of table "partstax"
pg_dump: finding the columns and types of table "tax"
pg_dump: finding the columns and types of table "customertax"
pg_dump: finding the columns and types of table "vendortax"
pg_dump: finding the columns and types of table "oe"
pg_dump: finding default expressions of table "oe"
pg_dump: finding the columns and types of table "orderitems"
pg_dump: finding default expressions of table "orderitems"
pg_dump: finding the columns and types of table "exchangerate"
pg_dump: finding the columns and types of table "employee"
pg_dump: finding default expressions of table "employee"
pg_dump: finding the columns and types of table "shipto"
pg_dump: finding the columns and types of table "vendor"
pg_dump: finding default expressions of table "vendor"
pg_dump: finding the columns and types of table "project"
pg_dump: finding default expressions of table "project"
pg_dump: finding the columns and types of table "partsgroup"
pg_dump: finding default expressions of table "partsgroup"
pg_dump: finding the columns and types of table "status"
pg_dump: finding default expressions of table "status"
pg_dump: finding the columns and types of table "department"
pg_dump: finding default expressions of table "department"
pg_dump: finding the columns and types of table "dpt_trans"
pg_dump: finding the columns and types of table "business"
pg_dump: finding default expressions of table "business"
pg_dump: finding the columns and types of table "sic"
pg_dump: finding the columns and types of table "warehouse"
pg_dump: finding default expressions of table "warehouse"
pg_dump: finding the columns and types of table "inventory"
pg_dump: finding the columns and types of table "yearend"
pg_dump: finding the columns and types of table "partsvendor"
pg_dump: finding the columns and types of table "pricegroup"
pg_dump: finding default expressions of table "pricegroup"
pg_dump: finding the columns and types of table "partscustomer"
pg_dump: finding the columns and types of table "language"
pg_dump: finding the columns and types of table "audittrail"
pg_dump: finding default expressions of table "audittrail"
pg_dump: finding the columns and types of table "translation"
pg_dump: finding the columns and types of table "recurring"
pg_dump: finding default expressions of table "recurring"
pg_dump: finding the columns and types of table "recurringemail"
pg_dump: finding the columns and types of table "recurringprint"
pg_dump: finding the columns and types of table "jcitems"
pg_dump: finding default expressions of table "jcitems"
pg_dump: flagging inherited columns in subtables
pg_dump: reading indexes
pg_dump: reading indexes for table "makemodel"
pg_dump: reading indexes for table "gl"
pg_dump: reading indexes for table "chart"
pg_dump: reading indexes for table "gifi"
pg_dump: reading indexes for table "acc_trans"
pg_dump: reading indexes for table "invoice"
pg_dump: reading indexes for table "customer"
pg_dump: reading indexes for table "parts"
pg_dump: reading indexes for table "assembly"
pg_dump: reading indexes for table "ar"
pg_dump: reading indexes for table "ap"
pg_dump: reading indexes for table "partstax"
pg_dump: reading indexes for table "customertax"
pg_dump: reading indexes for table "vendortax"
pg_dump: reading indexes for table "oe"
pg_dump: reading indexes for table "orderitems"
pg_dump: reading indexes for table "exchangerate"
pg_dump: reading indexes for table "employee"
pg_dump: reading indexes for table "shipto"
pg_dump: reading indexes for table "vendor"
pg_dump: reading indexes for table "project"
pg_dump: reading indexes for table "partsgroup"
pg_dump: reading indexes for table "status"
pg_dump: reading indexes for table "department"
pg_dump: reading indexes for table "partsvendor"
pg_dump: reading indexes for table "pricegroup"
pg_dump: reading indexes for table "language"
pg_dump: reading indexes for table "audittrail"
pg_dump: reading indexes for table "translation"
pg_dump: reading indexes for table "jcitems"
pg_dump: reading constraints
pg_dump: reading foreign key constraints for table "gl"
pg_dump: reading foreign key constraints for table "customer"
pg_dump: reading foreign key constraints for table "ar"
pg_dump: reading foreign key constraints for table "ap"
pg_dump: reading foreign key constraints for table "oe"
pg_dump: reading foreign key constraints for table "vendor"
pg_dump: reading triggers
pg_dump: reading triggers for table "gl"
pg_dump: reading triggers for table "customer"
pg_dump: reading triggers for table "ar"
pg_dump: reading triggers for table "ap"
pg_dump: reading triggers for table "oe"
pg_dump: reading triggers for table "vendor"
pg_dump: reading dependency data
pg_dump: saving encoding = SQL_ASCII
pg_dump: saving standard_conforming_strings = off
pg_dump: saving database definition
pg_dump: dumping contents of table acc_trans
pg_dump: dumping contents of table ap
pg_dump: dumping contents of table ar
pg_dump: dumping contents of table assembly
pg_dump: dumping contents of table audittrail
pg_dump: dumping contents of table business
pg_dump: dumping contents of table chart
pg_dump: dumping contents of table customer
pg_dump: dumping contents of table customertax
pg_dump: dumping contents of table defaults
pg_dump: dumping contents of table department
pg_dump: dumping contents of table dpt_trans
pg_dump: dumping contents of table employee
pg_dump: dumping contents of table exchangerate
pg_dump: dumping contents of table gifi
pg_dump: dumping contents of table gl
pg_dump: dumping contents of table inventory
pg_dump: dumping contents of table invoice
pg_dump: dumping contents of table jcitems
pg_dump: dumping contents of table language
pg_dump: dumping contents of table makemodel
pg_dump: dumping contents of table oe
pg_dump: dumping contents of table orderitems
pg_dump: dumping contents of table parts
pg_dump: dumping contents of table partscustomer
pg_dump: dumping contents of table partsgroup
pg_dump: dumping contents of table partstax
pg_dump: dumping contents of table partsvendor
pg_dump: dumping contents of table pricegroup
pg_dump: dumping contents of table project
pg_dump: dumping contents of table recurring
pg_dump: dumping contents of table recurringemail
pg_dump: dumping contents of table recurringprint
pg_dump: dumping contents of table shipto
pg_dump: dumping contents of table sic
pg_dump: dumping contents of table status
pg_dump: dumping contents of table tax
pg_dump: dumping contents of table translation
pg_dump: dumping contents of table vendor
pg_dump: dumping contents of table vendortax
pg_dump: dumping contents of table warehouse
pg_dump: dumping contents of table yearend
Process returned exit code 0.
D:\Program Files\pgAdmin III\1.6\pg_restore.exe -i -h 192.168.0.23 -p 5432 -U pgsql -d king1 -v "D:\Documents and Settings\King\king.backup"
pg_restore: connecting to database for restore
pg_restore: [archiver (db)] Error while INITIALIZING:
pg_restore: [archiver (db)] could not execute query: ERROR: unrecognized configuration parameter "standard_conforming_strings"
Command was: SET standard_conforming_strings = off;
pg_restore: [archiver (db)] could not execute query: ERROR: unrecognized configuration parameter "escape_string_warning"
Command was: SET escape_string_warning = off;
pg_restore: creating SCHEMA public
pg_restore: creating COMMENT SCHEMA public
pg_restore: creating FUNCTION plpgsql_call_handler()
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 9; 1255 18172 FUNCTION plpgsql_call_handler() rmvg
pg_restore: [archiver (db)] could not execute query: ERROR: function "plpgsql_call_handler" already exists with same argument types
Command was: CREATE FUNCTION plpgsql_call_handler() RETURNS language_handler
AS '$libdir/plpgsql', 'plpgsql_call_handler'
LANGUAG...
pg_restore: [archiver (db)] could not execute query: ERROR: syntax error at or near "OWNER"
LINE 1: ALTER FUNCTION public.plpgsql_call_handler() OWNER TO rmvg;
^
Command was: ALTER FUNCTION public.plpgsql_call_handler() OWNER TO rmvg;
pg_restore: creating PROCEDURAL LANGUAGE plpgsql
pg_restore: [archiver (db)] Error from TOC entry 322; 16402 18173 PROCEDURAL LANGUAGE plpgsql pgsql
pg_restore: [archiver (db)] could not execute query: ERROR: language "plpgsql" already exists
Command was: CREATE TRUSTED PROCEDURAL LANGUAGE plpgsql HANDLER plpgsql_call_handler;
pg_restore: creating FUNCTION avgcost(integer)
pg_restore: [archiver (db)] Error from TOC entry 18; 1255 22758 FUNCTION avgcost(integer) sql-ledger
pg_restore: [archiver (db)] could not execute query: ERROR: syntax error at or near "$"
LINE 2: AS $_$
^
Command was: CREATE FUNCTION avgcost(integer) RETURNS double precision
AS $_$
DECLARE
v_cost float;
v_qty float;
v_parts_id alias for...
pg_restore: [archiver (db)] could not execute query: ERROR: syntax error at or near "OWNER"
LINE 1: ALTER FUNCTION public.avgcost(integer) OWNER TO "sql-ledger"...
^
Command was: ALTER FUNCTION public.avgcost(integer) OWNER TO "sql-ledger";
pg_restore: creating FUNCTION check_department()
pg_restore: [archiver (db)] Error from TOC entry 16; 1255 22749 FUNCTION check_department() sql-ledger
pg_restore: [archiver (db)] could not execute query: ERROR: syntax error at or near "$"
LINE 2: AS $$
^
Command was: CREATE FUNCTION check_department() RETURNS "trigger"
AS $$
declare
dpt_id int;
begin
if new.department_id = 0 then
...
pg_restore: [archiver (db)] could not execute query: ERROR: syntax error at or near "OWNER"
LINE 1: ALTER FUNCTION public.check_department() OWNER TO "sql-ledge...
^
Command was: ALTER FUNCTION public.check_department() OWNER TO "sql-ledger";
pg_restore: creating FUNCTION check_inventory()
pg_restore: [archiver (db)] Error from TOC entry 15; 1255 22747 FUNCTION check_inventory() sql-ledger
pg_restore: [archiver (db)] could not execute query: ERROR: syntax error at or near "$"
LINE 2: AS $$
^
Command was: CREATE FUNCTION check_inventory() RETURNS "trigger"
AS $$
declare
itemid int;
row_data inventory%rowtype;
begin
if...
pg_restore: [archiver (db)] could not execute query: ERROR: syntax error at or near "OWNER"
LINE 1: ALTER FUNCTION public.check_inventory() OWNER TO "sql-ledger...
^
Command was: ALTER FUNCTION public.check_inventory() OWNER TO "sql-ledger";
pg_restore: creating FUNCTION del_customer()
pg_restore: [archiver (db)] Error from TOC entry 12; 1255 22739 FUNCTION del_customer() sql-ledger
pg_restore: [archiver (db)] could not execute query: ERROR: syntax error at or near "$"
LINE 2: AS $$
^
Command was: CREATE FUNCTION del_customer() RETURNS "trigger"
AS $$
begin
delete from shipto where trans_id = old.id;
delete from...
pg_restore: [archiver (db)] could not execute query: ERROR: syntax error at or near "OWNER"
LINE 1: ALTER FUNCTION public.del_customer() OWNER TO "sql-ledger";
^
Command was: ALTER FUNCTION public.del_customer() OWNER TO "sql-ledger";
pg_restore: creating FUNCTION del_department()
pg_restore: [archiver (db)] Error from TOC entry 11; 1255 22734 FUNCTION del_department() sql-ledger
pg_restore: [archiver (db)] could not execute query: ERROR: syntax error at or near "$"
LINE 2: AS $$
^
Command was: CREATE FUNCTION del_department() RETURNS "trigger"
AS $$
begin
delete from dpt_trans where trans_id = old.id;
return...
pg_restore: [archiver (db)] could not execute query: ERROR: syntax error at or near "OWNER"
LINE 1: ALTER FUNCTION public.del_department() OWNER TO "sql-ledger"...
^
Command was: ALTER FUNCTION public.del_department() OWNER TO "sql-ledger";
pg_restore: creating FUNCTION del_exchangerate()
pg_restore: [archiver (db)] Error from TOC entry 14; 1255 22743 FUNCTION del_exchangerate() sql-ledger
pg_restore: [archiver (db)] could not execute query: ERROR: syntax error at or near "$"
LINE 2: AS $$
^
Command was: CREATE FUNCTION del_exchangerate() RETURNS "trigger"
AS $$
declare
t_transdate date;
t_curr char(3);
t_id int;
d...
pg_restore: [archiver (db)] could not execute query: ERROR: syntax error at or near "OWNER"
LINE 1: ALTER FUNCTION public.del_exchangerate() OWNER TO "sql-ledge...
^
Command was: ALTER FUNCTION public.del_exchangerate() OWNER TO "sql-ledger";
pg_restore: creating FUNCTION del_recurring()
pg_restore: [archiver (db)] Error from TOC entry 17; 1255 22754 FUNCTION del_recurring() sql-ledger
pg_restore: [archiver (db)] could not execute query: ERROR: syntax error at or near "$"
LINE 2: AS $$
^
Command was: CREATE FUNCTION del_recurring() RETURNS "trigger"
AS $$
BEGIN
DELETE FROM recurring WHERE id = old.id;
DELETE FROM r...
pg_restore: [archiver (db)] could not execute query: ERROR: syntax error at or near "OWNER"
LINE 1: ALTER FUNCTION public.del_recurring() OWNER TO "sql-ledger";
^
Command was: ALTER FUNCTION public.del_recurring() OWNER TO "sql-ledger";
pg_restore: creating FUNCTION del_vendor()
pg_restore: [archiver (db)] Error from TOC entry 13; 1255 22741 FUNCTION del_vendor() sql-ledger
pg_restore: [archiver (db)] could not execute query: ERROR: syntax error at or near "$"
LINE 2: AS $$
^
Command was: CREATE FUNCTION del_vendor() RETURNS "trigger"
AS $$
begin
delete from shipto where trans_id = old.id;
delete from v...
pg_restore: [archiver (db)] could not execute query: ERROR: syntax error at or near "OWNER"
LINE 1: ALTER FUNCTION public.del_vendor() OWNER TO "sql-ledger";
^
Command was: ALTER FUNCTION public.del_vendor() OWNER TO "sql-ledger";
pg_restore: creating FUNCTION del_yearend()
pg_restore: [archiver (db)] Error from TOC entry 10; 1255 22732 FUNCTION del_yearend() sql-ledger
pg_restore: [archiver (db)] could not execute query: ERROR: syntax error at or near "$"
LINE 2: AS $$
^
Command was: CREATE FUNCTION del_yearend() RETURNS "trigger"
AS $$
begin
delete from yearend where trans_id = old.id;
return NULL...
pg_restore: [archiver (db)] could not execute query: ERROR: syntax error at or near "OWNER"
LINE 1: ALTER FUNCTION public.del_yearend() OWNER TO "sql-ledger";
^
Command was: ALTER FUNCTION public.del_yearend() OWNER TO "sql-ledger";
pg_restore: creating FUNCTION lastcost(integer)
pg_restore: [archiver (db)] Error from TOC entry 19; 1255 22759 FUNCTION lastcost(integer) sql-ledger
pg_restore: [archiver (db)] could not execute query: ERROR: syntax error at or near "$"
LINE 2: AS $_$
^
Command was: CREATE FUNCTION lastcost(integer) RETURNS double precision
AS $_$
DECLARE
v_cost float;
v_parts_id alias for $1;
BEGIN
...
pg_restore: [archiver (db)] could not execute query: ERROR: syntax error at or near "OWNER"
LINE 1: ALTER FUNCTION public.lastcost(integer) OWNER TO "sql-ledger...
^
Command was: ALTER FUNCTION public.lastcost(integer) OWNER TO "sql-ledger";
pg_restore: creating TABLE acc_trans
pg_restore: [archiver] Error from TOC entry 1213; 1259 22518 TABLE acc_trans sql-ledger
pg_restore: [archiver] could not set default_tablespace to "": ERROR: unrecognized configuration parameter "default_tablespace"
pg_restore: [archiver] could not set default_with_oids: ERROR: unrecognized configuration parameter "default_with_oids"
pg_restore: creating TABLE ap
pg_restore: creating TABLE ar
pg_restore: creating TABLE assembly
pg_restore: creating TABLE audittrail
pg_restore: creating TABLE business
pg_restore: creating TABLE chart
pg_restore: creating TABLE customer
pg_restore: creating TABLE customertax
pg_restore: creating TABLE defaults
pg_restore: creating TABLE department
pg_restore: creating TABLE dpt_trans
pg_restore: creating TABLE employee
pg_restore: creating TABLE exchangerate
pg_restore: creating TABLE gifi
pg_restore: creating TABLE gl
pg_restore: creating SEQUENCE id
pg_restore: executing SEQUENCE SET id
pg_restore: creating TABLE inventory
pg_restore: creating TABLE invoice
pg_restore: creating SEQUENCE invoiceid
pg_restore: executing SEQUENCE SET invoiceid
pg_restore: creating TABLE jcitems
pg_restore: creating SEQUENCE jcitemsid
pg_restore: executing SEQUENCE SET jcitemsid
pg_restore: creating TABLE language
pg_restore: creating TABLE makemodel
pg_restore: creating TABLE oe
pg_restore: creating TABLE orderitems
pg_restore: creating SEQUENCE orderitemsid
pg_restore: executing SEQUENCE SET orderitemsid
pg_restore: creating TABLE parts
pg_restore: creating TABLE partscustomer
pg_restore: creating TABLE partsgroup
pg_restore: creating TABLE partstax
pg_restore: creating TABLE partsvendor
pg_restore: creating TABLE pricegroup
pg_restore: creating TABLE project
pg_restore: creating TABLE recurring
pg_restore: creating TABLE recurringemail
pg_restore: creating TABLE recurringprint
pg_restore: creating TABLE shipto
pg_restore: creating TABLE sic
pg_restore: creating TABLE status
pg_restore: creating TABLE tax
pg_restore: creating TABLE translation
pg_restore: creating TABLE vendor
pg_restore: creating TABLE vendortax
pg_restore: creating TABLE warehouse
pg_restore: creating TABLE yearend
pg_restore: restoring data for table "acc_trans"
pg_restore: restoring data for table "ap"
pg_restore: restoring data for table "ar"
pg_restore: restoring data for table "assembly"
pg_restore: restoring data for table "audittrail"
pg_restore: restoring data for table "business"
pg_restore: restoring data for table "chart"
pg_restore: restoring data for table "customer"
pg_restore: restoring data for table "customertax"
pg_restore: restoring data for table "defaults"
pg_restore: restoring data for table "department"
pg_restore: restoring data for table "dpt_trans"
pg_restore: restoring data for table "employee"
pg_restore: restoring data for table "exchangerate"
pg_restore: restoring data for table "gifi"
pg_restore: restoring data for table "gl"
pg_restore: restoring data for table "inventory"
pg_restore: restoring data for table "invoice"
pg_restore: restoring data for table "jcitems"
pg_restore: restoring data for table "language"
pg_restore: restoring data for table "makemodel"
pg_restore: restoring data for table "oe"
pg_restore: restoring data for table "orderitems"
pg_restore: restoring data for table "parts"
pg_restore: restoring data for table "partscustomer"
pg_restore: restoring data for table "partsgroup"
pg_restore: restoring data for table "partstax"
pg_restore: restoring data for table "partsvendor"
pg_restore: restoring data for table "pricegroup"
pg_restore: restoring data for table "project"
pg_restore: restoring data for table "recurring"
pg_restore: restoring data for table "recurringemail"
pg_restore: restoring data for table "recurringprint"
pg_restore: restoring data for table "shipto"
pg_restore: restoring data for table "sic"
pg_restore: restoring data for table "status"
pg_restore: restoring data for table "tax"
pg_restore: restoring data for table "translation"
pg_restore: restoring data for table "vendor"
pg_restore: restoring data for table "vendortax"
pg_restore: restoring data for table "warehouse"
pg_restore: restoring data for table "yearend"
pg_restore: creating INDEX acc_trans_chart_id_key
pg_restore: creating INDEX acc_trans_source_key
pg_restore: creating INDEX acc_trans_trans_id_key
pg_restore: creating INDEX acc_trans_transdate_key
pg_restore: creating INDEX ap_employee_id_key
pg_restore: creating INDEX ap_id_key
pg_restore: creating INDEX ap_invnumber_key
pg_restore: creating INDEX ap_ordnumber_key
pg_restore: creating INDEX ap_quonumber_key
pg_restore: creating INDEX ap_transdate_key
pg_restore: creating INDEX ap_vendor_id_key
pg_restore: creating INDEX ar_customer_id_key
pg_restore: creating INDEX ar_employee_id_key
pg_restore: creating INDEX ar_id_key
pg_restore: creating INDEX ar_invnumber_key
pg_restore: creating INDEX ar_ordnumber_key
pg_restore: creating INDEX ar_quonumber_key
pg_restore: creating INDEX ar_transdate_key
pg_restore: creating INDEX assembly_id_key
pg_restore: creating INDEX audittrail_trans_id_key
pg_restore: creating INDEX chart_accno_key
pg_restore: creating INDEX chart_category_key
pg_restore: creating INDEX chart_gifi_accno_key
pg_restore: creating INDEX chart_id_key
pg_restore: creating INDEX chart_link_key
pg_restore: creating INDEX customer_contact_key
pg_restore: creating INDEX customer_customer_id_key
pg_restore: creating INDEX customer_customernumber_key
pg_restore: creating INDEX customer_id_key
pg_restore: creating INDEX customer_name_key
pg_restore: creating INDEX department_id_key
pg_restore: creating INDEX employee_id_key
pg_restore: creating INDEX employee_login_key
pg_restore: creating INDEX employee_name_key
pg_restore: creating INDEX exchangerate_ct_key
pg_restore: creating INDEX gifi_accno_key
pg_restore: creating INDEX gl_description_key
pg_restore: creating INDEX gl_employee_id_key
pg_restore: creating INDEX gl_id_key
pg_restore: creating INDEX gl_reference_key
pg_restore: creating INDEX gl_transdate_key
pg_restore: creating INDEX invoice_id_key
pg_restore: creating INDEX invoice_trans_id_key
pg_restore: creating INDEX jcitems_id_key
pg_restore: creating INDEX language_code_key
pg_restore: creating INDEX makemodel_make_key
pg_restore: creating INDEX makemodel_model_key
pg_restore: creating INDEX makemodel_parts_id_key
pg_restore: creating INDEX oe_employee_id_key
pg_restore: creating INDEX oe_id_key
pg_restore: creating INDEX oe_ordnumber_key
pg_restore: creating INDEX oe_transdate_key
pg_restore: creating INDEX orderitems_id_key
pg_restore: creating INDEX orderitems_trans_id_key
pg_restore: creating INDEX parts_description_key
pg_restore: creating INDEX parts_id_key
pg_restore: creating INDEX parts_partnumber_key
pg_restore: creating INDEX partsgroup_id_key
pg_restore: creating INDEX partsgroup_key
pg_restore: creating INDEX partstax_parts_id_key
pg_restore: creating INDEX partsvendor_parts_id_key
pg_restore: creating INDEX partsvendor_vendor_id_key
pg_restore: creating INDEX pricegroup_id_key
pg_restore: creating INDEX pricegroup_pricegroup_key
pg_restore: creating INDEX project_id_key
pg_restore: creating INDEX projectnumber_key
pg_restore: creating INDEX shipto_trans_id_key
pg_restore: creating INDEX status_trans_id_key
pg_restore: creating INDEX translation_trans_id_key
pg_restore: creating INDEX vendor_contact_key
pg_restore: creating INDEX vendor_id_key
pg_restore: creating INDEX vendor_name_key
pg_restore: creating INDEX vendor_vendornumber_key
pg_restore: creating INDEX vendortax_vendor_id_key
pg_restore: creating TRIGGER check_department
pg_restore: [archiver (db)] Error from TOC entry 1629; 16412 22750 TRIGGER check_department sql-ledger
pg_restore: [archiver (db)] could not execute query: ERROR: function check_department() does not exist
Command was: CREATE TRIGGER check_department
AFTER INSERT OR UPDATE ON ar
FOR EACH ROW
EXECUTE PROCEDURE check_department();
pg_restore: creating TRIGGER check_department
pg_restore: [archiver (db)] Error from TOC entry 1633; 16412 22751 TRIGGER check_department sql-ledger
pg_restore: [archiver (db)] could not execute query: ERROR: function check_department() does not exist
Command was: CREATE TRIGGER check_department
AFTER INSERT OR UPDATE ON ap
FOR EACH ROW
EXECUTE PROCEDURE check_department();
pg_restore: creating TRIGGER check_department
pg_restore: [archiver (db)] Error from TOC entry 1624; 16412 22752 TRIGGER check_department sql-ledger
pg_restore: [archiver (db)] could not execute query: ERROR: function check_department() does not exist
Command was: CREATE TRIGGER check_department
AFTER INSERT OR UPDATE ON gl
FOR EACH ROW
EXECUTE PROCEDURE check_department();
pg_restore: creating TRIGGER check_department
pg_restore: [archiver (db)] Error from TOC entry 1637; 16412 22753 TRIGGER check_department sql-ledger
pg_restore: [archiver (db)] could not execute query: ERROR: function check_department() does not exist
Command was: CREATE TRIGGER check_department
AFTER INSERT OR UPDATE ON oe
FOR EACH ROW
EXECUTE PROCEDURE check_department();
pg_restore: creating TRIGGER check_inventory
pg_restore: [archiver (db)] Error from TOC entry 1638; 16412 22748 TRIGGER check_inventory sql-ledger
pg_restore: [archiver (db)] could not execute query: ERROR: function check_inventory() does not exist
Command was: CREATE TRIGGER check_inventory
AFTER UPDATE ON oe
FOR EACH ROW
EXECUTE PROCEDURE check_inventory();
pg_restore: creating TRIGGER del_customer
pg_restore: [archiver (db)] Error from TOC entry 1628; 16412 22740 TRIGGER del_customer sql-ledger
pg_restore: [archiver (db)] could not execute query: ERROR: function del_customer() does not exist
Command was: CREATE TRIGGER del_customer
AFTER DELETE ON customer
FOR EACH ROW
EXECUTE PROCEDURE del_customer();
pg_restore: creating TRIGGER del_department
pg_restore: [archiver (db)] Error from TOC entry 1630; 16412 22735 TRIGGER del_department sql-ledger
pg_restore: [archiver (db)] could not execute query: ERROR: function del_department() does not exist
Command was: CREATE TRIGGER del_department
AFTER DELETE ON ar
FOR EACH ROW
EXECUTE PROCEDURE del_department();
pg_restore: creating TRIGGER del_department
pg_restore: [archiver (db)] Error from TOC entry 1634; 16412 22736 TRIGGER del_department sql-ledger
pg_restore: [archiver (db)] could not execute query: ERROR: function del_department() does not exist
Command was: CREATE TRIGGER del_department
AFTER DELETE ON ap
FOR EACH ROW
EXECUTE PROCEDURE del_department();
pg_restore: creating TRIGGER del_department
pg_restore: [archiver (db)] Error from TOC entry 1625; 16412 22737 TRIGGER del_department sql-ledger
pg_restore: [archiver (db)] could not execute query: ERROR: function del_department() does not exist
Command was: CREATE TRIGGER del_department
AFTER DELETE ON gl
FOR EACH ROW
EXECUTE PROCEDURE del_department();
pg_restore: creating TRIGGER del_department
pg_restore: [archiver (db)] Error from TOC entry 1639; 16412 22738 TRIGGER del_department sql-ledger
pg_restore: [archiver (db)] could not execute query: ERROR: function del_department() does not exist
Command was: CREATE TRIGGER del_department
AFTER DELETE ON oe
FOR EACH ROW
EXECUTE PROCEDURE del_department();
pg_restore: creating TRIGGER del_exchangerate
pg_restore: [archiver (db)] Error from TOC entry 1631; 16412 22744 TRIGGER del_exchangerate sql-ledger
pg_restore: [archiver (db)] could not execute query: ERROR: function del_exchangerate() does not exist
Command was: CREATE TRIGGER del_exchangerate
BEFORE DELETE ON ar
FOR EACH ROW
EXECUTE PROCEDURE del_exchangerate();
pg_restore: creating TRIGGER del_exchangerate
pg_restore: [archiver (db)] Error from TOC entry 1635; 16412 22745 TRIGGER del_exchangerate sql-ledger
pg_restore: [archiver (db)] could not execute query: ERROR: function del_exchangerate() does not exist
Command was: CREATE TRIGGER del_exchangerate
BEFORE DELETE ON ap
FOR EACH ROW
EXECUTE PROCEDURE del_exchangerate();
pg_restore: creating TRIGGER del_exchangerate
pg_restore: [archiver (db)] Error from TOC entry 1640; 16412 22746 TRIGGER del_exchangerate sql-ledger
pg_restore: [archiver (db)] could not execute query: ERROR: function del_exchangerate() does not exist
Command was: CREATE TRIGGER del_exchangerate
BEFORE DELETE ON oe
FOR EACH ROW
EXECUTE PROCEDURE del_exchangerate();
pg_restore: creating TRIGGER del_recurring
pg_restore: [archiver (db)] Error from TOC entry 1632; 16412 22755 TRIGGER del_recurring sql-ledger
pg_restore: [archiver (db)] could not execute query: ERROR: function del_recurring() does not exist
Command was: CREATE TRIGGER del_recurring
AFTER DELETE ON ar
FOR EACH ROW
EXECUTE PROCEDURE del_recurring();
pg_restore: creating TRIGGER del_recurring
pg_restore: [archiver (db)] Error from TOC entry 1636; 16412 22756 TRIGGER del_recurring sql-ledger
pg_restore: [archiver (db)] could not execute query: ERROR: function del_recurring() does not exist
Command was: CREATE TRIGGER del_recurring
AFTER DELETE ON ap
FOR EACH ROW
EXECUTE PROCEDURE del_recurring();
pg_restore: creating TRIGGER del_recurring
pg_restore: [archiver (db)] Error from TOC entry 1626; 16412 22757 TRIGGER del_recurring sql-ledger
pg_restore: [archiver (db)] could not execute query: ERROR: function del_recurring() does not exist
Command was: CREATE TRIGGER del_recurring
AFTER DELETE ON gl
FOR EACH ROW
EXECUTE PROCEDURE del_recurring();
pg_restore: creating TRIGGER del_vendor
pg_restore: [archiver (db)] Error from TOC entry 1641; 16412 22742 TRIGGER del_vendor sql-ledger
pg_restore: [archiver (db)] could not execute query: ERROR: function del_vendor() does not exist
Command was: CREATE TRIGGER del_vendor
AFTER DELETE ON vendor
FOR EACH ROW
EXECUTE PROCEDURE del_vendor();
pg_restore: creating TRIGGER del_yearend
pg_restore: [archiver (db)] Error from TOC entry 1627; 16412 22733 TRIGGER del_yearend sql-ledger
pg_restore: [archiver (db)] could not execute query: ERROR: function del_yearend() does not exist
Command was: CREATE TRIGGER del_yearend
AFTER DELETE ON gl
FOR EACH ROW
EXECUTE PROCEDURE del_yearend();
pg_restore: setting owner and privileges for SCHEMA public
pg_restore: setting owner and privileges for COMMENT SCHEMA public
pg_restore: setting owner and privileges for ACL public
pg_restore: setting owner and privileges for FUNCTION plpgsql_call_handler()
pg_restore: setting owner and privileges for PROCEDURAL LANGUAGE plpgsql
pg_restore: setting owner and privileges for FUNCTION avgcost(integer)
pg_restore: setting owner and privileges for FUNCTION check_department()
pg_restore: setting owner and privileges for FUNCTION check_inventory()
pg_restore: setting owner and privileges for FUNCTION del_customer()
pg_restore: setting owner and privileges for FUNCTION del_department()
pg_restore: setting owner and privileges for FUNCTION del_exchangerate()
pg_restore: setting owner and privileges for FUNCTION del_recurring()
pg_restore: setting owner and privileges for FUNCTION del_vendor()
pg_restore: setting owner and privileges for FUNCTION del_yearend()
pg_restore: setting owner and privileges for FUNCTION lastcost(integer)
pg_restore: setting owner and privileges for TABLE acc_trans
pg_restore: setting owner and privileges for TABLE ap
pg_restore: setting owner and privileges for TABLE ar
pg_restore: setting owner and privileges for TABLE assembly
pg_restore: setting owner and privileges for TABLE audittrail
pg_restore: setting owner and privileges for TABLE business
pg_restore: setting owner and privileges for TABLE chart
pg_restore: setting owner and privileges for TABLE customer
pg_restore: setting owner and privileges for TABLE customertax
pg_restore: setting owner and privileges for TABLE defaults
pg_restore: setting owner and privileges for TABLE department
pg_restore: setting owner and privileges for TABLE dpt_trans
pg_restore: setting owner and privileges for TABLE employee
pg_restore: setting owner and privileges for TABLE exchangerate
pg_restore: setting owner and privileges for TABLE gifi
pg_restore: setting owner and privileges for TABLE gl
pg_restore: setting owner and privileges for SEQUENCE id
pg_restore: setting owner and privileges for TABLE inventory
pg_restore: setting owner and privileges for TABLE invoice
pg_restore: setting owner and privileges for SEQUENCE invoiceid
pg_restore: setting owner and privileges for TABLE jcitems
pg_restore: setting owner and privileges for SEQUENCE jcitemsid
pg_restore: setting owner and privileges for TABLE language
pg_restore: setting owner and privileges for TABLE makemodel
pg_restore: setting owner and privileges for TABLE oe
pg_restore: setting owner and privileges for TABLE orderitems
pg_restore: setting owner and privileges for SEQUENCE orderitemsid
pg_restore: setting owner and privileges for TABLE parts
pg_restore: setting owner and privileges for TABLE partscustomer
pg_restore: setting owner and privileges for TABLE partsgroup
pg_restore: setting owner and privileges for TABLE partstax
pg_restore: setting owner and privileges for TABLE partsvendor
pg_restore: setting owner and privileges for TABLE pricegroup
pg_restore: setting owner and privileges for TABLE project
pg_restore: setting owner and privileges for TABLE recurring
pg_restore: setting owner and privileges for TABLE recurringemail
pg_restore: setting owner and privileges for TABLE recurringprint
pg_restore: setting owner and privileges for TABLE shipto
pg_restore: setting owner and privileges for TABLE sic
pg_restore: setting owner and privileges for TABLE status
pg_restore: setting owner and privileges for TABLE tax
pg_restore: setting owner and privileges for TABLE translation
pg_restore: setting owner and privileges for TABLE vendor
pg_restore: setting owner and privileges for TABLE vendortax
pg_restore: setting owner and privileges for TABLE warehouse
pg_restore: setting owner and privileges for TABLE yearend
pg_restore: setting owner and privileges for INDEX acc_trans_chart_id_key
pg_restore: setting owner and privileges for INDEX acc_trans_source_key
pg_restore: setting owner and privileges for INDEX acc_trans_trans_id_key
pg_restore: setting owner and privileges for INDEX acc_trans_transdate_key
pg_restore: setting owner and privileges for INDEX ap_employee_id_key
pg_restore: setting owner and privileges for INDEX ap_id_key
pg_restore: setting owner and privileges for INDEX ap_invnumber_key
pg_restore: setting owner and privileges for INDEX ap_ordnumber_key
pg_restore: setting owner and privileges for INDEX ap_quonumber_key
pg_restore: setting owner and privileges for INDEX ap_transdate_key
pg_restore: setting owner and privileges for INDEX ap_vendor_id_key
pg_restore: setting owner and privileges for INDEX ar_customer_id_key
pg_restore: setting owner and privileges for INDEX ar_employee_id_key
pg_restore: setting owner and privileges for INDEX ar_id_key
pg_restore: setting owner and privileges for INDEX ar_invnumber_key
pg_restore: setting owner and privileges for INDEX ar_ordnumber_key
pg_restore: setting owner and privileges for INDEX ar_quonumber_key
pg_restore: setting owner and privileges for INDEX ar_transdate_key
pg_restore: setting owner and privileges for INDEX assembly_id_key
pg_restore: setting owner and privileges for INDEX audittrail_trans_id_key
pg_restore: setting owner and privileges for INDEX chart_accno_key
pg_restore: setting owner and privileges for INDEX chart_category_key
pg_restore: setting owner and privileges for INDEX chart_gifi_accno_key
pg_restore: setting owner and privileges for INDEX chart_id_key
pg_restore: setting owner and privileges for INDEX chart_link_key
pg_restore: setting owner and privileges for INDEX customer_contact_key
pg_restore: setting owner and privileges for INDEX customer_customer_id_key
pg_restore: setting owner and privileges for INDEX customer_customernumber_key
pg_restore: setting owner and privileges for INDEX customer_id_key
pg_restore: setting owner and privileges for INDEX customer_name_key
pg_restore: setting owner and privileges for INDEX department_id_key
pg_restore: setting owner and privileges for INDEX employee_id_key
pg_restore: setting owner and privileges for INDEX employee_login_key
pg_restore: setting owner and privileges for INDEX employee_name_key
pg_restore: setting owner and privileges for INDEX exchangerate_ct_key
pg_restore: setting owner and privileges for INDEX gifi_accno_key
pg_restore: setting owner and privileges for INDEX gl_description_key
pg_restore: setting owner and privileges for INDEX gl_employee_id_key
pg_restore: setting owner and privileges for INDEX gl_id_key
pg_restore: setting owner and privileges for INDEX gl_reference_key
pg_restore: setting owner and privileges for INDEX gl_transdate_key
pg_restore: setting owner and privileges for INDEX invoice_id_key
pg_restore: setting owner and privileges for INDEX invoice_trans_id_key
pg_restore: setting owner and privileges for INDEX jcitems_id_key
pg_restore: setting owner and privileges for INDEX language_code_key
pg_restore: setting owner and privileges for INDEX makemodel_make_key
pg_restore: setting owner and privileges for INDEX makemodel_model_key
pg_restore: setting owner and privileges for INDEX makemodel_parts_id_key
pg_restore: setting owner and privileges for INDEX oe_employee_id_key
pg_restore: setting owner and privileges for INDEX oe_id_key
pg_restore: setting owner and privileges for INDEX oe_ordnumber_key
pg_restore: setting owner and privileges for INDEX oe_transdate_key
pg_restore: setting owner and privileges for INDEX orderitems_id_key
pg_restore: setting owner and privileges for INDEX orderitems_trans_id_key
pg_restore: setting owner and privileges for INDEX parts_description_key
pg_restore: setting owner and privileges for INDEX parts_id_key
pg_restore: setting owner and privileges for INDEX parts_partnumber_key
pg_restore: setting owner and privileges for INDEX partsgroup_id_key
pg_restore: setting owner and privileges for INDEX partsgroup_key
pg_restore: setting owner and privileges for INDEX partstax_parts_id_key
pg_restore: setting owner and privileges for INDEX partsvendor_parts_id_key
pg_restore: setting owner and privileges for INDEX partsvendor_vendor_id_key
pg_restore: setting owner and privileges for INDEX pricegroup_id_key
pg_restore: setting owner and privileges for INDEX pricegroup_pricegroup_key
pg_restore: setting owner and privileges for INDEX project_id_key
pg_restore: setting owner and privileges for INDEX projectnumber_key
pg_restore: setting owner and privileges for INDEX shipto_trans_id_key
pg_restore: setting owner and privileges for INDEX status_trans_id_key
pg_restore: setting owner and privileges for INDEX translation_trans_id_key
pg_restore: setting owner and privileges for INDEX vendor_contact_key
pg_restore: setting owner and privileges for INDEX vendor_id_key
pg_restore: setting owner and privileges for INDEX vendor_name_key
pg_restore: setting owner and privileges for INDEX vendor_vendornumber_key
pg_restore: setting owner and privileges for INDEX vendortax_vendor_id_key
pg_restore: setting owner and privileges for TRIGGER check_department
pg_restore: setting owner and privileges for TRIGGER check_department
pg_restore: setting owner and privileges for TRIGGER check_department
pg_restore: setting owner and privileges for TRIGGER check_department
pg_restore: setting owner and privileges for TRIGGER check_inventory
pg_restore: setting owner and privileges for TRIGGER del_customer
pg_restore: setting owner and privileges for TRIGGER del_department
pg_restore: setting owner and privileges for TRIGGER del_department
pg_restore: setting owner and privileges for TRIGGER del_department
pg_restore: setting owner and privileges for TRIGGER del_department
pg_restore: setting owner and privileges for TRIGGER del_exchangerate
pg_restore: setting owner and privileges for TRIGGER del_exchangerate
pg_restore: setting owner and privileges for TRIGGER del_exchangerate
pg_restore: setting owner and privileges for TRIGGER del_recurring
pg_restore: setting owner and privileges for TRIGGER del_recurring
pg_restore: setting owner and privileges for TRIGGER del_recurring
pg_restore: setting owner and privileges for TRIGGER del_vendor
pg_restore: setting owner and privileges for TRIGGER del_yearend
WARNING: errors ignored on restore: 45
Process returned exit code 1.
----- Vladimir Botka <vl...@bo...> wrote:
> >
> > Hello all i am migrating from freebsd 4.11 to 6.2 this includes a
> > sql-ledger migration/update.
> >
> > I was running version
> > sql-ledger 2.6.16 i think but it is broken now so i cannot really
> say
> > for certain.
> >
> > postgresql-server-7.4.13_1
> >
> > now i am running
> > postgresql-server-7.4.16
> > sql-ledger-2.6.26
> >
> > As stated above i have succesfully installed the versions of
> > sql-ledger and postgres that i need.
> >
> > My problem lies with getting the old database into the new postgres
> i
> > have exported without error but when i try to import it i come
> across
> > all sorts of errors nonresistant database nonresistant user
> language
> > problems . Could someone kindly help me with this as i have been
> > struggling with it for days now.
> >
> > thanks in advance
>
> Hello,
> pg_dump and pg_restore should work. If not so post the errors.
> Generally:
> 1. install OS & SL
> 2. dump and restore the database
> 3. maybe upgrade SL again
>
> Cheers, -vlado
--
Computer King & CaN Mail - Sales Service Hosting Backup
http://www.computerking.ca http://www.canmail.org
NEW!!! Custom Service Packages
Secure IMAP Email - Automated Remote Backups - Photo Blogs - Online Accounting Packages
|
