Top Menu

Jump to content
    Modules
      • Projects
      • Activity
      • Work packages
      • Gantt charts
      • Calendars
      • Team planners
      • Boards
      • News
    Home
    • 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

      OpenProject ID Google

Side Menu

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

Content

Expand project menu
General discussion
  1. OpenProject Community
  2. OpenProject
  3. Forums
  4. General discussion
  5. Connect to postgres database

Connect to postgres database

Added by Rodrigo Vila about 5 years ago

Hi everyone,

I need to connect to the Postgres database in order to make some reports, and I forgot the password. I am using PgAdmin or PowerBI. Can anyone help me?

Thanks,

Rodrigo


Replies (2)

RE: Connect to postgres database - Added by John R about 5 years ago

From a reporting standpoint, I would like to see this also. Last time I tried to connect directly to PostgreSQL I crashed the server hosting OpenProject :(
Most likely this is a Linux/PostgreSQL configuration setting (ports?).

RE: Connect to postgres database - Added by Oliver Günther about 5 years ago

On a packaged installation, you can get the connection details of the OpenProject database through the ENV flag DATABASE_URL.

openproject config:get DATABASE_URL

You can use this with psql directly: psql $(openproject config:get DATABASE_URL)

This can never crash OpenProject unless

  • you're somehow exceeding the max_connections of postgres, but then still OpenProject server would still hold to its connections
  • you're doing anything other than reading/updating or inserting according to the scheme in a way that is unsupported by OpenProject

In a docker-based installation, you can simply exec on the database container and run psql directly from there.

Best

Oliver

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