Heads up! On March 5, starting at 4:30 PM Central Time, our community will be undergoing scheduled maintenance for a few hours. During this time, you will find the site temporarily inaccessible. Thanks for your patience. Read more.
×Hello, I'd like to generate the Recently Created Issues Report using SQL in Postgres and visualize it in a 3rd party BI. Well, I learned that SQL is not the best way but is there a chance? W...
Hi, We have recently tried to upgrade to Jira Service Management 10.3.0 LTS from 5.9.1. I have seen that the support for Postgresql 14 is deprecated but it should work. the scénario that we had i...
Hi I am trying to setup integration testing and wondering if there is a way to restore .sql dump file onto the test database, using postgres service. Ideally, I would like to use the tools that c...
We are seeing some weird errors in our atlassian-jira.log related to database table ownership, so I would like to confirm what database user should own the actual database tables in a Postgres d...
...nd the database is PostgreSQL. Actually, we do not change anything only we restored the backup. However, we are facing an issue while restoring the SQL backup when trying to open the Jira web site, a...
Hi Everyone, We are in the process of migrating from one JIRA server to another. The new JIRA installation is completed on a Linux machine, with JIRA version 9.4.1, and the database is PostgreS...
Hello Atlassian Community, I am currently developing a web application that integrates with Bamboo. The application needs to programmatically determine which projects and plans a specific user has a...
Hi, I would like to know if there is some DB query in PostgreSQL to get a list of all empty repositories from Bitbucket instance. Another option for me will be to get a list of all r...
I am trying to upgrade a test instance from 7.19.20 to 8.5.8 and the Confluence container acts like it can't talk to the Database / acts like it can't read the confluence.cfg.xml. I am...
...ollowing:SELECT ID, SCHEME, PERMISSION, perm_type, perm_parameter, PERMISSION_KEY, CREATED, UPDATED, group_perm_parameter FROM public.schemepermissions WHERE SCHEME=? (An I/O error occurred while s...
Hello I'm currently embarking on a proof of concept (POC) project aimed at setting up a Jira Data Center cluster with two nodes on AWS. My goal is to utilize a PostgreSQL database for this setup. C...
Hey-hey, a few guys from Atlassian Telegram community wrote me to post that cookbook into online community, so Let’s upgrade PostgreSQL from 11 to 14 on Oracle Linux 8 using YUM/RPM....
I am installing jira server v9.11.2 in Linux VM and i am using postgres DBv14.5 on prem DB where i am not able to finish the setup while creating admin user first time. I can see the JIRA is using "4...
...orking fine until recently. The versions we have here are old. Confluence is currently on version 6.10.0 Jira is version 7.10.1 BitBucket is version 5.11.1 and PostgreSQL is version 10&n...
Hi Team, I need a db query for how many service account(Ex:svc-jira) associated with one project in JIRA.
Hi Community, I have a question related to the PostgreSQL for Jira linux based server? My jira instance is running on linux based server. I have to take a DB backup but is giving error for c...
...roduct db and bitbucket required Db ? 2. can I install one more db postgreSQL only for bitbucket data center and continue using MySql for Product ?
Hello everyone, tell me what is the name of the table with all applications in the queue?
Hi all, Could someone please help me how to modify below query to be able to list all the spaces with (ONLY) last page that is modified? at the moment the below query list all pages in all spaces wi...
Does anyone know if Confluence Server / Data Center cares about or is affected by the various PostgreSQL client connection defaults as detailed here https://www.postgresql.org/docs/11/runtime-c...
Hello Team, I'm executing below DB query to get active & In active user list. I'm getting duplicate results and problem with last login date. Could anyone guide me to the proper query. SELECT...
How to pull the overall number of logins this month for JIRA? (PostgreSQL) I need this for auditing and cant seem to get a number :) I will eventually need to do this for Confluence and B...
...he issues when we hit Start Sprint. Checked many questions in the forum's but could not find the correct answer. Could someone from the community help? I need to find this in PostGreSQL.
Hi all, Well need to pull list of users within confluence-group from confluence database (PostgreSQL) and using the below query with some minor tweaks WITH last_login_date AS (SELECT u...
Hello , I want to refresh prod data to dev environment. First thing will restore prod database to dev database. I'm aware that we can move /Var home directory to dev by using RSYNC. Could ...
Copied to clipboard