Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group