[PR #4087] [CLOSED] Add Postgresql support #3810

Closed
opened 2026-02-26 08:32:02 +03:00 by kerem · 0 comments
Owner

📋 Pull Request Information

Original PR: https://github.com/NginxProxyManager/nginx-proxy-manager/pull/4087
Author: @Dim145
Created: 10/19/2024
Status: Closed

Base: developHead: develop


📝 Commits (3)

  • 0527227 add postgresql support
  • 33562fb refactor: adapt many sql queries for postgresql
  • 170239c add docker compose file for postgres ci

📊 Changes

13 files changed (+224 additions, -40 deletions)

View changed files

📝 backend/internal/access-list.js (+9 -4)
📝 backend/internal/audit-log.js (+4 -3)
📝 backend/internal/dead-host.js (+3 -2)
📝 backend/internal/host.js (+4 -3)
📝 backend/internal/proxy-host.js (+3 -2)
📝 backend/internal/redirection-host.js (+3 -2)
📝 backend/internal/stream.js (+2 -1)
📝 backend/lib/config.js (+41 -0)
📝 backend/lib/helpers.js (+18 -2)
📝 backend/package.json (+2 -1)
📝 backend/setup.js (+4 -4)
📝 backend/yarn.lock (+102 -16)
docker/docker-compose.ci.postgresql.yml (+29 -0)

📄 Description

I have adapted most of the SQL queries using the ‘objection’ library as much as possible.
These were tested in a containerised app with the Postgres and MySQL databases.

I haven't tested SSL certificate creation, but the queries in this section are normally compatible.


🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.

## 📋 Pull Request Information **Original PR:** https://github.com/NginxProxyManager/nginx-proxy-manager/pull/4087 **Author:** [@Dim145](https://github.com/Dim145) **Created:** 10/19/2024 **Status:** ❌ Closed **Base:** `develop` ← **Head:** `develop` --- ### 📝 Commits (3) - [`0527227`](https://github.com/NginxProxyManager/nginx-proxy-manager/commit/05272273171a2b0cf0ac4d256dd15d9fd1c93252) add postgresql support - [`33562fb`](https://github.com/NginxProxyManager/nginx-proxy-manager/commit/33562fb2c0358281e589350c1ee95f31c56f7365) refactor: adapt many sql queries for postgresql - [`170239c`](https://github.com/NginxProxyManager/nginx-proxy-manager/commit/170239cec136c99672feb1795360b458b37c7c2d) add docker compose file for postgres ci ### 📊 Changes **13 files changed** (+224 additions, -40 deletions) <details> <summary>View changed files</summary> 📝 `backend/internal/access-list.js` (+9 -4) 📝 `backend/internal/audit-log.js` (+4 -3) 📝 `backend/internal/dead-host.js` (+3 -2) 📝 `backend/internal/host.js` (+4 -3) 📝 `backend/internal/proxy-host.js` (+3 -2) 📝 `backend/internal/redirection-host.js` (+3 -2) 📝 `backend/internal/stream.js` (+2 -1) 📝 `backend/lib/config.js` (+41 -0) 📝 `backend/lib/helpers.js` (+18 -2) 📝 `backend/package.json` (+2 -1) 📝 `backend/setup.js` (+4 -4) 📝 `backend/yarn.lock` (+102 -16) ➕ `docker/docker-compose.ci.postgresql.yml` (+29 -0) </details> ### 📄 Description I have adapted most of the SQL queries using the ‘objection’ library as much as possible. These were tested in a containerised app with the Postgres and MySQL databases. I haven't tested SSL certificate creation, but the queries in this section are normally compatible. --- <sub>🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.</sub>
kerem 2026-02-26 08:32:02 +03:00
Sign in to join this conversation.
No milestone
No project
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference
starred/nginx-proxy-manager-NginxProxyManager#3810
No description provided.