PostgreSQL error

Screenshot 2023-06-19 102130.jpgData table 'Gate Keeper Matrix' is not accessible due to: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond. 

Solved Solved
0 1 106
1 ACCEPTED SOLUTION

Without knowing more details about your setup, I will start at the basics.

The issue you are having seems to be at the database side.  Either the database servers are having an issue OR the connection is being refused.  Try these things:

1)  Test the datasource entry in AppSheet to ensure your setup can successfully connect to the database instance - there is a "Test Connection" button.

2)  Make sure that you have supplied your database hosting service with the updated AppSheet IP list (it has updated recently).  If you are not aware, this IP list tells the database host that these are THE valid AppSheet machines that can connect to the database.  It needs to be accurate.  You can find the list here:  AppSheet Server IP List 

3)  If the above checks out, then check any database logs for issues or contact the provider concerning your problem to see if maybe a service needs restarted.

4)  If all of the above checks out, then you will need to contact AppSheet Support for further assistance.

View solution in original post

1 REPLY 1

Without knowing more details about your setup, I will start at the basics.

The issue you are having seems to be at the database side.  Either the database servers are having an issue OR the connection is being refused.  Try these things:

1)  Test the datasource entry in AppSheet to ensure your setup can successfully connect to the database instance - there is a "Test Connection" button.

2)  Make sure that you have supplied your database hosting service with the updated AppSheet IP list (it has updated recently).  If you are not aware, this IP list tells the database host that these are THE valid AppSheet machines that can connect to the database.  It needs to be accurate.  You can find the list here:  AppSheet Server IP List 

3)  If the above checks out, then check any database logs for issues or contact the provider concerning your problem to see if maybe a service needs restarted.

4)  If all of the above checks out, then you will need to contact AppSheet Support for further assistance.

Top Labels in this Space