Re: [GENERAL] managing tablespaces like files?

Justin, It is an image viewing system for events. Each event could have a few hundred images (each one will be between a 3 to 12 megs file) and as many as one hundred thousand images. So these are the other files, the other folders is how all these images are stored and managed. The database co

Re: [GENERAL] managing tablespaces like files?

On 3/9/2010 12:07 AM, Sam Carleton wrote: > I would like to thank both John and Scott for the help. It is very > clear to me that PostgreSQL isn't the ideal solution for my current > model. The conversation has gotten me thinking of ways the model > could be modified to work with PostgrSQL (an

Re: [GENERAL] managing tablespaces like files?

I would like to thank both John and Scott for the help. It is very clear to me that PostgreSQL isn't the ideal solution for my current model. The conversation has gotten me thinking of ways the model could be modified to work with PostgrSQL (and other client/server RDBM). Thus I will return to t

Re: [GENERAL] managing tablespaces like files?

On Mon, Mar 8, 2010 at 4:58 PM, Sam Carleton wrote: > On Mon, Mar 8, 2010 at 4:07 PM, John R Pierce wrote: > >> >> and what happens if someone copies your directory without shutting down >> the instance? >> > > Well, that is an issue right now, the current SQLite DB is locked by the > app and can

Re: [GENERAL] managing tablespaces like files?

Sam Carleton writes: > One of the cases I need to be concerned with is the case where the > application is shut down, the user goes in and deletes the tablespace folder > by way of deleting the parent folder. How will PostgreSQL handle such a > situation? It won't like it. If your users are like

Re: [GENERAL] managing tablespaces like files?

On Mon, Mar 8, 2010 at 5:46 PM, John R Pierce wrote: > >> I hear you, but I am not willing to throw in the towel, just yet... >> Generally speaking, is there a lot of metadata that would need to be >> exported? As I think about this, I am thinking I would have to read in ALL >> the system table

Re: [GENERAL] managing tablespaces like files?

Sam Carleton wrote: On Mon, Mar 8, 2010 at 4:07 PM, John R Pierce > wrote: and what happens if someone copies your directory without shutting down the instance? Well, that is an issue right now, the current SQLite DB is locked by the app and cannot current

Re: [GENERAL] managing tablespaces like files?

On Mon, Mar 8, 2010 at 4:07 PM, John R Pierce wrote: > > and what happens if someone copies your directory without shutting down the > instance? > Well, that is an issue right now, the current SQLite DB is locked by the app and cannot currently be copied while the app is running. Or at least I

Re: [GENERAL] managing tablespaces like files?

On Mon, Mar 8, 2010 at 3:52 PM, John R Pierce 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 me

Re: [GENERAL] managing tablespaces like files?

Sam Carleton wrote: On Mon, Mar 8, 2010 at 3:52 PM, John R Pierce > 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

Re: [GENERAL] managing tablespaces like files?

Sam Carleton wrote: The server of my client/server program is currently using SQLite, an embedded file based SQL engine. I am looking for a client/server based RDBM and have narrowed it down to either PosgreSQL or Firebird. I would prefer to use PosgreSQL, but the management of the physical

[GENERAL] managing tablespaces like files?

The server of my client/server program is currently using SQLite, an embedded file based SQL engine. I am looking for a client/server based RDBM and have narrowed it down to either PosgreSQL or Firebird. I would prefer to use PosgreSQL, but the management of the physical files are concerning me.