Re: Experience with many schemas vs many databases

Поиск
Список
Период
Сортировка
От Loyal
Тема Re: Experience with many schemas vs many databases
Дата
Msg-id c1447bde-708c-4554-b625-4cd04edb9644@c16g2000yqd.googlegroups.com
обсуждение исходный текст
Ответ на Experience with many schemas vs many databases  (undisclosed user <lovetodrinkpepsi@gmail.com>)
Список pgsql-general
On Nov 15, 1:07 pm, lovetodrinkpe...@gmail.com (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?
>
> Frank
> <snip>

I would love to understand why that would be a requirement.  I would
much
prefer backing up one database/schema.  If I needed to restore a
single user
I then have options such as restoring to my test database then
extracting
that single user's data, though it is still unclear to me why that
would be a
requirement.  If it is so single users can get a backup their own
data, I would
do it using a generic script or function.  Since your users would see
their own
views only that should work fine.

Loyal

В списке pgsql-general по дате отправления:

Предыдущее
От: Jasen Betts
Дата:
Сообщение: Re: safelly erasing dirs/files
Следующее
От: Loyal
Дата:
Сообщение: Re: Voting: "pg_ctl init" versus "initdb"