Welcome to the Inedo Forums! Check out the Forums Guide for help getting started.
If you are experiencing any issues with the forum software, please visit the Contact Form on our website and let us know!
2026 upgrade fails at PG-3367 (0A000) when ProGet is installed in a non-public PostgreSQL schema
-
Hi,
Upgrading ProGet 2025.26 (Build 11) to 2026.12 (Build 24) fails on our external PostgreSQL database. We can reproduce it locally with a minimal setup.Environment
- ProGet 2025.26 (Build 11) → 2026.12 (Build 24), Docker image
- External PostgreSQL 17.11 (Azure Database for PostgreSQL Flexible Server in production;
postgres:17for the repro) - Database user
proget, defaultsearch_path("$user", public)
Error shown in logs
Executing tracked script DDL-DML/v26/26.x - Maintenance/PG-3367 IncreaseConnectorResponseContentType.sql... 0A000: cannot alter type of a column used by a view or rule At least one script reported an error.Every restart afterwards reports "Scripts not executed; at least one script has unresolved errors", and the schema stays at 25.0.26.11.
Cause, as far as we can tell
On our managed PostgreSQL, theprogetuser can't create objects inpublic(the PostgreSQL 15+ default), so a schema namedproget(owned byproget) was created. Through the defaultsearch_path, ProGet installed all its objects there. During the upgrade,DDL-DML/0000. Untracked/10. Drop all procs, types, views.sqldoesn't drop them. It has no logs like "drop cascades to ..." lines at all.
The old viewproget."ConnectorResponses_Slim"therefore still exists, and PG-3367 can't alterConnectorResponses.Content_Type. It looks like installation followssearch_path, but the cleanup only coverspublic.
Minimal reproduction- Start
postgres:17with databaseprogetand userproget. - Before ProGet's first start:
CREATE SCHEMA proget AUTHORIZATION proget; - Start ProGet
25.0.26withPROGET_POSTGRES_CONNECTION_STRING=Host=...;Database=proget;Username=proget;Password=.... All objects are created in schemaproget. - Switch to image
26.0.12and start it. PG-3367 fails with0A000.
Question
- Is installing ProGet into a non-
publicschema supported? If not, could the installer detect it and fail at install time, rather than at a later upgrade?
Hello! It looks like you're interested in this conversation, but you don't have an account yet.
Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.
With your input, this post could be even better 💗
Register Login