PostgresError: sorry, too many clients already

import { drizzle } from 'drizzle-orm/postgres-js';
import { migrate } from 'drizzle-orm/postgres-js/migrator';
import postgres from 'postgres';
import * as schema from './schema';

// for migrations
const migrationClient = postgres("postgres://root@localhost:5432/cafekampung", { max: 1 });
migrate(drizzle(migrationClient), {
    migrationsFolder: "drizzle",
    migrationsTable: "drizzle_migrations",
    migrationsSchema: "public",
});

// for query purposes
const queryClient = postgres("postgres://root@localhost:5432/cafekampung");
export const db = drizzle(queryClient, { schema });

this is the client

import { db } from "@/db";
import { restaurants } from "@/db/schema";
import { eq } from "drizzle-orm";

export function getAllMenu() {
    return db.query.restaurants.findFirst({
        where: eq(restaurants.id, 2),
        with: {
            menuItems: true
        }
    })
}


I'm calling it like this, suddenly it says

⨯ PostgresError: sorry, too many clients already
    at Socket.emit (node:events:517:28)
digest: "3057589683"
Was this page helpful?