הגדר את Discourse להשתמש בשרת PostgreSQL נפרד

maggiomj · 20 בספטמבר,‏ 2023,‏ 2:29pm

No sir, no problem. Thanks for the info

dalu74 · 21 בדצמבר,‏ 2023,‏ 4:04pm

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:34am

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:12am

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:18pm

זה משמש את תוסף הליבה של Discourse AI, כך שתצטרך אותו אם אתה משתמש בו.

harishg33 · 25 ביולי,‏ 2025,‏ 2:59am

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:54am

אבל עכשיו תוסף ה-AI נמצא בליבה, אז אתה צריך את ההרחבה ללא קשר אם אתה משתמש בתוסף ה-AI (או ממציא דרך להסיר אותו במפורש), נכון?

Falco · 25 ביולי,‏ 2025,‏ 4:48pm

אה, זה נכון, מכיוון שהמיגרציות מופעלות באופן עצמאי מהפעלת התוסף.

נושא		תגובות	צפיות
External postgres setup not working Installation	4	696	11 באפריל,‏ 2023
discourse容器部署方式下，如何在外部连接到数据库，例如使用DBeaver连接 Support	2	99	28 במאי,‏ 2025
Error while doing discourse setup Installation	11	3018	6 באוקטובר,‏ 2017
Using a PGSQL database outside of Docker? Installation	6	1495	12 באוקטובר,‏ 2021
Accessing Database while discourse not running Dev	0	62	19 באפריל,‏ 2025

הגדר את Discourse להשתמש בשרת PostgreSQL נפרד

נושאים קשורים