Unfortunately, we'd need more information to help out. It sounds like the "./dspace database migrate ignored" script is attempting to run migrations from DSpace version 1.1 on your database. That means it somehow believes that you don't have a valid DSpace database at all? Or it somehow thinks you are running DSpace 1.0 (which is really really odd, if you are running 6.3). Maybe your pg_dump or pg_restore was missing some tables?
You can try running "./dspace database info" to see what version of DSpace the script believes that your database supports. It should say your database is running 6.3... or that scripts through version 6.3 have already been run. But, based on the error you shared, it sounds like it may say something else entirely. Tim On Wednesday, June 14, 2023 at 9:00:40 AM UTC-5 michel.m...@gmail.com wrote: > The command "./dspace database migrate ignored" does not work, it gives an > error. What do I need to do to migrate ONLY the Data (Database) from 6.3 to > 7.5? > > We follow these steps (To migrate ONLY the old database to the new one): > * We did the PG_DUMP on the "dspace" ( Server 6.3) that has data and > applied the PG_RESTORE from this base on the Server 7.5 dspace (The 7.5 > Dspace was clean). Everything ran without error! > * When applying the command [Server 7.5] "./dspace database migrate > ignored", it gives an error. > > 1º) Error: > SQL State : 42P07 > Error Code : 0 > Message : ERROR: relation "bitstreamformatregistry" already exists > Location : > org/dspace/storage/rdbms/sqlmigration/postgres/V1.1_Initial_DSpace_1.1_database_schema.sql > > (C:\dspace\file:\C:\dspace\lib\dspace-api-7.5.jar!\org\dspace\storage\rdbms\sqlmigration\postgres\V1.1_Initial_DSpace_1.1_database_schema.sql) > Line : 90 > > 2º) Error: > SQL State : 42723 > Error Code : 0 > Message : ERROR: function "getnextid" already exists with same argument > types > Location : > org/dspace/storage/rdbms/sqlmigration/postgres/V1.1_Initial_DSpace_1.1_database_schema.sql > > (C:\dspace\file:\C:\dspace\lib\dspace-api-7.5.jar!\org\dspace\storage\rdbms\sqlmigration\postgres\V1.1_Initial_DSpace_1.1_database_schema.sql) > Line : 46 > > > > Em sexta-feira, 2 de junho de 2023 às 18:43:21 UTC-3, Tim Donohue escreveu: > >> Hi Michel, >> >> We have a guide for migrating data at >> https://wiki.lyrasis.org/display/DSDOC7x/Migrating+DSpace+to+a+new+server >> >> This should work even migrating data from an old 6.x instance to a new >> 7.x one. >> >> Tim >> ------------------------------ >> *From:* dspac...@googlegroups.com <dspac...@googlegroups.com> on behalf >> of Michel Montenegro <michel.m...@gmail.com> >> *Sent:* Friday, June 2, 2023 10:17 AM >> *To:* dspac...@googlegroups.com <dspac...@googlegroups.com> >> *Subject:* Re: [dspace-tech] Migration Help from 6.3 to 7.5 >> >> I will detail our case: >> we have version 6.3 (All data) and 7.5 (Clean) running on different >> servers, we simply want to transfer only the data from version 6.3 to 7.5. >> >> We don't understand how to do that even from the documentation you >> indicated (We had already seen it). What exactly do we need to do to export >> the data from 6.3 to 7.5? (Assuming 7.5 is running, but it's a clean >> install and all the data we want is in 6.3) >> >> Em sex., 2 de jun. de 2023 às 11:23, Mark H. Wood <mwood...@gmail.com> >> escreveu: >> >> On Thu, Jun 01, 2023 at 10:40:44PM -0300, Michel Montenegro wrote: >> > Where can I find documentation that shows how to migrate from 6.3 to >> 7.5 or >> > how we can migrate? >> > >> > All documentation I found was out of date or apparently incomplete. >> >> The official upgrade documentation is at: >> >> https://wiki.lyrasis.org/display/DSDOC7x/Upgrading+DSpace >> >> If that is incorrect or incomplete, please tell us about the specific >> problem(s) you found. >> >> -- >> Mark H. Wood >> Lead Technology Analyst >> >> University Library >> Indiana University - Purdue University Indianapolis >> 755 W. Michigan Street >> Indianapolis, IN 46202 >> 317-274-0749 <(317)%20274-0749> >> www.ulib.iupui.edu >> >> -- >> All messages to this mailing list should adhere to the Code of Conduct: >> https://www.lyrasis.org/about/Pages/Code-of-Conduct.aspx >> --- >> You received this message because you are subscribed to the Google Groups >> "DSpace Technical Support" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to dspace-tech...@googlegroups.com. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/dspace-tech/ZHn7eYw0me8tLAx1%40IUPUI.Edu >> . >> >> >> >> -- >> Atenciosamente, >> *Michel Pinheiro Montenegro* >> - *Bacharel* em Sistema de Informação >> - [Lato Sensu] *Especialista* em Engenharia de Sistemas >> - [Stricto Sensu] *Mestre* em Ciência da Computação >> - [Stricto Sensu] *Doutorando* em Ciência da Computação >> >> E-mail/Gtalk: michel.m...@gmail.com >> >> -- >> All messages to this mailing list should adhere to the Code of Conduct: >> https://www.lyrasis.org/about/Pages/Code-of-Conduct.aspx >> --- >> You received this message because you are subscribed to the Google Groups >> "DSpace Technical Support" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to dspace-tech...@googlegroups.com. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/dspace-tech/CADOAx_jWiA6dkU7O0BSU7BNe0RBek33uCwf3znNXidcBiCZ_og%40mail.gmail.com >> >> <https://groups.google.com/d/msgid/dspace-tech/CADOAx_jWiA6dkU7O0BSU7BNe0RBek33uCwf3znNXidcBiCZ_og%40mail.gmail.com?utm_medium=email&utm_source=footer> >> . >> > -- All messages to this mailing list should adhere to the Code of Conduct: https://www.lyrasis.org/about/Pages/Code-of-Conduct.aspx --- You received this message because you are subscribed to the Google Groups "DSpace Technical Support" group. To unsubscribe from this group and stop receiving emails from it, send an email to dspace-tech+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/dspace-tech/d10366d0-48db-47e7-96fd-b91e014be905n%40googlegroups.com.
