Split from Different ways to start a shiny app inside docker? - #4
I have a PostgreSQL database running which I want to access. It is stated that
By default, users are only allowed to login locally if the system username matches the PostgreSQL username.
So I created a user shiny
in postgres. But I still see this error in the shiny-server logs:
Error in connection_create(names(opts), as.vector(opts)) :
could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
Calls: runApp ... <Anonymous> -> <Anonymous> -> .local -> connection_create
Execution halted
When running R as user root
it works though. Any idea what is wrong?