Hello anyone, I currently entering a problem when I connect my database to the R Shiny. The db won't connect to my RShiny app, because of this error
i tried to configure the postgresql.conf and pg_hba.conf to change the scram into md5 and restarting the postgresql16 but it didn't work. I also add a new system variables so that it can be directed to the postgresql bin directory but i'm still facing the same issues.
thank you so much
RPosgreSQL error: could not connect postgres@localhost:5432 on dbname "postgres": SCRAM authentication requires libpq version 10 or above
>
Where is the shiny app deployed? It seems you need to update libpq (a system dependency) on that system. RpostgreSQL can indeed handle the SCRAM-SHA-256 authentication method
I am so sorry, I don't really understand what you mean by deployed, but here is my explanation
I located my shiny app in local disk D:, but I installed the postgreSQL 16 in D: too not in the regular directory which is in C:, from what I've read, the installation can affect the path to read the libpq. So, I created a new system variables path to connect in my postgreSQL's bin, but it still didn't work
My app hasn't deployed yet, I want to deploy it later when all of my data can be called in my shiny app
Very like shiny is not being able to find your libpq installation . I would recommend installing on a standard location since postgresql server is not really meant to be used on a desktop environment and there is not much information out there for setting it up on Windows with custom configurations.
Have in mind that the system where you deploy the app needs to have access to your postgresql server if you are going to be reading the data from there and this implies exposing the service to the open internet somehow.