PG closes connection before layer's effect is finished running

// @core/domain/src/db.ts
import { Effect, Context } from "effect"

export interface DbService {
  readonly createCheque: Effect.Effect<typeof Cheque.Type.id, DbError>
}

export const DbService = Context.GenericTag<DbService>("DbService")

// @core/db/src/test.ts
import { Effect } from "effect"

import { DbService } from "@core/domain/db/index"

import { DbServiceLive } from "./index"
import { DatabaseLive } from "./layer"

const program = Effect.gen(function* () {
  const dbService = yield* DbService
  const newChequeId = yield* dbService.createCheque
  yield* Effect.log(`Created cheque with ID: ${newChequeId}`)
}).pipe(Effect.provide(DbServiceLive), Effect.provide(DatabaseLive))

export const main = program.pipe(
  Effect.catchAll(Effect.logError),
  Effect.runPromise,
)

$ pnpm dlx tsx src/test.ts
Connected to PostgreSQL database
timestamp=2025-08-05T20:51:27.666Z level=INFO fiber=#0 message="Creating cheque"
timestamp=2025-08-05T20:51:27.687Z level=INFO fiber=#0 message="Created cheque with ID: 1382c018-7a10-438c-b73e-24b57aa9541e"