| From: | Mathijs Brands <mathijs(at)ilse(dot)nl> |
|---|---|
| To: | Jim Buttafuoco <jim(at)buttafuoco(dot)net> |
| Cc: | pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Storage Location Patch Proposal for V7.3 |
| Date: | 2001-11-23 11:08:47 |
| Message-ID: | 20011123120847.A99507@ilse.nl |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Mon, Nov 05, 2001 at 12:26:17PM -0500, Jim Buttafuoco allegedly wrote:
> The example below has 3 tablespaces/locations PGDATA/DB1/DB2
> PG_LOCATIONS (or PG_TABLESPACES) would have the following rows
> PGDATA | /usr/local/pgsql/data
> DB1 | /db1
> DB2 | /db2
<SNIP>
> /db1/data/5432
> ^-------------------------<< second location default PG PORT
> /db1/data/5432/65894834/99999999
> ^------<< somedb/sometable
> /db1/data/5432/65894834/88888888
> ^------<< somedb/someindex
>
> /db2/data/5432
> ^-------------------------<< DB2
Should data/ even be in there? /db2/5432 seems to be the correct value.
Either that or change the location to /db2/data. Implicitly creating an
extra directory isn't something I would like to happen, especially if it
doesn't happen for PGDATA itself.
My $.02,
Mathijs
--
And the beast shall be made legion. Its numbers shall be increased a
thousand thousand fold. The din of a million keyboards like unto a great
storm shall cover the earth, and the followers of Mammon shall tremble.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marc G. Fournier | 2001-11-23 13:35:58 | v7.2b3 packages rebuilt ... |
| Previous Message | Kovacs Zoltan | 2001-11-23 10:24:45 | hu.po |