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
Error while doing discourse setup Self-hosting	11	3034	6 oktober 2017
External postgres setup not working Self-hosting	4	717	11 april 2023
discourse容器部署方式下，如何在外部连接到数据库，例如使用DBeaver连接 Support	2	131	28 mei 2025
Update from 2.9.0 beta2 to beta4 failed (my site is down) Self-hosting	26	1740	11 juni 2022
Accessing Database while discourse not running Dev	0	94	19 april 2025

Configure Discourse to use a separate PostgreSQL server

Gerelateerde topics