You won't be able to run any DSpace command to fix this, as DSpace doesn't have a way to recreate individual tables.
You'd have to use psql (or other Postgres tools) to run that single CREATE TABLE statement. You won't be able to run that entire v1.4 upgrade script, because you are missing only one table in that entire script -- so trying to run that entire script will more than likely throw errors on all other tables. Here's the docs for psql. You may need to use the "-c" flag or create a custom *.sql file (including that one CREATE TABLE command) and use the "-f" flag. https://www.postgresql.org/docs/current/app-psql.html Tim ________________________________ From: [email protected] <[email protected]> on behalf of Night Librarian <[email protected]> Sent: Tuesday, August 30, 2022 1:31 PM To: DSpace Technical Support <[email protected]> Subject: Re: [dspace-tech] Re: Database migrate problem while upgrading from 4.0 to 7.2 Should I be running: ./dspace database /temp/DSpace-dspace-7.2/dspace-api/src/main/resources/org/dspace/storage/rdbms/sqlmigration/postgres/V1.4_Upgrade_to_Dspace_1.4_schema.sql ? Or is there a psql command I would need? -- 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 [email protected]<mailto:[email protected]>. To view this discussion on the web visit https://groups.google.com/d/msgid/dspace-tech/4424d7f3-7c39-4504-91e6-a2db527fd5acn%40googlegroups.com<https://groups.google.com/d/msgid/dspace-tech/4424d7f3-7c39-4504-91e6-a2db527fd5acn%40googlegroups.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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/dspace-tech/PH0PR22MB3274E29973408530DC3C3D09ED799%40PH0PR22MB3274.namprd22.prod.outlook.com.
