Correction: # You need to change the bin folder path in step 1 & 5 to match yours.
On Saturday, June 17, 2023 at 9:55:33 AM UTC+3 Mohammad S. AlMutairi wrote: > 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/f26b09c5-cdfa-4970-8ea8-1076f21323abn%40googlegroups.com.
