Hosting options on Postgres - what's best?

From: Just Someone <just(dot)some(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Hosting options on Postgres - what's best?
Date: 2005-05-10 19:36:27
Message-ID: 36932f2705051012367594737c@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message mmiranda 2005-05-10 19:37:16 sequence values question
Previous Message Tony Caduto 2005-05-10 19:20:27 Re: Delphi - Developers start develop Access components