Hi All, We're in the process of migrating parts of our system from SQL Server onto PostgreSQL. In SQL Server we have a db-per-customer, all of which have the same schema (i.e. table definitions) and we only use the dbo schema. I'm looking at options for a similar model into PG; the only real differences that I can see between customer-per-db and customer-per-schema is the ability to join between tables in the same database but different schema. This is not an option for customer-per-db as once connected into a database, you have to open another connection to the other one. I can see there would be connection-pooling advantages for shared-db models and scalability advantages for per-db (I can move given customers out onto their own servers more easily etc if I wanted). Are there any particular gotcha's with either model that I should be aware of? From what I can see backups, restores and permissions are all equally configurable per schema as they are per-database. Many Thanks Rob -- <https://codeweavers.net> Codeweavers February Newsletter <http://us6.campaign-archive1.com/?u=db934935d4174e46e9063c8c4&id=895274c19a> *MultiCalc enables car buyers to select a quote based on their credit rating <https://codeweavers.net/company-blog/multicalc-can-display-different-quotes-based-on-credit-score>* *Phone:* 0800 021 0888 * Email: *contactus@xxxxxxxxxxxxxxx *Codeweavers Ltd* | Barn 4 | Dunston Business Village | Dunston | ST18 9AB Registered in England and Wales No. 04092394 | VAT registration no. 974 9705 63 <http://t.sidekickopen50.com/e1t/c/5/f18dQhb0S7lC8dDMPbW2n0x6l2B9nMJN7t5XX4QBhKzW64Js984WrKTYVd0r_-56dzZCf1d8gHj02?t=https%3A%2F%2Fwww.linkedin.com%2Fcompany%2Fcodeweavers-limited&si=4882959321006080&pi=b30721f0-51f0-448c-8020-e9ac33f685b8> <http://t.sidekickopen50.com/e1t/c/5/f18dQhb0S7lC8dDMPbW2n0x6l2B9nMJN7t5XX4QBhKzW64Js984WrKTYVd0r_-56dzZCf1d8gHj02?t=https%3A%2F%2Fvimeo.com%2Fcodeweaversltd&si=4882959321006080&pi=b30721f0-51f0-448c-8020-e9ac33f685b8> <http://t.sidekickopen50.com/e1t/c/5/f18dQhb0S7lC8dDMPbW2n0x6l2B9nMJN7t5XX4QBhKzW64Js984WrKTYVd0r_-56dzZCf1d8gHj02?t=https%3A%2F%2Fplus.google.com%2Fb%2F105942302039373248738%2F%2BCodeweaversNet%2Fposts&si=4882959321006080&pi=b30721f0-51f0-448c-8020-e9ac33f685b8> <http://t.sidekickopen50.com/e1t/c/5/f18dQhb0S7lC8dDMPbW2n0x6l2B9nMJN7t5XX4QBhKzW64Js984WrKTYVd0r_-56dzZCf1d8gHj02?t=https%3A%2F%2Ftwitter.com%2FCodeweaversTeam%3Flang%3Den-gb&si=4882959321006080&pi=b30721f0-51f0-448c-8020-e9ac33f685b8> -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
