Error: database "strapi" does not exist

System Information
  • Node.js version: v18.20.4
  • NPM version:10.7.0
  • Strapi version: 4.25.1
  • Database: postgres:14
  • Environment: development
  • Operating system: Docker-ubuntu
  • Is your project Javascript or Typescript: Javascript

Deployed strapi on docker with postgres.

Meet following error after running for days(2024-08-06-2024-08-18) error: database "strapi" does not exist.

error logs

  • The postgres Error Logs:
2024-08-18 11:21:36.219 UTC [36864] FATAL:  database "template0" is not currently accepting connections
2024-08-18 11:21:37.766 UTC [32776] FATAL:  terminating connection due to administrator command
2024-08-18 11:21:37.766 UTC [32780] FATAL:  terminating connection due to administrator command
2024-08-18 11:21:41.057 UTC [36867] ERROR:  cannot drop the currently open database
2024-08-18 11:21:41.057 UTC [36867] STATEMENT:  DROP DATABASE postgres;
2024-08-18 11:22:26.498 UTC [36875] FATAL:  database "strapi" does not exist
2024-08-18 11:25:45.056 UTC [36889] FATAL:  database "strapi" does not exist
2024-08-18 11:27:20.600 UTC [36896] FATAL:  database "strapi" does not exist
2024-08-18 11:30:37.105 UTC [36910] FATAL:  database "strapi" does not exist
  • The strapi Error Logs:
Connection Error: Connection ended unexpectedly
Connection Error: Connection ended unexpectedly
[2024-08-18 11:22:26.502] error: database "strapi" does not exist
error: database "strapi" does not exist
    at Parser.parseErrorMessage (/opt/node_modules/pg-protocol/dist/parser.js:283:98)
    at Parser.handlePacket (/opt/node_modules/pg-protocol/dist/parser.js:122:29)
    at Parser.parse (/opt/node_modules/pg-protocol/dist/parser.js:35:38)
    at Socket.<anonymous> (/opt/node_modules/pg-protocol/dist/index.js:11:42)
    at Socket.emit (node:events:517:28)
    at Socket.emit (node:domain:489:12)
    at addChunk (node:internal/streams/readable:368:12)
    at readableAddChunk (node:internal/streams/readable:341:9)
    at Readable.push (node:internal/streams/readable:278:10)
    at TCP.onStreamRead (node:internal/stream_base_commons:190:23)
[2024-08-18 11:22:26.504] http: GET /api/articles?sort[0]=publishedAt:desc&pagination[pageSize]=6 (33 ms) 500
[2024-08-18 11:25:45.057] error: database "strapi" does not exist