Re: After upgrade cleanup - Mailing list pgsql-admin

From Scott Marlowe
Subject Re: After upgrade cleanup
Date
Msg-id dcc563d10807011254r7c515bdao22045ee744eb14aa@mail.gmail.com
Whole thread Raw
In response to Re: After upgrade cleanup  (Decibel! <decibel@decibel.org>)
List pgsql-admin
On Fri, Jun 20, 2008 at 3:19 PM, Decibel! <decibel@decibel.org> wrote:
> On Jun 19, 2008, at 8:13 AM, Carol Walter wrote:
>>
>> I just did an upgrade from 8.1 to 8.2.3.  We'll go up to 8.3.3 very soon,
>> but for reasons I won't go into, this intermediate step was necessary.  My
>> problem is, now that the upgrade is done, how can I clean up the database
>> from the old version.  I leave the original database up as long as I can
>> when I do an upgrade just in case I need to revert to it.  Now I have the
>> databases from two versions on my server and I need to get rid of the old
>> one.  Can I just remove the old files from the data directories?  With other
>> systems, I've had trouble removing database files because upgrades use
>> certain files from old versions.  I don't want to break my new database.
>>  I'm on Solaris 10.
>
>
> Not only does the new version not use files from the old, it doesn't even
> know it exists. You can just nuke all the 8.1 stuff.

If you're paranoid, then you can also do:

sudo chmod 000 /old/data/dir

and see if anything breaks.

pgsql-admin by date:

Previous
From: "JGuillaume (ioguix) de Rorthais"
Date:
Subject: Re: PostgreSQL web administration
Next
From: Naomi Walker
Date:
Subject: Change a character in a text field