[PR #1066] [MERGED] Officially support PostgreSQL database #1152

Closed
opened 2026-02-04 19:22:02 +03:00 by OVERLORD · 0 comments
Owner

📋 Pull Request Information

Original PR: https://github.com/pelican-dev/panel/pull/1066
Author: @lancepioch
Created: 3/8/2025
Status: Merged
Merged: 3/30/2025
Merged by: @lancepioch

Base: mainHead: lance/postgresql


📝 Commits (10+)

  • fa3805b Just skip this table because it no longer exists
  • 2bd745c Add postgresql
  • 532dfc5 This no longer needs to be there
  • 9dad8bc These are the same output in mysql, but different in postgresql
  • 2181875 Fix these migrations for postgresql
  • 55eede5 This table no longer exists
  • ace22d7 This is expected to be a json column for json operations, required for postgresql
  • b390502 Shoot for the stars
  • e772f71 Fix pint
  • 309c2e6 Why was this missing

📊 Changes

63 files changed (+270 additions, -384 deletions)

View changed files

📝 .env.example (+0 -1)
📝 .github/workflows/ci.yaml (+76 -0)
📝 app/Filament/Admin/Resources/UserResource/Pages/CreateUser.php (+7 -0)
📝 app/Livewire/Installer/Steps/DatabaseStep.php (+19 -10)
📝 app/Models/User.php (+4 -0)
📝 app/Services/Deployment/AllocationSelectionService.php (+2 -2)
📝 config/database.php (+15 -0)
📝 database/migrations/2016_01_23_195851_add_api_keys.php (+1 -1)
📝 database/migrations/2016_01_23_200159_add_downloads.php (+2 -2)
📝 database/migrations/2016_01_23_200648_add_nodes.php (+1 -1)
📝 database/migrations/2016_01_23_201748_add_servers.php (+3 -3)
📝 database/migrations/2016_01_23_203150_add_subusers.php (+1 -1)
📝 database/migrations/2016_01_23_203159_add_users.php (+3 -3)
database/migrations/2016_01_25_234418_rename_permissions_column.php (+0 -25)
📝 database/migrations/2016_09_04_182835_create_notifications_table.php (+1 -1)
📝 database/migrations/2016_09_07_163017_add_unique_identifier.php (+1 -1)
📝 database/migrations/2016_10_07_152117_build_api_log_table.php (+2 -2)
database/migrations/2016_10_23_203522_add_foreign_permissions.php (+0 -33)
📝 database/migrations/2016_11_11_220649_add_pack_support.php (+1 -1)
📝 database/migrations/2017_01_07_154228_create_node_configuration_tokens_table.php (+1 -1)

...and 43 more files

📄 Description

No description provided


🔄 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/pelican-dev/panel/pull/1066 **Author:** [@lancepioch](https://github.com/lancepioch) **Created:** 3/8/2025 **Status:** ✅ Merged **Merged:** 3/30/2025 **Merged by:** [@lancepioch](https://github.com/lancepioch) **Base:** `main` ← **Head:** `lance/postgresql` --- ### 📝 Commits (10+) - [`fa3805b`](https://github.com/pelican-dev/panel/commit/fa3805b038c500f8c1671787f8dfab84b453fa87) Just skip this table because it no longer exists - [`2bd745c`](https://github.com/pelican-dev/panel/commit/2bd745c76f9a7eca4f248caf7c6dcb263f03ce7b) Add postgresql - [`532dfc5`](https://github.com/pelican-dev/panel/commit/532dfc58d6ca08d54c0e9ce64c49adcb1112a1f1) This no longer needs to be there - [`9dad8bc`](https://github.com/pelican-dev/panel/commit/9dad8bc4a3b353ed5c29f3b15aa944f7eaff6916) These are the same output in mysql, but different in postgresql - [`2181875`](https://github.com/pelican-dev/panel/commit/2181875cbf65c2a187f289cf0758ff31deacd59b) Fix these migrations for postgresql - [`55eede5`](https://github.com/pelican-dev/panel/commit/55eede514700673195b912a9695245b1e6bd7105) This table no longer exists - [`ace22d7`](https://github.com/pelican-dev/panel/commit/ace22d7524f153f0c8d7b37759d090a1f18fbad8) This is expected to be a json column for json operations, required for postgresql - [`b390502`](https://github.com/pelican-dev/panel/commit/b390502d86f8d84c89ceff26979273a1e1a23137) Shoot for the stars - [`e772f71`](https://github.com/pelican-dev/panel/commit/e772f71b35fa3fbc6379cfbc78e93c71b9f14e31) Fix pint - [`309c2e6`](https://github.com/pelican-dev/panel/commit/309c2e61b342091a5f96fb5726947d3f69339aaa) Why was this missing ### 📊 Changes **63 files changed** (+270 additions, -384 deletions) <details> <summary>View changed files</summary> 📝 `.env.example` (+0 -1) 📝 `.github/workflows/ci.yaml` (+76 -0) 📝 `app/Filament/Admin/Resources/UserResource/Pages/CreateUser.php` (+7 -0) 📝 `app/Livewire/Installer/Steps/DatabaseStep.php` (+19 -10) 📝 `app/Models/User.php` (+4 -0) 📝 `app/Services/Deployment/AllocationSelectionService.php` (+2 -2) 📝 `config/database.php` (+15 -0) 📝 `database/migrations/2016_01_23_195851_add_api_keys.php` (+1 -1) 📝 `database/migrations/2016_01_23_200159_add_downloads.php` (+2 -2) 📝 `database/migrations/2016_01_23_200648_add_nodes.php` (+1 -1) 📝 `database/migrations/2016_01_23_201748_add_servers.php` (+3 -3) 📝 `database/migrations/2016_01_23_203150_add_subusers.php` (+1 -1) 📝 `database/migrations/2016_01_23_203159_add_users.php` (+3 -3) ➖ `database/migrations/2016_01_25_234418_rename_permissions_column.php` (+0 -25) 📝 `database/migrations/2016_09_04_182835_create_notifications_table.php` (+1 -1) 📝 `database/migrations/2016_09_07_163017_add_unique_identifier.php` (+1 -1) 📝 `database/migrations/2016_10_07_152117_build_api_log_table.php` (+2 -2) ➖ `database/migrations/2016_10_23_203522_add_foreign_permissions.php` (+0 -33) 📝 `database/migrations/2016_11_11_220649_add_pack_support.php` (+1 -1) 📝 `database/migrations/2017_01_07_154228_create_node_configuration_tokens_table.php` (+1 -1) _...and 43 more files_ </details> ### 📄 Description _No description provided_ --- <sub>🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.</sub>
OVERLORD added the pull-request label 2026-02-04 19:22:02 +03:00
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: starred/panel#1152