Postgresql from Render.com

[laurent512]

Hello,

I wanted to configure drizzle with a database from render.com but could not make it work.

Inside my root>drizzle.config.ts file :

export default {
  schema: "./db/schema/*",
  out: "./db/migrations",
  driver: "pg",
  dbCredentials: {
    ssl: true,
    connectionString: process.env.POSTGRES_URL,
  },
  verbose: true,
  strict: true,
} satisfies Config;

Inside root>db>index.ts file I tried many things and I am not sure it is even relevant to share it.

I have the following error when I drizzle-kit push :

  triggerUncaughtException(err, true /* fromPromise */);
                                                                                                                ^

                                                                                                                 Error: read ECONNRESET
                                                                                                                                           at __node_internal_captureLargerStackTrace (node:internal/errors:563:5)                                                                                                                                                                                                                  
   at __node_internal_errnoException (node:internal/errors:690:12)
                                                                      at TCP.onStreamRead (node:internal/stream_base_commons:217:20)
                                                                                                                                        at TCP.callbackTrampoline (node:internal/async_hooks:130:17) {
                                                                                                                                                                                                        errno: -4077,
     code: 'ECONNRESET',
                          syscall: 'read'
                                         }

                                          Node.js v20.10.0

Would you see any way to solve this? :) thank you