Re: managing tablespaces like files?

Поиск
Список
Период
Сортировка
От John R Pierce
Тема Re: managing tablespaces like files?
Дата
Msg-id 4B956717.6070600@hogranch.com
обсуждение исходный текст
Ответ на managing tablespaces like files?  (Sam Carleton <scarleton@miltonstreet.com>)
Ответы Re: managing tablespaces like files?  (Sam Carleton <scarleton@miltonstreet.com>)
Список pgsql-general
Sam Carleton wrote:
>
>
> On Mon, Mar 8, 2010 at 3:52 PM, John R Pierce <pierce@hogranch.com
> <mailto:pierce@hogranch.com>> wrote:
>
>
>     I don't think PostgreSQL is going to work for you if thats a
>     requirement.   A tablespace doesn't contain the metadata for the
>     items in it, thats stored in the main cluster space (pg_catalog, etc)
>
>
>
> Would it be difficult to export the metadata as part of the shutdown
> process of the service?  Or am I simply reaching a bit too much?  (For
> the record, my application exists because I run into this type of
> "things don't work that way" and than I find some interesting
> solutions <grin>  But maybe this time I am simply better off with
> Firebird.)

and what happens if someone copies your directory without shutting down
the instance?

sounds like trouble in the making to me.  me thinks you're better off
sticking with a file based database and not trying to use a server based
one.





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

Предыдущее
От: John R Pierce
Дата:
Сообщение: Re: managing tablespaces like files?
Следующее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: DROP column: documentation unclear