IWETHEY v. 0.3.0 | TODO
1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User
IWETHEY Banner

Welcome to IWETHEY!

New Upgrading form Postrges 7.4 to 8.1
I just selected the packages for 8.1 in Synaptic and installed them. I assumed it would upgrade my existing 7.4 installation. Instead I now have/usr/lib/postgresql/7.4/bin/postmaster and /usr/lib/postgresql/8.1/bin/postmaster running. How do I fix this?
===

Purveyor of Doc Hope's [link|http://DocHope.com|fresh-baked dog biscuits and pet treats].
[link|http://DocHope.com|http://DocHope.com]
New Dump and Reload is the only way.
The debconf should has told you this during the upgrade.

7.x -> 8.x had a major change in the way things worked and was/is a painful update. Sort of like the upgrade from Oracle v8.x.x to v9.x.x
--
[link|mailto:greg@gregfolkert.net|greg],
[link|http://www.iwethey.org/ed_curry|REMEMBER ED CURRY!] @ iwethey
Freedom is not FREE.
Yeah, but 10s of Trillions of US Dollars?
SELECT * FROM scog WHERE ethics > 0;

0 rows returned.
New Painful update if you have data, yeah.
All my code works the same, though. Same with our Oracle 8->9 upgrade.
Regards,

-scott anderson

"Welcome to Rivendell, Mr. Anderson..."
New With Peoplesoft... ICKY upgrade.
SO much of the stuff they used was version specific... heck even patch level specific. They even relied on BUGS to process faster for somethings. All that went away when they went from Oracle 8 -> 9 they started using and application server for those things.

We went from having to recode all of the direct connects to query specs AND application code.... How was that better?

More Flexible, More Headaches, More machines, more network... yeah.

But you guys also have a pretty great handle on your data in any case. Well, your DB Admin isn't a complete ASS and knows what he is doing. We didn't get one of those until after the 8->9 migration.
--
[link|mailto:greg@gregfolkert.net|greg],
[link|http://www.iwethey.org/ed_curry|REMEMBER ED CURRY!] @ iwethey
Freedom is not FREE.
Yeah, but 10s of Trillions of US Dollars?
SELECT * FROM scog WHERE ethics > 0;

0 rows returned.
New Then once I check it's working, 'apt-get remove 7.4'?
===

Purveyor of Doc Hope's [link|http://DocHope.com|fresh-baked dog biscuits and pet treats].
[link|http://DocHope.com|http://DocHope.com]
New Pretty much...
After all things are said and done... and proved working, you might want to purge the 7.4 configs.
--
[link|mailto:greg@gregfolkert.net|greg],
[link|http://www.iwethey.org/ed_curry|REMEMBER ED CURRY!] @ iwethey
Freedom is not FREE.
Yeah, but 10s of Trillions of US Dollars?
SELECT * FROM scog WHERE ethics > 0;

0 rows returned.
New Cool, thankee
===

Purveyor of Doc Hope's [link|http://DocHope.com|fresh-baked dog biscuits and pet treats].
[link|http://DocHope.com|http://DocHope.com]
     Upgrading form Postrges 7.4 to 8.1 - (drewk) - (6)
         Dump and Reload is the only way. - (folkert) - (5)
             Painful update if you have data, yeah. - (admin) - (1)
                 With Peoplesoft... ICKY upgrade. - (folkert)
             Then once I check it's working, 'apt-get remove 7.4'? -NT - (drewk) - (2)
                 Pretty much... - (folkert) - (1)
                     Cool, thankee -NT - (drewk)

I'm gonna break him like a wedding vow on the Jerry Springer Show.
75 ms