1 reply

Specifying PostgreSQL Schema

With using Kysely and PostgreSQL with better-auth, is there a way to explicitly set the schema for the tables to be created on.

I've tried this,

const pool = new Pool({
    connectionString: `postgresql://${DB_CONNECTION_STRING}`,
    options: "-c search_path=auth",
});

export const auth = betterAuth({
database: pool,
});

const pool = new Pool({
    connectionString: `postgresql://${DB_CONNECTION_STRING}`,
    options: "-c search_path=auth",
});

export const auth = betterAuth({
database: pool,
});

which doesn't seem to help. I also tried creating a better_auth user which is explicitly scoped to the auth schema and nothing else, and I get this error when trying to migrate/generate with the cli.

❯ pnpx @better-auth/cli@latest generate
⠋ preparing schema...node:internal/process/promises:394
    triggerUncaughtException(err, true /* fromPromise */);
    ^

error: permission denied for schema public

❯ pnpx @better-auth/cli@latest generate
⠋ preparing schema...node:internal/process/promises:394
    triggerUncaughtException(err, true /* fromPromise */);
    ^

error: permission denied for schema public

it seems like it keeps trying to go back to the schema public.

Better Auth•5mo ago•

1 reply

averybigfish

Specifying PostgreSQL Schema

With using Kysely and PostgreSQL with better-auth, is there a way to explicitly set the schema for the tables to be created on.

I've tried this,

const pool = new Pool({
    connectionString: `postgresql://${DB_CONNECTION_STRING}`,
    options: "-c search_path=auth",
});

export const auth = betterAuth({
database: pool,
});

const pool = new Pool({
    connectionString: `postgresql://${DB_CONNECTION_STRING}`,
    options: "-c search_path=auth",
});

export const auth = betterAuth({
database: pool,
});

which doesn't seem to help. I also tried creating a better_auth user which is explicitly scoped to the auth schema and nothing else, and I get this error when trying to migrate/generate with the cli.

❯ pnpx @better-auth/cli@latest generate
⠋ preparing schema...node:internal/process/promises:394
    triggerUncaughtException(err, true /* fromPromise */);
    ^

error: permission denied for schema public

❯ pnpx @better-auth/cli@latest generate
⠋ preparing schema...node:internal/process/promises:394
    triggerUncaughtException(err, true /* fromPromise */);
    ^

error: permission denied for schema public

it seems like it keeps trying to go back to the schema public.

Specifying PostgreSQL Schema

Similar Threads

Specifying PostgreSQL Schema

Similar Threads

Similar Threads

Similar Threads