Re: Experience with many schemas vs many databases

Поиск
Список
Период
Сортировка
От John R Pierce
Тема Re: Experience with many schemas vs many databases
Дата
Msg-id 4B006E7F.1070109@hogranch.com
обсуждение исходный текст
Ответ на Re: Experience with many schemas vs many databases  (undisclosed user <lovetodrinkpepsi@gmail.com>)
Ответы Re: Experience with many schemas vs many databases
Список 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 по дате отправления:

Предыдущее
От: undisclosed user
Дата:
Сообщение: Re: Experience with many schemas vs many databases
Следующее
От: Simon Riggs
Дата:
Сообщение: Re: Voting: "pg_ctl init" versus "initdb"