Configure Discourse to use a separate PostgreSQL server

Falco · January 8, 2026, 6:17pm

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		Replies	Views
Error while doing discourse setup Self-hosting	11	3033	October 6, 2017
External postgres setup not working Self-hosting	4	714	April 11, 2023
discourse容器部署方式下，如何在外部连接到数据库，例如使用DBeaver连接 Support	2	126	May 28, 2025
Update from 2.9.0 beta2 to beta4 failed (my site is down) Self-hosting	26	1738	June 11, 2022
Accessing Database while discourse not running Dev	0	92	April 19, 2025

Configure Discourse to use a separate PostgreSQL server

Related topics