I have a discourse install using docker and I was wondering how do I find/connect to the database connection information like (username,db,password), Thanks in advanced! ![]()
AI-generated summary
A user asks how to obtain database connection details (username, password, etc.) for a Docker-based Discourse installation to migrate from Discourse to XenForo using the Discourse-to-XenForo importer. pfaffman suggests using the API or data explorer plugin instead of external database access, which is discouraged. ScrapBlox clarifies the need for PostgreSQL info to run the importer. pfaffman recommends simply exporting a database dump and restoring it on a new PostgreSQL server as a safer and more effective solution.
What problem are you trying to solve?
You can get to postgres like
./launcher enter app
su - postgres
psql
You can use the data explorer plugin to do queries from the UX.
I think the user is discourse and allows connection from within the container.
I was trying to get the database connection information like username and password so I could connect from an external source but I don’t know how to get the connection info.
The way to do that is usually to use the API or the data explorer plugin.
It’s possible to enter the container like I said and add a user and then open the port on the app.yml, but that’s usually not recommended.
What problem are you trying to solve by connecting from an external source?
I’m looking to migrate my forum from discourse to XenForo for reasons of it being lighter/cheaper to run/host. (Don’t get me wrong discourse is still great software love what was made here)
Running the Discourse to XF importer needs postgresql info..
Then just get a database dump and restore it to another postgres server.