N
Neon•8mo ago
itchy-amethyst

change status of db from idle to active

how can i change the status of neon db from idle to active ?
3 Replies
correct-apricot
correct-apricot•8mo ago
I think that you should be able to by just connecting from a client or your app. That will automatically activate your database. Another option is to open the Neon SQL Editor and execute a query.
And if you want to do this programmatically, you could use the Neon API. Eg. justhi t the Start endpoint to activate it. Example:
   curl --request POST \
      --url https://console.neon.tech/api/v2/projects/<project_id>/endpoints/<endpoint_id>/restart \
      --header 'accept: application/json' \
      --header 'authorization: Bearer $NEON_API_KEY'
   
   curl --request POST \
      --url https://console.neon.tech/api/v2/projects/<project_id>/endpoints/<endpoint_id>/restart \
      --header 'accept: application/json' \
      --header 'authorization: Bearer $NEON_API_KEY'
rival-black
rival-black•6mo ago
I've tried steps 1 and 2, but it's still idle. What should I do?
silky-coral
silky-coral•6mo ago
Hi, the database will automatically restart when queried. For example, you can run a select query (e.g., SELECT version();) from the Neon SQL Editor. This start compute endpoint will also restart your database: https://api-docs.neon.tech/reference/startprojectendpoint Your Postgres database runs on a compute. It starts when the compute starts.
Neon
Start compute endpoint
Starts a compute endpoint. The compute endpoint is ready to use after the last operation in chain finishes successfully. You can obtain a project_id by listing the projects for your Neon account. You can obtain an endpoint_id by listing your project's compute endpoints. An endpoint_id has an ep- pre...

Did you find this page helpful?