Ecosystem:Issue tracking system (ITS)

Apache Bloodhound

Provider -- Apache Software Foundation
Website -- http://bloodhound.apache.org/
License -- open source (Apache License 2.0)
Interoperability level -- explicitly supports PostgreSQL (no specific version is specified)
Verified PostgreSQL versions -- didn't actually run the program, but just checked the documentation
Last update (YYYY-MM-DD) -- 2017-1-6
Description -- Apache Bloodhound is a web-based project management and issue tracking software written in Python. It's built on top of Trac, and provides built-in Wiki and full text search. PostgreSQL is the recommended database among the supported databases.
Additional info -- click here

Provider -- Ivaldi
Website -- https://github.com/ivaldi/brimir
License -- open source (AGPLv3)
Interoperability level -- explicitly supports PostgreSQL (no specific version is specified)
Verified PostgreSQL versions -- didn't actually run the program, but just checked the documentation
Last update (YYYY-MM-DD) -- 2017-1-27
Description -- Brimir is a simple helpdesk system that can be used to handle support requests via incoming email. Brimir is a Ruby on Rails application.
Additional info -- click here

Provider -- Mozilla Foundation
Website -- https://www.bugzilla.org/
License -- open source (MPL)
Interoperability level -- explicitly supports PostgreSQL 8.3 or higher
Verified PostgreSQL versions -- didn't actually run the program, but just checked the documentation
Last update (YYYY-MM-DD) -- 2017-1-27
Description -- Bugzilla is a web-based bug tracking system that can run on many operating systems, including Windows, Linux, and Mac. Bugzilla is used by various organizations such as the Mozilla Foundation, Linux Kernel, Red Hat, Apache, LibreOffice and Eclipse. Bugzilla recommends MySQL and PostgreSQL over Oracle and SQLite.
Additional info -- click here

Provider --
Website -- http://www.fusionforge.org/
License -- open source (GPLv2+)
Interoperability level -- explicitly supports PostgreSQL 8.x or higher
Verified PostgreSQL versions -- didn't actually run the program, but just checked the documentation
Last update (YYYY-MM-DD) -- 2017-1-27
Description -- FusionForge is a project hosting software, a descendant of the forge originally created for running the SourceForge.net platform, which helps to manage the entire development lifecycle. FusionForge provides collaboration tools like forums, mailing lists and wiki; access to source code management (SCM) repositories like Git and Subversion; document and file release management; news announcements and surveys; issue tracking and task management.
Additional info -- click here

Provider -- Atlassian, Inc.
Website -- https://www.atlassian.com/software/jira
License -- proprietary
Interoperability level -- explicitly supports PostgreSQL from 9.0 to 9.3
Verified PostgreSQL versions -- didn't actually run the program, but just checked the documentation
Last update (YYYY-MM-DD) -- 2016-12-22
Description -- JIRA is an issue and project tracking system for software teams. JIRA is the #1 software development tool used by agile teams. JIRA can integrate with various version control systems like Clearcase, CVS, Git, Mercurial, Perforce, Subversion, and Microsoft TFS.
Additional info -- click here

Provider -- MantisBT Team (Kenzaburo Ito and various developers)
Website -- https://www.mantisbt.org/
License -- open source (GPLv2)
Interoperability level -- explicitly supports PostgreSQL 9.2 or higher
Verified PostgreSQL versions -- didn't actually run the program, but just checked the documentation
Last update (YYYY-MM-DD) -- 2017-1-27
Description -- Mantis Bug Tracker is a web-based bug tracking system.
Additional info -- click here

Provider -- OTRS Group
Website -- https://www.otrs.com/
License -- open source (AGPLv3)
Interoperability level -- explicitly supports PostgreSQL 8.4 or higher
Verified PostgreSQL versions -- didn't actually run the program, but just checked the documentation
Last update (YYYY-MM-DD) -- 2017-1-27
Description -- OTRS is one of the most flexible web-based ticketing systems used for Customer Service, Help Desk, IT Service Management.
Additional info -- click here

Provider -- Jean-Philippe Lang
Website -- http://www.redmine.org/
License -- open source (GPLv2)
Interoperability level -- explicitly supports PostgreSQL 8.2 or higher
Verified PostgreSQL versions -- didn't actually run the program, but just checked the documentation
Last update (YYYY-MM-DD) -- 2017-2-3
Description -- Redmine is the most popular among project planning tools. Redmine is a Web-based project management and issue tracking tool. It supports multiple projects and associated subprojects, per project wikis and forums, time tracking, Gantt charts and calendars, and role-based access control. Redmine integrates with various version control systems such as Git and Subversion.
Additional info -- click here

Provider -- Best Practical Solutions, LLC
Website -- https://bestpractical.com/request-tracker
License -- open source (GPLv2)
Interoperability level -- explicitly supports PostgreSQL 8.4 or higher
Verified PostgreSQL versions -- didn't actually run the program, but just checked the documentation
Last update (YYYY-MM-DD) -- 2017-2-3
Description -- Request Tracker is a ticket-tracking system used to coordinate tasks and manage requests among a community of users.
Additional info -- click here

Provider -- Richard Jones, Roundup-Team
Website -- http://roundup-tracker.org/
License -- open source (MIT)
Interoperability level -- explicitly supports PostgreSQL 7.x or higher
Verified PostgreSQL versions -- didn't actually run the program, but just checked the documentation
Last update (YYYY-MM-DD) -- 2017-2-3
Description -- Roundup is a simple-to-use and -install issue-tracking system with command-line, web and e-mail interfaces.
Additional info -- click here

Provider -- Seapine Software
Website -- http://www.seapine.com/testtrack/overview
License -- proprietary
Interoperability level -- explicitly supports PostgreSQL (no specific version is specified)
Verified PostgreSQL versions -- didn't actually run the program, but just checked the documentation
Last update (YYYY-MM-DD) -- 2017-1-30
Description -- TestTrack is a comprehensive application lifecycle management software. It manages all product development phases and artifacts, from requirements and user stories through QA cycles and deployment, with ONE SOLUTION.
Additional info -- click here

Provider -- various developers
Website -- http://www.thebuggenie.com/
License -- open source (Mozilla Public License 2.0)
Interoperability level -- explicitly supports PostgreSQL 8.2 or higher
Verified PostgreSQL versions -- didn't actually run the program, but just checked the documentation
Last update (YYYY-MM-DD) -- 2017-1-30
Description -- The Bug Genie is a Web-based project management and bug tracking system. It offers ticket tracking, collaboration via Wiki, and integration with major version control systems such as Git and Subversion.
Additional info -- click here

Provider -- Edgewall Software
Website -- https://trac.edgewall.org/
License -- open source (modified BSD license)
Interoperability level -- explicitly supports PostgreSQL 8.0 or higher
Verified PostgreSQL versions -- didn't actually run the program, but just checked the documentation
Last update (YYYY-MM-DD) -- 2017-1-30
Description -- Trac is a Web-based project management and bug tracking system. Trac offers ticket tracking, collaboration via Wiki, and integration with major version control systems such as Git and Subversion. Trac is used, among others, by the Internet Research Task Force, Django, jQuery UI, OpenStreetMap, WebKit and WordPress.
Additional info -- click here