Prisma postgress multi schema + Replica
Hello, I have a question.
I’m working with a PostgreSQL database managed through Prisma. For each customer, I plan to create a separate schema to ensure that their data remains isolated and not mixed with other customers’ data. The database structure will be exactly the same across all schemas — only the schema name will change.
I would like to know:
What is the best way to handle this setup using Prisma?
Is it possible to connect each customer to their own schema through Prisma?
Additionally, is there a way to configure a PostgreSQL replica to another database hosted on a different server?
I’m working with a PostgreSQL database managed through Prisma. For each customer, I plan to create a separate schema to ensure that their data remains isolated and not mixed with other customers’ data. The database structure will be exactly the same across all schemas — only the schema name will change.
I would like to know:
What is the best way to handle this setup using Prisma?
Is it possible to connect each customer to their own schema through Prisma?
Additionally, is there a way to configure a PostgreSQL replica to another database hosted on a different server?
