postgresql connection : Failed to connect

AppSheet AppSheet Q&A
, ,
1

I am trying to connect my PostgreSQL database as a data source for my AppSheet app, but I encountered an error: “Failed to connect to database.”

Connection Details:

  • Server: Since I’m connecting from the same machine where PostgreSQL is installed, I am using “localhost.”
  • Database Name: I’m using the default database (postgres), where my table is currently located.
  • Username: I am using the default username (postgres).
  • Password: This is the password I set during the installation process.

Could you please help me troubleshoot this issue or provide some points to check why I am receiving this error? @Steve @TeeSee1 @Aurelien @AleksiAlkio @WillowMobileSys

2

In server, you have to use the IP address of your machine

3

You can’t use localhost.

Steve_0-1727443914519.png
Steve_0-1727443914519.png1312×111 18.3 KB

See also: Use data from PostgreSQL

1 Like
4

Hi @Steve @Logesh ,

I tried to use the IP address, but I still encountered the same error. Just to clarify, I am currently on the CORE plan. Could you please confirm if this plan supports using PostgreSQL as a data source? Thank you.

5

Could you please confirm if this plan supports using PostgreSQL as a data source?

I don’t believe so.

6

Alright, I’ll try to reconnect to PostgreSQL once my license has been upgraded. Thank you.

1 Like