Configure Discourse to use a separate PostgreSQL server

Falco · 8 januari 2026 om 18:17

We merged a PR to handle this last month, are you on the latest version?

github.com/discourse/discourse

FIX: Check for pgvector before CREATE EXTENSION

main ← awensaunders:patch-1

merged 03:42PM - 01 Dec 25 UTC

awensaunders

+12 -10

On certain hosting environments (azure postgres flex notably) CREATE EXTENSION r…equires a high level of permissions if the extension in question is marked as "untrusted" by postgres. This level of permission might not be available at runtime if the database user has low privileges. Unfortunately, the migration currently tries to CREATE EXTENSION even if the "vector" extension already exists, which causes an unavoidable permission error. This PR just adds a check to see if "vector" is already present, and skips if it is.

Topic		Antwoorden	Weergaven
External postgres setup not working Installation	4	709	11 april 2023
Error while doing discourse setup Installation	11	3026	6 oktober 2017
discourse容器部署方式下，如何在外部连接到数据库，例如使用DBeaver连接 Support	2	117	28 mei 2025
Using a PGSQL database outside of Docker? Installation	6	1507	12 oktober 2021
Update from 2.9.0 beta2 to beta4 failed (my site is down) Installation	26	1712	11 juni 2022

Configure Discourse to use a separate PostgreSQL server

Gerelateerde topics