Link Details

We've run against multiple (five now) separate PostgreSQL servers for a long time now. To be clear, that's five separate "databases" in the sense that PostgreSQL uses the term. Not a replicating / mirror setup - separate databases with different data but with similar structure. Each of our clients gets a schema (again, in the postgres sense of the word) on one of the database boxes. There are multiple client schemas per database. When a box becomes over utilized we get another box and move schemas around.