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. Direct Access to PostgresSQL possible?

Direct Access to PostgresSQL possible?

Added by Thyrrel Schendzielorz almost 2 years ago

Unfortunately nobody has replied to my thread "Vanished Tasks in OpenProject" so now I want to access the PostgresSQL-DB we're using for OpenProject. If this is possible we will restore an older backup and search for the vanished tasks.
How and with which credentials ist a direct access to the OP-DB possible and will we able to find the tasks in clear text and maybe export them from the restored DB to the productive DB?

Thanks a lot for helping.


Replies (1)

RE: Direct Access to PostgresSQL possible? - Added by Jan H almost 2 years ago

Hi Thyrrel,

I have never done tested this myself, but I am fairly certain that the Postgres credentials are user=openproject and that the password is stored in the configuration files, which should be in etc/openproject.

Restoring in general is documented here: Restoring an OpenProject backup. 

If you have a testing or staging environment, you may want to restore a backup in that environment and go look for your task. If you don't, you might want to fire up a VM (new server, whatever), move your backups there, do fresh OP installation and restore your backups in that temporary environment. There you just have to make sure to use the correct credentials for the database, which I refer to above, when you do the installation. If done correctly, you can browse through your backed up data.

  • (1 - 1/1)
Loading...