[EMAIL PROTECTED] wrote on 05/29/2008 06:26:21 PM: > "Chris Travers" <[EMAIL PROTECTED]> > > defaults should be dumped. If it is not being dumped, I wonder why. > > Any errors in the PostgreSQL error log? > > Best Wishes, > Chris Travers > >
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" ------------------------------------------------------------------------- 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
