On Thu, May 29, 2008 at 6:35 PM, <[EMAIL PROTECTED]> wrote: > > > Yes. Here are the errors I received. I cut out some misc. items from the > log that were not relevant. > > [EMAIL PROTECTED]:~/data> pg_dump -a tatylee > tatyleebackup.sql > [EMAIL PROTECTED]:~/data> psql -d ledgersmbtest -f tatyleebackup.sql > SET > SET > SET > SET > psql:tatyleebackup.sql:15: ERROR: relation "acctrans_entry_id_seq" does > not exist setval > -------- > > > psql:tatyleebackup.sql:92: ERROR: relation "session_session_id_seq" does > not exist setval
> > > psql:tatyleebackup.sql:120: ERROR: insert or update on table "acc_trans" > violates foreign key constraint "acc_trans_chart_id_fkey" > DETAIL: Key (chart_id)=(10014) is not present in table "chart". > psql:tatyleebackup.sql:14190: ERROR: duplicate key violates unique > constraint "chart_pkey" > CONTEXT: COPY chart, line 1: "10001 1000 CURRENT ASSETS H A > f > " > psql:tatyleebackup.sql:15151: ERROR: duplicate key violates unique > constraint "defaults_pkey" > CONTEXT: COPY defaults, line 2: "audittrail 1" > psql:tatyleebackup.sql:15194: ERROR: duplicate key violates unique > constraint "dpt_trans_pkey" > CONTEXT: COPY dpt_trans, line 58: "10148 10081" > psql:tatyleebackup.sql:24676: ERROR: relation "session" does not exist > psql:tatyleebackup.sql:24677: invalid command \. > psql:tatyleebackup.sql:25122: ERROR: duplicate key violates unique > constraint "taxmodule_pkey" > CONTEXT: COPY taxmodule, line 1: "1 Simple" > psql:tatyleebackup.sql:25131: ERROR: duplicate key violates unique > constraint "transactions_pkey" > CONTEXT: COPY transactions, line 1: "10148 ap" > Hmm... Your backup/restore procedure is hosed-- stuff is restored in the wrong order. Which version of PostgreSQL are you running? Also some tables like defaults have differnet column names, so just doing a data dump/restore may create problems (this is not the only thing happening here though). Best Wishes, Chris Travers Best Wishes, Chris Travers ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ Ledger-smb-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
