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
External postgres setup not working Installation	4	705	April 11, 2023
Error while doing discourse setup Installation	11	3018	October 6, 2017
discourse容器部署方式下，如何在外部连接到数据库，例如使用DBeaver连接 Support	2	106	May 28, 2025
Update from 2.9.0 beta2 to beta4 failed (my site is down) Installation	26	1683	June 11, 2022
Using a PGSQL database outside of Docker? Installation	6	1498	October 12, 2021

Configure Discourse to use a separate PostgreSQL server

Related topics