Re: Removing raw data files

From: Carol Walter <walterc(at)indiana(dot)edu>
To: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Removing raw data files
Date: 2008-07-07 19:10:51
Message-ID: DCEC14A0-56A4-433B-A198-4D0A033A747D@indiana.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Uh-huh. I like this answer. Will do this and send result. Might be
interesting.

Carol

On Jul 7, 2008, at 2:42 PM, Scott Marlowe wrote:

> On Mon, Jul 7, 2008 at 12:19 PM, Carol Walter <walterc(at)indiana(dot)edu>
> wrote:
>> Hello,
>>
>> I asked this question a while ago and I didn't get an answer.
>> Perhaps I
>> asked the question in a manner that wasn't clear. I upgraded from
>> 8.1.3 to
>> 8.2.3. I left the 8.1.3 database intact in case I had to revert
>> to it. The
>> 8.2.3 database is running just fine and I'd like to recover the
>> space that
>> the 8.1.3 raw data directories are consuming. Can I just remove
>> the raw
>> data files with rm -rf on the data directory for the 8.1.3
>> version? This
>> may sound like a silly question but the database I worked with
>> prior to
>> postgres was MS SQL Server. On that platform, you never know when
>> something
>> from the last version is imbedded in the new version.
>
> The cautious sysadmin in me says to set the directory to owner root
> and perms 000 so it's not accesible. Then if something goes horribly
> wrong, you've still got the original directory. If not, after a week
> or two you can delete it knowing nothing is accessing it.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Potluri Srikanth 2008-07-08 12:32:13 pgcrypto library available for mac ?
Previous Message Scott Marlowe 2008-07-07 18:42:13 Re: Removing raw data files