Using a PGSQL database outside of Docker?

[ylluminate]

I’m doing the standard Docker installation of Discourse, however it appears that there are some quirks regarding the database. First, I don’t see any listing for a production database within the config/database.yml (only development, test and profile), but it appears that the Dockerized system is using PostgreSQL.

What is the proper method for directing the standard Dockerized installation to use a PostgreSQL database on another server?

[cpradio]

I would start with

Configure Discourse to use a separate PostgreSQL server

Let’s say you’re using AWS RDS, or an existing PostgreSQL server managed elsewhere. It’s fairly straightforward to get Discourse to use such a setup, without needing to grant superuser privileges to anything that Discourse itself runs. Here’s how. Prerequisites Discourse requires PostgreSQL 13; if you try to run on a newer or older version, it might work, but we don’t guarantee it, and if something breaks in the future, you get to keep both pieces. We also require some extensions that are di…

Can’t promise it still doesn’t use Docker, but it might get you started on the right track.

[ylluminate]

Thanks @cpradio this worked out rather well and works with any database (ie, even non-Docker database instances), but there was one major hiccup: It’s not made clear that the process will not transfer the database info over and any existing tables will be effectively lost.

I guess the followup would be: If one were to want to retain the data after moving to a separate database, what’s the process for that?

[Falco]

@ylluminate

I guess the followup would be: If one were to want to retain the data after moving to a separate database, what’s the process for that?

Take a backup before, restore after.

[ylluminate]

Yeah, was afraid you’d say that @Falco. I guess the question evolves to be: how do you get a backup of the pgsql instance that Discourse is using / how do you get into that instance? ./launcher enter postgres?

So I’ve removed the template line from the app.yml, I guess that means I need to put that back in and then ./launcher rebuild app? Or is there a better way?

And if I do this, does that mean it will try to use the Docker pgsql db again and thus screw the app up temporarily while I have that active?

I guess a kind of complete snapshot of what’s happening there and how to interact with it and what’s to be expected (such as perhaps the new external db no longer being used temporarily while recovering the Dockerized pgsql instance)…