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
    • 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
  • Feature tour
    Feature tour

Content

You are here:
  1. Forums
  2. Support Installation & Updates

Migration Debian to Ubuntu 20.04 Database Problems

Added by kak tux almost 4 years ago

Hi there,

I have an openproject installation using Debian 9 and since the repository for that no longer gets updates i wanted to switch to Ubuntu 20.04 (which i use mostly and am most used to).

I am using a virtual machine on a NAS for openproject - so i created a new one with Ubuntu20.04.

Afterwards i followed the guide - logged in to the old installation

https://docs.openproject.org/installation-and-operations/misc/migration/

  1. Backup - https://docs.openproject.org/installation-and-operations/operation/backing-up/ -> worked fine.  It created
    1. attachments-20210129124631.tar.gz
    2. conf-20210129124631.tar.gz
    3. postgresql-dump-20210129124631.pgdump
  2. Also i copied /etc/openproject to my local drive according to "Moving Configuration" Section of the guide
  3. "openproject config:get DATABASE_URL" gives "postgresql://openproject:mypassword@localhost/openproject"

On the new installation:

  1. i followed the installation guide (https://docs.openproject.org/installation-and-operations/installation/packaged/#ubuntu-2004)
  2. had to install gnupg2 fist to import the key
  3. Afterwards i did "apt-get install openproject" which went through fine. Now my problems start (having no knowledge of databases). 
  4. copied the 3 backupfiles to /home/myuser
  5. copied /etc/openproject from local to the new installation - had to add my user to the group openproject + give permissions via chmod to my user to do this

After the guide says "On your new host or cluster, ensure you have created a database user and database, ideally using the same names as the old environment (You may want to choose a different random password, however)." So i tried that - but it seems the tutorials i found were not really the best/didn't work.

Because after "doing (well it doesn't work - so guess i did it wrong)" so 

"pg_restore -h localhost -u openproject -W openproject --clean postgresql-dump-20210129124631.pgdump" gives 

'"/usr/lib/postgresql/12/bin/pg_restore: invalid option -- 'u' "

I was able to create a user and a database - but it seems the privileges are somehow wrong (e.g. database openproject owner is postgres). Tried to solve this for 6 hours today - no success. 

Could you give me a hint to a good tutorial that shows how to create database/password and user? Or if you think this might not be the problem - any hint will be great.


Loading...