On Friday, June 16, 2023 at 11:44:22 AM UTC+3 Michel Montenegro wrote: The problem seems to be at the base of 6.3 (At this moment I don't know how the team's DBAs solved it when generating the dump), but we managed to start the migration, however during the migration it stopped and generated the following error (The 6.3 database this one being migrated had nothing added, it's the 6.3 core ):
Hi All, It seems all the issues you are facing in your migration is caused of how the the old database is exported and imported in the new server. Just make sure before following the steps you see below the pgcrypto extension was created on the database in the old server and not add into the extensions schema. Once you sucessed on importing the database follow the other steps in the link Tim provided https://wiki.lyrasis.org/display/DSDOC7x/Migrating+DSpace+to+a+new+server # You need to change the bin folder path in step 2 & 6 to match yours. 1) cd "C:\Program Files\PostgreSQL\9.13\bin" 2) .\pg_dump -U postgres -W -h localhost -Fc -v -C -E UTF8 -d dspace -f C:\dspace-63.sql 3) Move dspace-63.sql file to the new dspace server On the new dspace server execute: 1) psql --username=postgres dspace 2) DROP EXTENSION pgcrypto; 3) DROP SCHEMA extensions; 4) \q 5) cd "C:\Program Files\PostgreSQL\13\bin" 6) .\pg_restore -U postgres -W -h localhost -v -e -c --if-exists -d dspace C:\dspace-63.sql 7) psql --username=postgres dspace 8) \dn 9) \dx 10) \q Hope it helps. Mo. -- 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/19566015-f013-4ee6-a77e-f66cd96c288an%40googlegroups.com.
