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 ...
had an abnormal shutdown and after recovery Confluence would not start due to version mismatch between the postgres database confluence. I read the docs on that and it clearly stated that if t...
I made a Confluence on a VM and a Postgres on the other one. I synchronized them by configuring pg_hba.conf for Postgres and confluence.cfg.xml for Confluence that they are working well. However, I...
Does it has any scanning patterns for database not like Linux_Applicdation_.... i need like Linux_Database.... Thank you
We have an issue where we are on a unsupported version of PostgreSQL and wanted to upgrade to a supported version. We were attempting to use the pg_upgrade method to update to PostgreSQL 12.9.1...
I am looking for a Bitbucket POSTGRESQL query to list all the projects and repositories with user permissions.
Hello there! I need to create a report to determine the issue types that are not currently in use in our JIRA server instance (8.13). I have access to query the postgres database (psql 9.2.24, s...
Copied to clipboard