postgresql connection : Failed to connect

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 

0 5 468
5 REPLIES 5

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

Steve
Platinum 5
Platinum 5

You can't use localhost.

Steve_0-1727443914519.png

See also: Use data from PostgreSQL

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.

 

Steve
Platinum 5
Platinum 5

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

I don't believe so.

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

Top Labels in this Space