From: | Vick Khera <vivek(at)khera(dot)org> |
---|---|
To: | Postgres General Postgres General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: app table names |
Date: | 2010-03-17 14:04:13 |
Message-ID: | 2968dfd61003170704w20b5f7a4l3a846fdb0796cc57@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Tue, Mar 16, 2010 at 5:25 PM, Justin Graf <justin(at)magwerks(dot)com> wrote:
>> Do not mix data from multiple applications in one database. Use
>> multiple databases to isolate them entirely.
>>
>>
> That's not always a practical solution to the problem,
>
> the Apps may need to share numerous tables, duplicating the data and
> keeping it sync can be a pain. Having to open numerous database
> connections to different databases is a resource hog .
>
That was not a consideration in the original post. In that case, make
your application developers use unique names.
From | Date | Subject | |
---|---|---|---|
Next Message | Albe Laurenz | 2010-03-17 14:06:20 | pgreplay log file replayer released |
Previous Message | josep porres | 2010-03-17 13:57:54 | db error messages when I try to debug with pgadmin |