nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

When backing up JIRA's database (postgresql) does JIRA need to stopped?

Joe_s4tavs

Or can I backup postgresql database regardless of whether JIRA is on? I couldn't find this when looking through the community articles

Is it possible for the postgresql database to be backed up at a point in time that would prevent a backup being restored properly?

Accepted answers

All comments

Alexey Matveev

It depends on the technology, which you use to backup your posgresql. If does not depend on Jira.

Joe_s4tavs

I would be using the native support for postgres i.e pg_dump to do the backups

Alexey Matveev

You can find an answer here:

https://dba.stackexchange.com/questions/13742/does-running-pg-dump-on-live-db-produce-consistent-backups

It is said, that you can do it online.

Joe_s4tavs

I understand that a postgresql database can be backed up while it is running.

Can I backup a postgresql database used by JIRA without worrying about when I do it? Does every transaction by JIRA leave the postgresql database in a recoverable/consistent state?