Hi, I'm looking into creating a hosted application with Postgres as the SQL server. I would like to get some ideas and oppinions about the different ways to separate the different clients, using postgres.
The options I had in mind: 1) Create a different database per client. How much overhead will this add? 2) Use schemas and authentication. So each client is a different schema on the database. 3) Use application level security (per object security maintained by the app). 4) ???? Any ideas? Opinnions? js. ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
