Restoring a Specific Table in a Postgres Database from Backup

So, for whatever reason, you see a dreaded error from postgres for your prized data table:

Error message from server: ERROR: invalid page in block 0 of relation base/30300/30333

I’ve been seeing that on (thankfully rare) occasions for a postgres db on an SSD for ownCloud. (The SSD concerned has known buggy firmware, but that . . . → Read More: Restoring a Specific Table in a Postgres Database from Backup

Raspberry Pi Five Million

What a lot of Pi and all for such a rapidly market disruptive and IT education enhancing development:

RaspberryPi.org: Five million sold!

Yesterday we received some figures which confirmed something we’ve suspected for a few weeks now: we’ve sold over five million Raspberry Pis.

The Pi has gone from absolutely nothing just under three years . . . → Read More: Raspberry Pi Five Million

Raspberry Pi 2 Flash Splash!

The Raspberry Pi is certainly hot in the news at the moment… Especially so for a rather unexpected news flash for some new naked components on the new board:

Raspberry Pi 2 is ‘camera shy’

The latest version of Raspberry Pi’s credit-card-sized budget computer reboots itself when exposed to camera flashes, users have found.

The . . . → Read More: Raspberry Pi 2 Flash Splash!

Raspberry Pi 2 go faster!

Folks,

Looks like there’s been some good Broadcom baking to make my SBC list obsolete with the latest spin of the Raspberry Pi hitting the headlines:

BBC: Raspberry Pi 2 unveiled with faster processor and more memory

A new budget-priced Raspberry Pi computer has been unveiled, offering child coders and others a faster processor and . . . → Read More: Raspberry Pi 2 go faster!

The ZX Spectrum locally reborn!

Some good local news for some pioneering 8-bit old tech reborn anew:

Remodelled ZX Spectrum production set to begin

Production is set to start on a remodelled version of the ZX Spectrum, which will come pre-installed with 1,000 classic game titles.

Nottinghamshire firm SMS Electronics will manufacture the Sinclair Spectrum Vega at its Beeston factory. . . . → Read More: The ZX Spectrum locally reborn!