Kafka PostegreSQL kafka on public schema

[renansko-vilela]

Welcome!

• Yes, I have searched for similar issues on GitHub and found none.

What did you do?

Run

docker-compose up -d

What did you expect?

New kafka migration created sucefully

What did you observe instead of what you expected?

The migrtation for create kafka in postgreSQL prisma point to 'public' instead create on default schema

When he associate the 'instance' table not exist because never has create a instance in 'public'

Screenshots/Videos

`igration name: 20250918182355_add_kafka_integration

Database error code: 42P01

Database error:

ERROR: relation "public.Instance" does not exist

DbError { severity: "ERROR", parsed_severity: Some(Error), code: SqlState(E42P01), message: "relation "public.Instance" does not exist", detail: None, hint: None, position: None, where_: None, schema: None, table: None, column: None, datatype: None, constraint: None, file: Some("namespace.c"), line: Some(428), routine: Some("RangeVarGetRelidExtended") }

`

Which version of the API are you using?

Version 2.3.4

What is your environment?

Windows

Other environment specifications

No response

If applicable, paste the log output

No response

Additional Notes

No response

[diogod2r]

same problem

[diogod2r]

I resolved this by deleting the evolution_api schema, and removing it from the environment variable;
from:
DATABASE_CONNECTION_URI='postgresql://user:pass@postgres:5432/evolution_db?schema=evolution_api'
to:
DATABASE_CONNECTION_URI='postgresql://user:pass@postgres:5432/evolution_db

[DavidsonGomes]

It has already been resolved in development, and the fix will be included in the next release.

[adindaco]

i resolved this by Added manually public.Instance

CREATE TABLE "public"."Instance" (
    "id" TEXT NOT NULL,
    "instanceName" TEXT NOT NULL,
    "ownerJid" TEXT,
    "token" TEXT,
    "status" TEXT NOT NULL DEFAULT 'created',
    "serverUrl" TEXT,
    "qrcode" TEXT,
    "profilePictureUrl" TEXT,
    "profileName" TEXT,
    "profileStatus" TEXT,

    CONSTRAINT "Instance_pkey" PRIMARY KEY ("id")
);

CREATE UNIQUE INDEX "Instance_instanceName_key" ON "public"."Instance"("instanceName");