Re: Experience with many schemas vs many databases

From: John R Pierce <pierce(at)hogranch(dot)com>
To: undisclosed user <lovetodrinkpepsi(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Experience with many schemas vs many databases
Date: 2009-11-15 21:11:27
Message-ID: 4B006E7F.1070109@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Simon Riggs 2009-11-15 21:16:38 Re: Voting: "pg_ctl init" versus "initdb"
Previous Message Greg Smith 2009-11-15 20:38:13 Re: Voting: "pg_ctl init" versus "initdb"