PostgreSQL 8.1.9 on Jupiter - Dotable

hal · 2nd January 2008, 11:21 AM

Hi there, Bob and Steve

Can I ask whether there is any chance that you would consider upgrading the Jupiter server from PostgreSQL 7.1.9 to 8.1.9. I appreciate that we already discussed this about a year ago but, since then, version 8.1 has become very stable (rock solid, in fact) and is also now available via the centos yum repo.

I hope you can consider this with with fresh eyes, as I would really like to take advantage of the major improvements in performance that have come about with 8.1. Also, the postgre community strongly recommends upgrades to the latest possible versions.

See:
http://mirror.centos.org/centos/4/centosplus/i386/RPMS/

If there are any other jupiter users who would agree or disagree, please let us know in this thread.

If there is anyone else actually using postgre on jupiter, please also give us a shout out, so that we can discuss any difficulties a migration between 7.4 and 8.1 may cause.

Cheers all
Hal

Aussie Bob · 2nd January 2008, 11:39 AM

Hi Hal

Steve will get back to you asap . . .

Ergo · 2nd January 2008, 05:29 PM

we have 8.x at least on some servers :-)

hal · 3rd January 2008, 09:44 AM

Ergo - thanks for your reply. Bearing in mind that all the servers have the same OS version as jupiter, hopefully the request will not be out of the question. Obviously it needs to fit in with Dotables work schedule, which may already be long.

Thanks for your consideration too, Bob - yours and Steve's ever-industrious support is always appreciated.

Best wishes
Hal

Ergo · 3rd January 2008, 05:34 PM

As far as i know, its not the os that is the problem, im sure that postgresql will be upgraded if no one else uses it, or only you use it.

there is a potential risk clients applications could break with new version of pg ( not really likely imho - never had problems with migration , but steve takes that into consideration as far as i know ).

Dotable Steve · 6th January 2008, 10:08 AM

No probs, I'll get the source rpm (8.2.5) and rebuild it for jupiter.
Seeing as there are only 3 postgres databases on the server, shouldn't be an issue, as I think they are all yours anyways.

Does require the databases to be dumped, upgrade take place and then dump the databases back in - rebuild 2 x php installations with the new postgres libraries etc. Will most likely be able to do this later today.

Ergo · 6th January 2008, 10:32 AM

yay, soon we will have postgres 8.x across whole fleet

i need to advertise dotable to some other ppl that need it, you will get more clients , not many other companies that provide it and have a decent reputation :]

hal · 8th January 2008, 09:24 AM

That's fantastic news, Steve. Thank you very much for doing that.
Just to let you know, I don't have any pg databases as far as I know, so were your comments directed at Ergo?

If you still think one of my clients may have set them up, would you mind contacting me privately so that I can contact them accordingly to pass on your advice?

Many thanks
H

Ergo · 8th January 2008, 05:11 PM

Quote:

Originally Posted by hal

Just to let you know, I don't have any pg databases as far as I know, so were your comments directed at Ergo?

I dont think so, db's on my server are already on 8.x ;-)

Btw. sterve can easly check to what username db's belong , dont worry hal.

hal · 10th January 2008, 10:14 AM

Steve

Would it be possible for you to set the default encoding to utf-8 or unicode when you upgrade postgres, please?

I believe the default locale is C, which is ideal for me.

Also, will the upgrade to 8.2 be reflected in phpinfo and phpPgAdmin?

Hope this is OK.
H

2nd January 2008, 11:21 AM	#1 (permalink)
hal Member Join Date: May 2006 Posts: 45	PostgreSQL 8.1.9 on Jupiter Hi there, Bob and Steve Can I ask whether there is any chance that you would consider upgrading the Jupiter server from PostgreSQL 7.1.9 to 8.1.9. I appreciate that we already discussed this about a year ago but, since then, version 8.1 has become very stable (rock solid, in fact) and is also now available via the centos yum repo. I hope you can consider this with with fresh eyes, as I would really like to take advantage of the major improvements in performance that have come about with 8.1. Also, the postgre community strongly recommends upgrades to the latest possible versions. See: http://mirror.centos.org/centos/4/centosplus/i386/RPMS/ If there are any other jupiter users who would agree or disagree, please let us know in this thread. If there is anyone else actually using postgre on jupiter, please also give us a shout out, so that we can discuss any difficulties a migration between 7.4 and 8.1 may cause. Cheers all Hal

