Top Menu

Jump to content
Home
    Modules
      • Projects
      • Activity
      • Work packages
      • Gantt charts
      • Calendars
      • Team planners
      • Boards
      • News
    • Getting started
    • Introduction video
      Welcome to OpenProject Community
      Get a quick overview of project management and team collaboration with OpenProject. You can restart this video from the help menu.

    • Help and support
    • Upgrade to Enterprise edition
    • User guides
    • Videos
    • Shortcuts
    • Community forum
    • Enterprise support

    • Additional resources
    • Data privacy and security policy
    • Digital accessibility (DE)
    • OpenProject website
    • Security alerts / Newsletter
    • OpenProject blog
    • Release notes
    • Report a bug
    • Development roadmap
    • Add and edit translations
    • API documentation
  • Sign in
      Forgot your password?

      or sign in with your existing account

      Google

Side Menu

  • Overview
  • Activity
    Activity
  • Roadmap
  • Work packages
    Work packages
  • Gantt charts
    Gantt charts
  • Calendars
    Calendars
  • Team planners
    Team planners
  • Boards
    Boards
  • News
  • Forums

Content

General discussion
  1. OpenProject
  2. Forums
  3. General discussion
  4. Issues with schema rename from cloud to local running in Docker

Issues with schema rename from cloud to local running in Docker

Added by James Spedding 3 months ago

I wonder if anyone could help me with the final step to restoring a backup?

I created a project in the online trial of OpenProject  and have since installed OpenProject  locally in a Docker container on a PC running Windows 11 to carry on exploring.

I created a backup and downloaded the openproject.sql file. I copied it into OpenProject so now it shows:

openproject-# \dn
                       List of schemas
                       Name                           |  Owner
---------------------------------------------------------+----------
1738252715_4574683_4ce20049_316d_4cdd_a992_861268eefb2c | postgres
public                                                  | postgres
(2 rows)

the advice from https://www.openproject.org/docs/installation-and-operations/operation/restoring/#changing-the-database-schema-from-cloud-to-on-premises suggests:

openproject=# DROP SCHEMA public CASCADE; DROP SCHEMA

but when I run it I get:

openproject-# DROP SCHEMA public CASCADE; DROP SCHEMA
ERROR:  syntax error at or near "DROP"
LINE 3: DROP SCHEMA public CASCADE DROP SCHEMA
          ^

I'm not sure why - I noticed that the 'openproject=#' in the example is not the same as 'openproject-#' that I have. I'm also not sure why that is.

I wonder if you could give me any pointers? Any help gratefully received. Thanks, James


Loading...