[GH-ISSUE #1657] Postgres configuration should support `postgresql` scheme/protocol specifier #1158

New issue

Closed

opened 2026-05-07 00:30:41 +02:00 by BreizhHardware · 3 comments

BreizhHardware commented

2026-05-07 00:30:41 +02:00

Owner

Originally created by @BradStaton on GitHub (Mar 15, 2026).
Original GitHub issue: https://github.com/binwiederhier/ntfy/issues/1657

🐞 Describe the bug
In ntfy version 2.19.0 if NTFY_DATABASE_URL is set to a URL beginning with postgresql:// the application will fail to start with the message if database-url is set, it must start with postgres://. The postgresql:// option worked in version 2.18.0 and is the default format generated by CloudNativePG. The PostgreSQL documentation also uses postgresql:// when specifying connection URLs.

💻 Components impacted
ntfy server

💡 Screenshots and/or logs

if database-url is set, it must start with postgres://                                                                                                                                                
stream closed: EOF for ntfy/ntfy-5df644b984-474p8 (ntfy)

🔮 Additional context
Ideally both postgresql:// and postgres:// should be supported.

Originally created by @BradStaton on GitHub (Mar 15, 2026). Original GitHub issue: https://github.com/binwiederhier/ntfy/issues/1657 :lady_beetle: **Describe the bug** In ntfy version 2.19.0 if `NTFY_DATABASE_URL` is set to a URL beginning with `postgresql://` the application will fail to start with the message `if database-url is set, it must start with postgres://`. The `postgresql://` option worked in version 2.18.0 and is the default format generated by [CloudNativePG](https://cloudnative-pg.io/). The [PostgreSQL documentation](https://www.postgresql.org/docs/current/libpq-connect.html#LIBPQ-CONNSTRING-URIS) also uses `postgresql://` when specifying connection URLs. :computer: **Components impacted** ntfy server :bulb: **Screenshots and/or logs** ``` if database-url is set, it must start with postgres:// stream closed: EOF for ntfy/ntfy-5df644b984-474p8 (ntfy) ``` :crystal_ball: **Additional context** Ideally both `postgresql://` and `postgres://` should be supported.

BreizhHardware

2026-05-07 00:30:41 +02:00

closed this issue
added the
🪲 bug
label

BreizhHardware commented

2026-05-07 00:30:42 +02:00

Author

Owner

@binwiederhier commented on GitHub (Mar 15, 2026):

Apologies. I'll fix that in the next one

@binwiederhier commented on GitHub (Mar 15, 2026): Apologies. I'll fix that in the next one

BreizhHardware commented

2026-05-07 00:30:42 +02:00

Author

Owner

@BradStaton commented on GitHub (Mar 15, 2026):

Thanks! I created a PR here.

@BradStaton commented on GitHub (Mar 15, 2026): Thanks! I created a PR [here](https://github.com/binwiederhier/ntfy/pull/1658).

BreizhHardware commented

2026-05-07 00:30:42 +02:00

Author

Owner

@binwiederhier commented on GitHub (Mar 16, 2026):

Thx

@binwiederhier commented on GitHub (Mar 16, 2026): Thx

BreizhHardware referenced this issue

2026-05-07 01:02:30 +02:00

[PR #1158] [CLOSED] update command when runnig from docker #1526