Re: Database Design Question - Mailing list pgsql-general

From Sim Zacks
Subject Re: Database Design Question
Date
Msg-id 4D4AA4DD.6020800@compulab.co.il
Whole thread Raw
In response to Database Design Question  (Carlos Mennens <carlos.mennens@gmail.com>)
Responses Re: Database Design Question
List pgsql-general
> Just trying to understand good DBA design practice. This is obviously
> a very general question but any feedback on what good or bad issues
> would come from me dumping all my tables for applications in one
> database or spread out across multiple databases on PostgreSQL.
>
> Thank you!
As a general rule, whenever you have applications that don't share
anything should not be in the same database. This is because of
flexibility, it is a lot easier to move an application to another server
in the future, if you decide to break them up. If the only thing that is
shared is a users table, I would move the users to ldap.

Sim


pgsql-general by date:

Previous
From: Thom Brown
Date:
Subject: Re: Issues with generate_series using integer boundaries
Next
From: Thom Brown
Date:
Subject: Re: Issues with generate_series using integer boundaries