Re: Database subdirectories in V7.1.x

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Rick Turner <rnturn(at)baxter(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Database subdirectories in V7.1.x
Date: 2001-10-18 14:49:50
Message-ID: 200110181449.f9IEnog09803@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

> Thanks guys...
>
> I was able to do employ the symbolic link trick to get my old
> filesystems set up for use with 7.1's way of doing things and am glad
> I don't /really/ need to remember what the heck is that mounted on
> /opt/postgresql/data/base/19162, etc..
>
> This would have been less of a PITB if it had been more obvious in the
> v7.1 notes that something like the naming change was going to happen
> and what the impact was going to be. I went back last night and
> looked again and -- for the life of me -- still didn't see anything
> except that one-line mention in the HISTORY which (obviously) didn't
> raise any flags. I was only too happy to dump all the databases if it
> meant that longer rows were going to be available but I sure felt
> blindsided by this new naming scheme. At least there's a solution.
> Thanks again.

I totally agree with you here. Numeric file names are a pain for
administrators that want to do database accounting at the file system
level. Surprisingly, we haven't had too many people complain so it
seems there aren't as many people doing this as I thought.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Steve Frampton 2001-10-18 16:03:28 Doing a regexp-based search/replace?
Previous Message postgresql 2001-10-18 14:08:31 Re: PgAccess on OS X--was "tcl wish--simple configure