2nd January 2008, 11:39 AM	#2 (permalink)
Aussie Bob Dotable Founder Join Date: Mar 2005 Location: Land down under Posts: 3,252	Hi Hal Steve will get back to you asap . . . __________________ • Dotable • "an island of normality in a sea of pimps and pirates" •

2nd January 2008, 05:29 PM	#3 (permalink)
Ergo pro webdeveloper Join Date: Jul 2006 Location: Poland Posts: 277	we have 8.x at least on some servers :-) __________________ http://www.linkedin.com/in/marcinlulek - my linkedIn profile - please check out Freelance professional webdeveloper for hire - XHTML, CSS2, PHP 5 , SOON PYTHON, MySQL, PostgreSQL, SQLite, Ajax & Javascript [ using yahooUI and dojotoolkit for ajax work ], database performance optimisation, security audits. - contact me , get work done the way it should be.

3rd January 2008, 05:34 PM	#5 (permalink)
Ergo pro webdeveloper Join Date: Jul 2006 Location: Poland Posts: 277	As far as i know, its not the os that is the problem, im sure that postgresql will be upgraded if no one else uses it, or only you use it. there is a potential risk clients applications could break with new version of pg ( not really likely imho - never had problems with migration , but steve takes that into consideration as far as i know ). __________________ http://www.linkedin.com/in/marcinlulek - my linkedIn profile - please check out Freelance professional webdeveloper for hire - XHTML, CSS2, PHP 5 , SOON PYTHON, MySQL, PostgreSQL, SQLite, Ajax & Javascript [ using yahooUI and dojotoolkit for ajax work ], database performance optimisation, security audits. - contact me , get work done the way it should be.

6th January 2008, 10:08 AM	#6 (permalink)
Dotable Steve Dotable Join Date: Jun 2006 Location: Auckland Posts: 1,168	No probs, I'll get the source rpm (8.2.5) and rebuild it for jupiter. Seeing as there are only 3 postgres databases on the server, shouldn't be an issue, as I think they are all yours anyways. Does require the databases to be dumped, upgrade take place and then dump the databases back in - rebuild 2 x php installations with the new postgres libraries etc. Will most likely be able to do this later today. __________________ • Dotable - The home of "No Worries" hosting. • VPS ? Centos, Windows or Debian - Your choice • PHP5 ? Yes we do! • ClientExec? No Worries! • Do We Ride the Rails? Yes we do! • Move your sites to Dotable ? Yes we will!

3rd January 2008, 09:44 AM	#4 (permalink)
hal Member Join Date: May 2006 Posts: 45	Ergo - thanks for your reply. Bearing in mind that all the servers have the same OS version as jupiter, hopefully the request will not be out of the question. Obviously it needs to fit in with Dotables work schedule, which may already be long. Thanks for your consideration too, Bob - yours and Steve's ever-industrious support is always appreciated. Best wishes Hal

6th January 2008, 10:32 AM	#7 (permalink)
Ergo pro webdeveloper Join Date: Jul 2006 Location: Poland Posts: 277	yay, soon we will have postgres 8.x across whole fleet i need to advertise dotable to some other ppl that need it, you will get more clients , not many other companies that provide it and have a decent reputation :] __________________ http://www.linkedin.com/in/marcinlulek - my linkedIn profile - please check out Freelance professional webdeveloper for hire - XHTML, CSS2, PHP 5 , SOON PYTHON, MySQL, PostgreSQL, SQLite, Ajax & Javascript [ using yahooUI and dojotoolkit for ajax work ], database performance optimisation, security audits. - contact me , get work done the way it should be.

8th January 2008, 09:24 AM	#8 (permalink)
hal Member Join Date: May 2006 Posts: 45	That's fantastic news, Steve. Thank you very much for doing that. Just to let you know, I don't have any pg databases as far as I know, so were your comments directed at Ergo? If you still think one of my clients may have set them up, would you mind contacting me privately so that I can contact them accordingly to pass on your advice? Many thanks H

10th January 2008, 10:14 AM	#10 (permalink)
hal Member Join Date: May 2006 Posts: 45	Steve Would it be possible for you to set the default encoding to utf-8 or unicode when you upgrade postgres, please? I believe the default locale is C, which is ideal for me. Also, will the upgrade to 8.2 be reflected in phpinfo and phpPgAdmin? Hope this is OK. H

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode