pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
After upgrade cleanup
3+ messages / 3 participants
[nested] [flat]

* After upgrade cleanup
@ 2008-06-19 13:13 Carol Walter <walterc@indiana.edu>
  2008-06-20 21:19 ` Re: After upgrade cleanup Decibel! <decibel@decibel.org>
  0 siblings, 1 reply; 3+ messages in thread

From: Carol Walter @ 2008-06-19 13:13 UTC (permalink / raw)
  To: pgsql-admin

Greetings, one and all,

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.

Thanks,

Carol



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: After upgrade cleanup
  2008-06-19 13:13 After upgrade cleanup Carol Walter <walterc@indiana.edu>
@ 2008-06-20 21:19 ` Decibel! <decibel@decibel.org>
  2008-07-01 19:54   ` Re: After upgrade cleanup Scott Marlowe <scott.marlowe@gmail.com>
  0 siblings, 1 reply; 3+ messages in thread

From: Decibel! @ 2008-06-20 21:19 UTC (permalink / raw)
  To: Carol Walter <walterc@indiana.edu>; +Cc: pgsql-admin

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.
-- 
Decibel!, aka Jim C. Nasby, Database Architect  decibel@decibel.org
Give your computer some brain candy! www.distributed.net Team #1828

Attachments:

  smime.p7s (application/pkcs7-signature, 2.5K) download

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: After upgrade cleanup
  2008-06-19 13:13 After upgrade cleanup Carol Walter <walterc@indiana.edu>
  2008-06-20 21:19 ` Re: After upgrade cleanup Decibel! <decibel@decibel.org>
@ 2008-07-01 19:54   ` Scott Marlowe <scott.marlowe@gmail.com>
  0 siblings, 0 replies; 3+ messages in thread

From: Scott Marlowe @ 2008-07-01 19:54 UTC (permalink / raw)
  To: Decibel! <decibel@decibel.org>; +Cc: Carol Walter <walterc@indiana.edu>; 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.



^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2008-07-01 19:54 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-06-19 13:13 After upgrade cleanup Carol Walter <walterc@indiana.edu>
2008-06-20 21:19 ` Decibel! <decibel@decibel.org>
2008-07-01 19:54   ` Scott Marlowe <scott.marlowe@gmail.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox