# How OpusFlow achieves tenant isolation in Postgres without managing servers

DevFeed: [How OpusFlow achieves tenant isolation in Postgres without managing servers](<https://devfeed.tech/articles/how-opusflow-achieves-tenant-isolation-in-postgres-without-managing-servers-5355.md>)

Original publisher: [Read original article](<https://neon.com/blog/how-opusflow-achieves-tenant-isolation-in-postgres-without-managing-servers>)

Author: Carlota Soto

Published: 2024-02-22T17:28:50Z

Content type: article

Language: en

Sources: [Blog -- Neon Docs](<https://devfeed.tech/sources/blog-neon-docs.md>)

Topics: [Per-user Database](<https://devfeed.tech/topics/per-user-database.md>), [tenant data protection](<https://devfeed.tech/topics/tenant-data-protection.md>), [Amazon RDS](<https://devfeed.tech/topics/amazon-rds.md>), [Multitenancy](<https://devfeed.tech/topics/multitenancy.md>), [Encryption](<https://devfeed.tech/topics/encryption.md>), [DevOps](<https://devfeed.tech/topics/devops.md>), [Databases](<https://devfeed.tech/topics/databases.md>)

Tags: [amazon-rds](<https://devfeed.tech/tags/amazon-rds.md>), [architecture](<https://devfeed.tech/tags/architecture.md>), [business](<https://devfeed.tech/tags/business.md>), [case-studies](<https://devfeed.tech/tags/case-studies.md>), [customers](<https://devfeed.tech/tags/customers.md>), [data](<https://devfeed.tech/tags/data.md>), [database](<https://devfeed.tech/tags/database.md>), [devops](<https://devfeed.tech/tags/devops.md>), [encryption](<https://devfeed.tech/tags/encryption.md>), [energy](<https://devfeed.tech/tags/energy.md>), [postgres](<https://devfeed.tech/tags/postgres.md>)

## AI overview

The article describes how OpusFlow, an ERP tool for sustainable energy installers, addresses sensitive European customer data through a one-database-per-customer architecture in Postgres. It explains that this design improves tenant isolation, supports separate encryption keys, independent scaling, customer-specific restores, and separate upgrade schedules. The article contrasts this approach with Amazon RDS deployments, which either allow resource contention in a shared instance or create substantial operational and cost overhead when each database uses a separate instance.

## Source excerpt

"Our customers require their data to live in an isolated database, but implementing this in RDS was cumbersome and expensive. We switched over to Neon to reduce costs and operational overhead" Joey Teunissen, CTO at OpusFlow The demand for solar panels and sustainable energy inst...