PostgreSQL maintains its own package repositories for binary packages for the most common Linux distributions and operating systems, which allows you to stay up to date through your familiar package manager. If you are running Debian 6 (Squeeze), you may be using the default PostgreSQL 8.4 and if you are running Debian 7 (Wheezy) it ships with PostgreSQL 9.1. Every major version of PostgreSQL comes with significant performance improvements and feature upgrades.
To update your Debian machine to the latest PostgreSQL version all you need to do is to create an additional apt-get source list /etc/apt/sources.list.d/pgdg.list and insert the following line for Debian 6: deb http://apt.postgresql.org/pub/repos/apt/ squeeze-pgdg main
or the following line for Debian 7: deb http://apt.postgresql.org/pub/repos/apt/ wheezy-pgdg main
Furthermore you will have to import the PostgreSQL repository signing key wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | \
apt-key add -
After updating your package repositories, and upgrading apt-get update ; apt-get upgrade
PostgreSQL should be upgraded and you should have two database server versions running. In my case 8.4 with all the previous data and 9.2 with no data.
To migrate the database content from the old version to the new database system (8.4 and 9.2 on my machine) you switch to the postgres user and erase the database that was created during installation of the new database system. Afterwards a pg_upgrade command will dump the data of the old server and import it into the new server. su postgres
pg_dropcluster --stop 9.2 main
pg_upgradecluster 8.4 main
Finally you can uninstall your old version of PostgreSQL.
Wow! Today’s update for Google Glass is huge. XE7 – Version 7 of the Explorer Edition ships a mobile web browser that allows you to open links from your google search results. Also try searching “youtube <your favorite show>” to get the video stream displayed right on Glass. After XE6, which brought Photo quality improvements, XE7 seems like a big Power Up. Google Glass just became so much more powerful.
We just won $1000 – One Thousand US Dollars! Awesome! Thank you Intel!
During the time of December 17th to February 20th Intel held the Perceptual Computing Challenge Phase 1. I entered “Google Earth Controller”, an application demonstrating touch-free navigation of Google Earth utilizing an Interactive Gesture Camera and the Intel Perceptual Computing SDK.
It allows you to fly like Superman across Earth or other planets while staying seated in your favorite chair! See video below.
Yesterday afternoon the winners were announced and Team “W” is happy that “Google Earth Controller” was awarded with Second Place. While this was just a weekend warm-up hack we are getting ready for Phase 2 of the challenge. Stay tuned!
Apple’s annual Worldwide Developers Conference is an exciting event providing an in-depth and inside look at the latest in iOS and OS X. Tickets are always high in demand and have sold out within two hours this year. In addition to the regular tickets, which sold for $1599, Apple accepted applications for one of 150 scholarships.
I have been very excited all day when I received an email from Apple granting me a scholarship to attend WWDC 2012. Thank you, Apple!
At today’s keynote of the Intel Developer Forum 2011, Intel CEO Paul Otellini presents Intel’s vision about the future of computing. It came by surprise to see Google’s Senior Vice President of Mobile Andy Rubin get on stage during the keynote. Paul Otellini and Andy Rubin announced a strategic partnership between Google and Intel for delivering x86 phones and tablets running Android. So that raises the question: what is going to happen to Intel’s own Linux platform for tablets and phones MeeGo? Paul Ottelini reassured the audience, that Intel will keep the collaboration with industrial partners utilising MeeGo on embedded devices.
Furthermore for laptops the trend goes towards Ultrabooks says Paul Otellini. Intel focusses on making them lighter, faster, cheaper, less power consuming and more responsive. A few Ultrabooks are exhibited on stage. A demo computer shows in which direction mobile computing may go: an ultra low voltage cpu prototype powered by a solar cell and executing Windows.
Cisco shows the next generation office phone. It looks like their current line of IP phones, however it’s color screen is actually a detachable android tablet powered by an atom cpu, I guess.
For a seamless collaboration of mobile and stationary gadgets, Paul Otellini presents Intel Pair & Share, which enables phones, tablets, computers and TVs to connect to each other and show notifications and messages on the currently used device.
I consider myself lucky, getting one of the ~5000 Tickets for this year’s Google I/O, which sold out in 59 minutes. We heard exciting news about the next Version of Android “Ice Cream Sandwich”, which will fuse the latest Phone and Tablet Operating Systems Gingerbread and Honeycomb. On Day 2 Google announced the shipment of Chromebooks from different manufacturers. Chrome OS is Google’s Client system for Cloud based computers. Traditionally – like every year – attendants got a huge gift pack. I have to admit, I have never been so thrilled at a Technology Conference.
For full details about Google I/O, check out their excellent online session catalogue: Google I/O 2011.
I am very excited to announce, that as of today, AquaChem is available in the BlackBerry App World. AquaChem is a handy tool to solve common Aquatic Chemistry equations for determination of Activity Coefficients, Ionization Fractions and Equilibrium Constants. The application provides students with a simple means of performing laborious calculations, the underlying chemistry of the problem being studied can be the primary focus rather than the calculations.