Can't connect to postgresql after deploying to shinyapps.io ?

Posit Professional & Hosted Products shinyapps.io
,
1

I have searched and tried several ways but haven't found a solution, I hope I can get the right answer and solution here.

My apps Can't connect to Postgresql after deploying to shinyapps.io,
is it a different driver issue between my computer and shinyapps server or what?

Here is my configuration

mypw<- 'xxxxxxxx'
myPort <- '5432'
myDB <- 'shiny_DB'
myUser <- 'user1'
con <- DBI::dbConnect(odbc::odbc(),
                      Driver   = "PostgreSQL Unicode",
                      Server   = "xx.xxx.x.xx",
                      Database = myDB,
                      UID      = myUser,
                      PWD      = mypw,
                      Port     = 5432)

here is the log shown on shinyapps.io

image
image902×123 4.5 KB

Thankyou

2

Have you checked that shinyapps.io's IP addresses are allowed to connect to your Postgresql server using password authentication?

3

not yet, I'm still learning shiny and postgresql. how, what should i do next,

4

You have to make sure Postgresql is listening on a suitable IP by setting the listen_addresses option on the postgresql.conf file, many people change the setting to *, meaning all available IP addresses.

Then you have to set the proper inbound rules on the pg_hba.conf file, for example, this rule would accept connections from any IP and any user with password authentication.

host      all      all      0.0.0.0/0       password

Also, if there is a firewall installed in your system you need to check that it is not blocking incoming traffic on port 5432

Now, if you are self hosting Postgresql at home, you need to check that incoming traffic on port 5432 is being forwarded towars your server's local IP, and if you are hosting on a cloud computing platform like AWS, you need to check your security rules to make sure incoming traffic is allowed on that port.

Sadly, I can't be any more specific since this configurations are very specific to your particular system and also, outside of this forum's scope.