Re: managing tablespaces like files? - Mailing list pgsql-general

From John R Pierce
Subject Re: managing tablespaces like files?
Date
Msg-id 4B956717.6070600@hogranch.com
Whole thread Raw
In response to managing tablespaces like files?  (Sam Carleton <scarleton@miltonstreet.com>)
Responses Re: managing tablespaces like files?  (Sam Carleton <scarleton@miltonstreet.com>)
List 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 by date:

Previous
From: John R Pierce
Date:
Subject: Re: managing tablespaces like files?
Next
From: Martijn van Oosterhout
Date:
Subject: Re: DROP column: documentation unclear