neon-tech PostgreSQL database compute is suspended
I am using neon-tech free plan. i was using the PostgreSQL database and now i see that the compute is suspended. can someone help me as i am unable to connect to the database now.
4 Replies
ambitious-aquaOP•6mo ago
It says that will be automatically made active when clients try to connect, but i am unable to connect to the DB. How to trouble shoot ?
optimistic-gold•6mo ago
Try accessing your database via the Neon SQL Editor or psql:
https://neon.tech/docs/get-started-with-neon/query-with-neon-sql-editor
https://neon.tech/docs/connect/query-with-psql-editor
Any SQL query should make the compute active again.
You can also check your billing page in the Neon Console to ensure that you haven't exceeded your compute hours for the month.
If everything seems OK, check the data connection string in your app to make sure it's correct. Compare against the connection string in the Neon Console (look for the Connect button on your Project Dashboard).
Neon
Query with Neon's SQL Editor - Neon Docs
The Neon SQL Editor allows you to run queries on your Neon databases directly from the Neon Console. In addition, the editor keeps a query history, permits saving queries, and provides Explain and Ana...
Neon
Connect with psql - Neon Docs
The following instructions require a working installation of psql. The psql client is the native command line client for Postgres. It provides an interactive session for sending commands to Postgres a...
ambitious-aquaOP•6mo ago
Error
at https://dfv3qgd2ykmrx.cloudfront.net/assets/assets/app-DFwI5zKN.js:18:46204
at async https://dfv3qgd2ykmrx.cloudfront.net/assets/assets/DrizzleStudio-DI3kCFm6.js:1:3124
at async window.drizzle (https://dfv3qgd2ykmrx.cloudfront.net/assets/assets/DrizzleStudio-DI3kCFm6.js:1:3797)
at async a (https://dfv3qgd2ykmrx.cloudfront.net/assets/assets/load-bundle-DMyOSDOn.js:1210:66475)
at async query (https://dfv3qgd2ykmrx.cloudfront.net/assets/assets/load-bundle-DMyOSDOn.js:407:1648)
at async Promise.all (index 0)
at async Xde (https://dfv3qgd2ykmrx.cloudfront.net/assets/assets/load-bundle-DMyOSDOn.js:257:44)
at async pull (https://dfv3qgd2ykmrx.cloudfront.net/assets/assets/load-bundle-DMyOSDOn.js:407:2188)
Error while connecting to database through SQL editor
This is the error whle tryin to restart the end-point through APIs:
{
"request_id": "8f228a67-1485-4c9a-8ded-46d2c57ba303",
"code": "",
"message": "endpoint is not active, could not restart"
}
optimistic-gold•6mo ago
The
restart API only works for active endpoints. Try the start API:
https://api-docs.neon.tech/reference/startprojectendpoint
I am also wondering if this is a DNS issue.
Please try this from a terminal:
nslookup your-endpoint-hostname-neon.tech
For example:
nslookup ep-rapid-moon-a5vtkabc-pooler.us-east-2.aws.neon.tech