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: > > http://lists.bx.psu.edu/ ___________________________________________________________ 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: http://lists.bx.psu.edu/
