Re: Experience with many schemas vs many databases - Mailing list pgsql-general

From John R Pierce
Subject Re: Experience with many schemas vs many databases
Date
Msg-id 4B006E7F.1070109@hogranch.com
Whole thread Raw
In response to Re: Experience with many schemas vs many databases  (undisclosed user <lovetodrinkpepsi@gmail.com>)
Responses Re: Experience with many schemas vs many databases  (undisclosed user <lovetodrinkpepsi@gmail.com>)
List pgsql-general
undisclosed user wrote:
> If I were to switch to a single DB/single schema format shared among
> all users , how can I backup each user individually?

depending on how many tables, etc, I suppose you could use a seperate
series of SELECT statements ...
but if this is a requirement, it certainly puts constraints on how you
organize your data.   without a much deeper knowlege of your
application, data, and requirements, its kind of hard to give any sort
of recommendations.   you mentioned myISAM, so I gather this data isn't
at all transactional, nor is relational integrity a priority.









pgsql-general by date:

Previous
From: undisclosed user
Date:
Subject: Re: Experience with many schemas vs many databases
Next
From: Simon Riggs
Date:
Subject: Re: Voting: "pg_ctl init" versus "initdb"