Hi,

This looks like a permissions error in your PostgreSQL instance.  Notice 
this error:

Caused by: org.postgresql.util.PSQLException: ERROR: permission denied for 
schema public

That's saying that the Postgres user who is trying to update your database 
does *not* have permissions on the "public" database schema in PostgreSQL.  
This means that user cannot update the database.  You will likely need to 
give your "dspace" user access to modify the "public" schema.

Tim

On Tuesday, March 18, 2025 at 11:18:00 AM UTC-5 [email protected] wrote:

> Dear all,
> i'm facing these problems in trying to restore a backup of DSpace 8 onto 
> another DSpace 8.0 or Dspace 8.1 System. Please help.
> Below are the errors:
>
>
> *psql -f 040325dspace.backup dspace*
>
> psql:040325dspace.backup:815606: error: invalid command \N
> psql:040325dspace.backup:815607: error: invalid command \N
> psql:040325dspace.backup:815608: error: invalid command \N
> psql:040325dspace.backup:815609: error: invalid command \N
> psql:040325dspace.backup:815610: error: invalid command \N
> psql:040325dspace.backup:815611: error: invalid command \N
> psql:040325dspace.backup:815612: error: invalid command \N
> psql:040325dspace.backup:815613: error: invalid command \N
> psql:040325dspace.backup:815614: error: invalid command \N
> psql:040325dspace.backup:815615: error: invalid command \N
> psql:040325dspace.backup:815616: error: invalid command \N
> psql:040325dspace.backup:815617: error: invalid command \N
> psql:040325dspace.backup:815618: error: invalid command \N
> psql:040325dspace.backup:815619: error: invalid command \N
> psql:040325dspace.backup:815620: error: invalid command \N
> psql:040325dspace.backup:815621: error: invalid command \N
> psql:040325dspace.backup:815622: error: invalid command \N
> psql:040325dspace.backup:815623: error: invalid command \N
> Query buffer reset (cleared).
> psql:040325dspace.backup:815624: error: invalid command \n
> psql:040325dspace.backup:815625: error: invalid command \N
> psql:040325dspace.backup:815626: error: invalid command \N
> psql:040325dspace.backup:815627: error: invalid command \N
> psql:040325dspace.backup:815628: error: invalid command \N
> psql:040325dspace.backup:815629: error: invalid command \N
> psql:040325dspace.backup:815630: error: invalid command \N
> Query buffer reset (cleared).
> psql:040325dspace.backup:815631: error: invalid command \nNo.
> psql:040325dspace.backup:815632: error: invalid command \N
> psql:040325dspace.backup:815633: error: invalid command \N
> psql:040325dspace.backup:815634: error: invalid command \N
> Query buffer reset (cleared).
> psql:040325dspace.backup:815635: error: invalid command \nAnkomah
> psql:040325dspace.backup:815636: error: invalid command \N
> psql:040325dspace.backup:815637: error: invalid command \N
>
>
>
>
>
> *sudo /dspace/bin/dspace database info*
>
> Database Type: postgres
> Database URL: jdbc:postgresql://localhost:5432/dspace
> Database Schema: public
> Database Username: dspace
> Database Software: PostgreSQL version 16.8 (Ubuntu 16.8-0ubuntu0.24.04.1)
> Database Driver: PostgreSQL JDBC Driver version 42.7.3
> PostgreSQL 'pgcrypto' extension installed/up-to-date? true (version=1.3)
> FlywayDB Version: 10.10.0
>
>
> +-----------+----------------+------------------------------------------------------------------+------+--------------+---------+----------+
> | Category  | Version        | Description                                 
>                      | Type | Installed On | State   | Undoable |
>
> +-----------+----------------+------------------------------------------------------------------+------+--------------+---------+----------+
> | Versioned | 1.1            | Initial DSpace 1.1 database schema         
>                       | SQL  |              | Pending | No       |
> | Versioned | 1.2            | Upgrade to DSpace 1.2 schema               
>                       | SQL  |              | Pending | No       |
> | Versioned | 1.3            | Upgrade to DSpace 1.3 schema               
>                       | SQL  |              | Pending | No       |
> | Versioned | 1.3.9          | Drop constraint for DSpace 1 4 schema       
>                      | JDBC |              | Pending | No       |
> | Versioned | 1.4            | Upgrade to DSpace 1.4 schema               
>                       | SQL  |              | Pending | No       |
> | Versioned | 1.5            | Upgrade to DSpace 1.5 schema               
>                       | SQL  |              | Pending | No       |
> | Versioned | 1.5.9          | Drop constraint for DSpace 1 6 schema       
>                      | JDBC |              | Pending | No       |
> | Versioned | 1.6            | Upgrade to DSpace 1.6 schema               
>                       | SQL  |              | Pending | No       |
> | Versioned | 1.7            | Upgrade to DSpace 1.7 schema               
>                       | SQL  |              | Pending | No       |
> | Versioned | 1.8            | Upgrade to DSpace 1.8 schema               
>                       | SQL  |              | Pending | No       |
> | Versioned | 3.0            | Upgrade to DSpace 3.x schema               
>                       | SQL  |              | Pending | No       |
> | Versioned | 4.0            | Upgrade to DSpace 4.x schema               
>                       | SQL  |              | Pending | No       |
> | Versioned | 4.9.2015.10.26 | DS-2818 registry update                     
>                      | SQL  |              | Pending | No       |
> | Versioned | 5.0.2014.08.08 | DS-1945 Helpdesk Request a Copy             
>                      | SQL  |              | Pending | No       |
> | Versioned | 5.0.2014.09.25 | DS 1582 Metadata For All Objects drop 
> constraint                 | JDBC |              | Pending | No       |
> | Versioned | 5.0.2014.09.26 | DS-1582 Metadata For All Objects           
>                       | SQL  |              | Pending | No       |
> | Versioned | 5.0.2014.11.04 | Enable XMLWorkflow Migration               
>                       | JDBC |              | Pending | No       |
> | Versioned | 5.6.2016.08.23 | DS-3097                                     
>                      | SQL  |              | Pending | No       |
> | Versioned | 5.7.2017.04.11 | DS-3563 Index metadatavalue resource type 
> id column              | SQL  |              | Pending | No       |
> | Versioned | 5.7.2017.05.05 | DS 3431 Add Policies for BasicWorkflow     
>                       | JDBC |              | Pending | No       |
> | Versioned | 6.0.2015.03.06 | DS 2701 Dso Uuid Migration                 
>                       | JDBC |              | Pending | No       |
> | Versioned | 6.0.2015.03.07 | DS-2701 Hibernate migration                 
>                      | SQL  |              | Pending | No       |
> | Versioned | 6.0.2015.08.31 | DS 2701 Hibernate Workflow Migration       
>                       | JDBC |              | Pending | No       |
> | Versioned | 6.0.2015.09.01 | DS 2701 Enable XMLWorkflow Migration       
>                       | JDBC |              | Pending | No       |
> | Versioned | 6.0.2016.01.03 | DS-3024                                     
>                      | SQL  |              | Pending | No       |
> | Versioned | 6.0.2016.01.26 | DS 2188 Remove DBMS Browse Tables           
>                      | JDBC |              | Pending | No       |
> | Versioned | 6.0.2016.02.25 | DS-3004-slow-searching-as-admin             
>                      | SQL  |              | Pending | No       |
> | Versioned | 6.0.2016.04.01 | DS-1955 Increase embargo reason             
>                      | SQL  |              | Pending | No       |
> | Versioned | 6.0.2016.04.04 | DS-3086-OAI-Performance-fix                 
>                      | SQL  |              | Pending | No       |
> | Versioned | 6.0.2016.04.14 | DS-3125-fix-bundle-bitstream-delete-rights 
>                       | SQL  |              | Pending | No       |
> | Versioned | 6.0.2016.05.10 | DS-3168-fix-requestitem item id column     
>                       | SQL  |              | Pending | No       |
> | Versioned | 6.0.2016.07.21 | DS-2775                                     
>                      | SQL  |              | Pending | No       |
> | Versioned | 6.0.2016.07.26 | DS-3277 fix handle assignment               
>                      | SQL  |              | Pending | No       |
> | Versioned | 6.0.2016.08.23 | DS-3097                                     
>                      | SQL  |              | Pending | No       |
> | Versioned | 6.1.2017.01.03 | DS 3431 Add Policies for BasicWorkflow     
>                       | JDBC |              | Pending | No       |
> | Versioned | 7.0.2017.10.12 | DS-3542-stateless-sessions                 
>                       | SQL  |              | Pending | No       |
> | Versioned | 7.0.2018.04.03 | Upgrade Workflow Policy
> | Versioned | 7.0.2018.04.16 | dspace-entities                             
>                      | SQL  |              | Pending | No       |
> | Versioned | 7.0.2018.06.07 | DS-3851-permission                         
>                       | SQL  |              | Pending | No       |
> | Versioned | 7.0.2019.05.02 | DS-4239-workflow-xml-migration             
>                       | SQL  |              | Pending | No       |
> | Versioned | 7.0.2019.06.14 | scripts-and-process                         
>                      | SQL  |              | Pending | No       |
> | Versioned | 7.0.2019.07.31 | Retrieval of name variant                   
>                      | SQL  |              | Pending | No       |
> | Versioned | 7.0.2019.11.13 | relationship type copy left right           
>                      | SQL  |              | Pending | No       |
> | Versioned | 7.0.2020.01.08 | DS-626-statistics-tracker                   
>                      | SQL  |              | Pending | No       |
> | Versioned | 7.0.2020.10.31 | CollectionCommunity Metadata Handle         
>                      | JDBC |              | Pending | No       |
> | Versioned | 7.0.2021.01.22 | Remove basic workflow                       
>                      | SQL  |              | Pending | No       |
> | Versioned | 7.0.2021.02.08 | tilted rels                                 
>                      | SQL  |              | Pending | No       |
> | Versioned | 7.0.2021.03.18 | Move entity type to dspace schema           
>                      | SQL  |              | Pending | No       |
> | Versioned | 7.0.2021.09.24 | Move entity type from item template to 
> collection                | SQL  |              | Pending | No       |
> | Versioned | 7.0.2021.10.04 | alter collection table drop workflow stem 
> columns                | SQL  |              | Pending | No       |
> | Versioned | 7.1.2021.10.18 | Fix MDV place after migrating from DSpace 5 
>                      | SQL  |              | Pending | No       |
> | Versioned | 7.3.2022.04.29 | orcid queue and history                     
>                      | SQL  |              | Pending | No       |
> | Versioned | 7.3.2022.05.16 | Orcid token table                           
>                      | SQL  |              | Pending | No       |
> | Versioned | 7.3.2022.06.16 | process to group                           
>                       | SQL  |              | Pending | No       |
> | Versioned | 7.3.2022.06.20 | add last version status column to 
> relationship table             | SQL  |              | Pending | No       |
> | Versioned | 7.5.2022.12.01 | add table subscriptionparamter change 
> columns subscription table | SQL  |              | Pending | No       |
> | Versioned | 7.5.2022.12.06 | index action resource policy               
>                       | SQL  |              | Pending | No       |
> | Versioned | 7.5.2022.12.09 | Supervision Orders table                   
>                       | SQL  |              | Pending | No       |
> | Versioned | 7.5.2022.12.15 | system wide alerts                         
>                       | SQL  |              | Pending | No       |
> | Versioned | 7.6.2023.03.17 | Remove unused sequence                     
>                       | SQL  |              | Pending | No       |
> | Versioned | 7.6.2023.03.24 | Update PNG in bitstream format registry     
>                      | SQL  |              | Pending | No       |
> | Versioned | 7.6.2023.03.29 | orcid queue and history descriptions to 
> text type                | SQL  |              | Pending | No       |
> | Versioned | 7.6.2023.04.19 | process parameters to text type             
>                      | SQL  |              | Pending | No       |
> | Versioned | 7.6.2023.09.28 | enforce group or eperson for resourcepolicy 
>                      | SQL  |              | Pending | No       |
> | Versioned | 7.6.2023.10.12 | Fix-deleted-primary-bitstreams             
>                       | SQL  |              | Pending | No       |
> | Versioned | 7.6.2024.03.07 | set eperson process nullable               
>                       | SQL  |              | Pending | No       |
> | Versioned | 7.6.2024.05.07 | process eperson constraint                 
>                       | SQL  |              | Pending | No       |
> | Versioned | 8.0.2023.08.07 | qaevent processed                           
>                      | SQL  |              | Pending | No       |
> | Versioned | 8.0.2024.02.14 | ldn tables                                 
>                       | SQL  |              | Pending | No       |
>
> +-----------+----------------+------------------------------------------------------------------+------+--------------+---------+----------+
>
>
> NOTE: This database is NOT yet initialized for auto-migrations (via 
> Flyway).
>
>
>
>
> *sudo /dspace/bin/dspace database migrate*
>
> Database URL: jdbc:postgresql://localhost:5432/dspace
> Migrating database to latest version... (Check dspace logs for details)
> Migration exception:
> java.sql.SQLException: Flyway migration error occurred
>         at 
> org.dspace.storage.rdbms.DatabaseUtils.updateDatabase(DatabaseUtils.java:838)
>         at 
> org.dspace.storage.rdbms.DatabaseUtils.updateDatabase(DatabaseUtils.java:725)
>         at 
> org.dspace.storage.rdbms.DatabaseUtils.updateDatabase(DatabaseUtils.java:700)
>         at 
> org.dspace.storage.rdbms.DatabaseUtils.main(DatabaseUtils.java:244)
>         at 
> java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native 
> Method)
>         at 
> java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
>         at 
> java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>         at java.base/java.lang.reflect.Method.invoke(Method.java:569)
>         at 
> org.dspace.app.launcher.ScriptLauncher.runOneCommand(ScriptLauncher.java:283)
>         at 
> org.dspace.app.launcher.ScriptLauncher.handleScript(ScriptLauncher.java:134)
>         at 
> org.dspace.app.launcher.ScriptLauncher.main(ScriptLauncher.java:99)
> Caused by: org.flywaydb.core.internal.sqlscript.FlywaySqlScriptException: 
> Migration  failed
> -----------------
> SQL State  : 42501
> Error Code : 0
> Message    : ERROR: permission denied for schema public
>   Position: 14
> Location   :  ()
> Line       : 1
> Statement  : CREATE TABLE "public"."schema_version" (
>     "installed_rank" INT NOT NULL,
>     "version" VARCHAR(50),
>     "description" VARCHAR(200) NOT NULL,
>     "type" VARCHAR(20) NOT NULL,
>     "script" VARCHAR(1000) NOT NULL,
>     "checksum" INTEGER,
>     "installed_by" VARCHAR(100) NOT NULL,
>     "installed_on" TIMESTAMP NOT NULL DEFAULT now(),
>     "execution_time" INTEGER NOT NULL,
>     "success" BOOLEAN NOT NULL
> )
>
>  at 
> org.flywaydb.core.internal.sqlscript.DefaultSqlScriptExecutor.executeStatement(DefaultSqlScriptExecutor.java:214)
>         at 
> org.flywaydb.core.internal.sqlscript.DefaultSqlScriptExecutor.execute(DefaultSqlScriptExecutor.java:133)
>         at 
> org.flywaydb.core.internal.schemahistory.JdbcTableSchemaHistory$1$1.call(JdbcTableSchemaHistory.java:119)
>         at 
> org.flywaydb.core.internal.jdbc.TransactionalExecutionTemplate.execute(TransactionalExecutionTemplate.java:55)
>         at 
> org.flywaydb.core.internal.schemahistory.JdbcTableSchemaHistory$1.call(JdbcTableSchemaHistory.java:115)
>         at 
> org.flywaydb.database.postgresql.PostgreSQLAdvisoryLockTemplate.execute(PostgreSQLAdvisoryLockTemplate.java:73)
>         at 
> org.flywaydb.database.postgresql.PostgreSQLAdvisoryLockTemplate.lambda$execute$0(PostgreSQLAdvisoryLockTemplate.java:56)
>         at 
> org.flywaydb.core.internal.jdbc.TransactionalExecutionTemplate.execute(TransactionalExecutionTemplate.java:55)
>         at 
> org.flywaydb.database.postgresql.PostgreSQLAdvisoryLockTemplate.execute(PostgreSQLAdvisoryLockTemplate.java:56)
>         at 
> org.flywaydb.database.postgresql.PostgreSQLConnection.lock(PostgreSQLConnection.java:96)
>         at 
> org.flywaydb.core.internal.schemahistory.JdbcTableSchemaHistory.create(JdbcTableSchemaHistory.java:105)
>         at 
> org.flywaydb.core.internal.command.DbBaseline.baseline(DbBaseline.java:88)
>         at org.flywaydb.core.Flyway.doBaseline(Flyway.java:424)
>         at org.flywaydb.core.Flyway.lambda$baseline$5(Flyway.java:339)
>         at 
> org.flywaydb.core.FlywayExecutor.execute(FlywayExecutor.java:205)
>         at org.flywaydb.core.Flyway.baseline(Flyway.java:329)
>         at 
> org.dspace.storage.rdbms.DatabaseUtils.updateDatabase(DatabaseUtils.java:802)
>         ... 10 more
> Caused by: org.postgresql.util.PSQLException: ERROR: permission denied for 
> schema public
>   Position: 14
>         at 
> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2725)
>         at 
> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2412)
>         at 
> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:371)
>         at 
> org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:502)
>         at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:419)
>         at 
> org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:341)
>         at 
> org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:326)
>         at 
> org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:302)
>         at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:297)
>         at 
> org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:182)
>         at 
> org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:182)
>         at 
> org.flywaydb.core.internal.jdbc.JdbcTemplate.executeStatement(JdbcTemplate.java:210)
>         at 
> org.flywaydb.core.internal.sqlscript.ParsedSqlStatement.execute(ParsedSqlStatement.java:89)
>         at 
> org.flywaydb.core.internal.sqlscript.DefaultSqlScriptExecutor.executeStatement(DefaultSqlScriptExecutor.java:206)
>         ... 26 more
>
>
>
> -- 
> *Psalm 119:28 My Soul is weary with sorrow ; strengthen me according to 
> your Word.*
> *Sincerely Yours,*
>
> *Henry Atsu Agbodza*
> *Commonwealth Fellow*
> *Library Systems and Research Support, *
> *Academic Computing Unit,*
> *University of Ghana Computing Systems (UGCS)*
> *Room G3, Ground Floor - East Wing, *
> *Balme Library*
> *Legon*
> *Tel.: +233 (0) 207 027360*
> *IP Phone: 2442*
>
> *UG Repository <http://ugspace.ug.edu.gh>*
> *UG Library <http://balme.ug.edu.gh>*
>
>
> *UG Online Catalogue (UGCat) <http://library.ug.edu.gh/>UG Research Portal 
> <http://libguides.ug.edu.gh>UG Off - Campus Access to E - Resources 
> <http://ezproxy.ug.edu.gh/>*
> *UG Chat with A Librarian Service <http://balme.ug.edu.gh/chat/client.php>*
>

-- 
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 visit 
https://groups.google.com/d/msgid/dspace-tech/ef390334-9448-42d9-9339-e97f269e5a27n%40googlegroups.com.

Reply via email to