Budibase and PostgreSql at DigitalOcean

[adriano168]

I installed Budibase and Postgresql on 'cloud.digitalocean', I can't make the connection and fetch the tables, it returns the error: ''Error updating datasource schema''

[melohagan]

Hey @adriano168

Would you be able to provide any errors from the Network tab? (Fn+F12 on chrome)

It could also be helpful to see the schema of the PostgreSQL table.

[adriano168]

I couldn't solve it, can you help me? The Postgresql database and Budibase, both are hosted on the Digital Ocean server, but I couldn't make the connection! If necessary I grant access to my account, I would like to learn! however few people know about budibase!

[hendrikjap]

Did you enable SSL?

[adriano168]

Você ativou o SSL?

if it is the same as in the image, I tried both ways

what I can not understand the reason? when I use the connection with budibase hosted on DigitalOcean, it doesn't connect to the bank!

[jonnymccullagh]

@adriano168 you haven't mentioned whether you have postgres running on an additional Digital Ocean server or if it is the same server that is running Budibase. If it is the same server then you could try 127.0.0.1 as the Host IP address.
If it is on another server then try temporarily switching off any firewalls. You could also test connectivity by SSHing into the Budibase server and try using telnet to reach the database port e.g.

telnet 167.212.30.2 5432

This would help to determine if the connectivity is problematic regardless of Budibase. Please post your output.