تكوين Discourse لاستخدام خادم PostgreSQL منفصل

maggiomj · 20 سبتمبر 2023، 2:29م

No sir, no problem. Thanks for the info

dalu74 · 21 ديسمبر 2023، 4:04م

In my case, it was because I had scram-sha-256 and not trust as the auth mechanism.
Because scram-sha-256 requires a physical user.
You can probably work around that by creating a user map in pg_ident.conf but I’m not sure how.

mpalmer · 22 ديسمبر 2023، 3:34ص

If by “physical user” you mean “Unix system user” then no, scram-sha-256 does not require such a user configured on the system. The peer method requires a system user, and trust is just a terrible idea all around when you’re using a remote database server.

harishg33 · 23 يوليو 2025، 8:12ص

Will we have to include the following in addition to the existing process ?

CREATE EXTENSION vector;

since I see this extension in the discourse_docker postgres template ?

github.com/discourse/discourse_docker

templates/postgres.template.yml

c36fb7907


      
          
          - file:
              path: /usr/local/bin/create_db
              chmod: +x
              contents: |
                #!/bin/bash
                su postgres -c 'createdb $db_name' || true
                su postgres -c 'psql $db_name -c "create user $db_user;"' || true
                su postgres -c 'psql $db_name -c "grant all privileges on database $db_name to $db_user;"' || true
                su postgres -c 'psql $db_name -c "alter schema public owner to $db_user;"'
                su postgres -c 'psql template1 -c "create extension if not exists hstore;"'
                su postgres -c 'psql template1 -c "create extension if not exists pg_trgm;"'
                su postgres -c 'psql template1 -c "create extension if not exists vector;"'
                su postgres -c 'psql template1 -c "alter extension vector update;"' || true
                su postgres -c 'psql $db_name -c "create extension if not exists hstore;"'
                su postgres -c 'psql $db_name -c "create extension if not exists pg_trgm;"'
                su postgres -c 'psql $db_name -c "create extension if not exists vector;"'
                su postgres -c 'psql $db_name -c "alter extension vector update;"' || true
                sudo -u postgres psql $db_name <<< "update pg_database set encoding = pg_char_to_encoding('UTF8') where datname = '$db_name' AND encoding = pg_char_to_encoding('SQL_ASCII');" || true

Falco · 24 يوليو 2025، 11:18م

That is used by the Discourse AI core plugin, so you will need that if you are using it.

harishg33 · 25 يوليو 2025، 2:59ص

I don’t remember enabling that plugin. Infact I just checked that it is disabled. But recently when i rebuilt the image, when the latest commit went beyond this commit - GitHub - discourse/discourse at 0eab7daea450e1d7e416c46a23aaaf95687d4855, rake db:migrate started failing. When i used the commit just before the above one to bootstrap, it continued to work.

Now that I have enabled this extension, commits later than this is working without issues.

pfaffman · 25 يوليو 2025، 5:54ص

But now the ai plugin is in core, so you need the extension regardless of whether you use the AI plugin (or contrive to explicitly remove it), right?

Falco · 25 يوليو 2025، 4:48م

Oh that’s true, as migrations are ran independently of the plugin being enabled.

الموضوع		الردود	مرات العرض
External postgres setup not working Installation	4	668	11 أبريل 2023
discourse容器部署方式下，如何在外部连接到数据库，例如使用DBeaver连接 Support	2	80	28 مايو 2025
Error while doing discourse setup Installation	11	3011	6 أكتوبر 2017
Using a PGSQL database outside of Docker? Installation	6	1480	12 أكتوبر 2021
Accessing Database while discourse not running Dev	0	50	19 أبريل 2025

تكوين Discourse لاستخدام خادم PostgreSQL منفصل

الموضوعات ذات الصلة