Vipin TS wrote:
Dear Galaxy Team,
I am switching our Galaxy production service to a new machine, We are using Postgres as database server. The existing database belongs to postgres version 8.3 and I took my instance's dump using postgres version 8.4. I am able to restore my database on postgres 8.4, Except few tables were empty and with few strange error message left on log file. I am not sure how many tables are empty, but I found table called 'job' returns 0 rows. Original job table returns me 40733 rows.
excerpts from error log: ERROR: insert or update on table "history_dataset_association_annotation_association" violates foreign key constraint "history_dataset_association_a_history_dataset_association__fkey" DETAIL: Key (history_dataset_association_id)=(284985) is not present in table "history_dataset_association". STATEMENT: ALTER TABLE ONLY history_dataset_association_annotation_association ADD CONSTRAINT history_dataset_association_a_history_dataset_association__fkey FOREIGN KEY (history_dataset_association_id) REFERENCES history_dataset_association(id); ERROR: insert or update on table "history_dataset_association_tag_association" violates foreign key constraint "history_dataset_association_t_history_dataset_association__fkey" DETAIL: Key (history_dataset_association_id)=(387932) is not present in table "history_dataset_association". STATEMENT: ALTER TABLE ONLY history_dataset_association_tag_association
In my knowledge we didn't do any manual transactions on Galaxy database and Could anyone let me know something wrong at my end. I'm sure this has been covered somewhere but I haven't been able to find it on the Wiki or by searching the archives.
Hi Vipin, When restoring, I generally use the --disable-triggers, which instructs Postgres to ignore foreign key constraints. --nate
Thanks in advance, Vipin Friedrich Miescher Laboratory of the Max Planck Society Spemannstrasse 39, 72076 Tuebingen, Germany
___________________________________________________________ Please keep all replies on the list by using "reply all" in your mail client. To manage your subscriptions to this and other Galaxy lists, please use the interface at: