Discourse安装是否设置了默认的Postgres密码？

安装
1

Hi, I’m trying to get into the Discourse PostgreSQL database to learn how it’s laid out so I can do some tweaks to the import script to meet my specific needs.

Only problem is that I can’t get into psql in the docker.

When I run: psql root -h localhost I am asked for a password.

I’ve tried just hitting ENTER (psql documentation states there is no default password) but I’m told it’s incorrect.

What’s the best practice for accessing the raw database? Or is there a wiki here that shows the database structure? That’s really what I need. I have the Data Explorer plugin running, so I could explore from there, but that would be easier to do if I knew how the database is laid out.

Thanks in advance for any help!

1 个赞
2

Try

su postgres
psql
7 个赞
3

Thanks! That worked. I also dug into Data Explorer a little more and realized I could build my queries from that and didn’t even need direct db access. Helpful to know though.

3 个赞
4

我有同样的问题。是否有密码？如果有，它在配置的哪个位置？

更改 psql 用户密码（例如密码轮换）是否安全？相应的密码应在配置的哪个位置更新？

如果运行针对数据库的 Python 脚本，最好使用相同的密码，否则需要修改 yml 文件来创建单独的数据库用户和密码并授予权限。