| Andrew Cooke | Contents | Latest | RSS | Twitter | Previous | Next

C[omp]ute

Welcome to my blog, which was once a mailing list of the same name and is still generated by mail. Please reply via the "comment" links.

Always interested in offers/projects/new ideas. Eclectic experience in fields like: numerical computing; Python web; Java enterprise; functional languages; GPGPU; SQL databases; etc. Based in Santiago, Chile; telecommute worldwide. CV; email.

Personal Projects

Lepl parser for Python.

Colorless Green.

Photography around Santiago.

SVG experiment.

Professional Portfolio

Calibration of seismometers.

Data access via web services.

Cache rewrite.

Extending OpenSSH.

C-ORM: docs, API.

Last 100 entries

Taste + Texture; Time Invariance and Gauge Symmetry; Jodorowsky; Tomato Chutney; Analysis of Support for Trump; Indian SF; TP-Link TL-WR841N DNS TCP Bug; TP-Link TL-WR841N as Wireless Bridge; Sending Email On Time; Maybe run a command; Sterile Neutrinos; Strawberry and Banana Jam; The Best Of All Possible Worlds; Kenzaburo Oe: The Changeling; Peach Jam; Taste Test; Strawberry and Raspberry Jam; flac to mp3 on OpenSuse 42.1; Also, Sebald; Kenzaburo Oe Interview; Otake (Kitani Minoru) move Black 121; Is free speech in British universities under threat?; I am actually good at computers; Was This Mansplaining?; WebFaction / LetsEncrypt / General Disappointment; Sensible Philosophy of Science; George Ellis; Misplaced Intuition and Online Communities; More Reading About Japan; Visibilty / Public Comments / Domestic Violence; Ferias de Santiago; More (Clearly Deliberate); Deleted Obit Post; And then a 50 yo male posts this...; We Have Both Kinds Of Contributors; Free Springer Books; Books on Religion; Books on Linguistics; Palestinan Electronica; Books In Anthropology; Taylor Expansions of Spacetime; Info on Juniper; Efficient Stream Processing; The Moral Character of Crypto; Hearing Aid Info; Small Success With Go!; Re: Quick message - This link is broken; Adding Reverb To The Echo Chamber; Sox Audio Tools; Would This Have Been OK?; Honesty only important economically before institutions develop; Stegangraphy via PS4; OpenCL Mess; More Book Recommendations; Good Explanation of Difference Between Majority + Minority; Musical Chairs - Who's The Privileged White Guy; I can see straight men watching this conversation and laffing; Meta Thread Defending POC Causes POC To Close Account; Indigenous People Of Chile; Curry Recipe; Interesting Link On Marginality; A Nuclear Launch Ordered, 1962; More Book Recs (Better Person); It's Nuanced, And I Tried, So Back Off; Marx; The Negative Of Positive; Jenny Holzer Rocks; Huge Article on Cultural Evolution and More; "Ignoring language theory"; Negative Finger Counting; Week 12; Communication Via Telecomm Bids; Finding Suspects Via Relatives' DNA From Non-Crime Databases; Statistics and Information Theory; Ice OK in USA; On The Other Hand; (Current Understanding Of) Chilean Taxes / Contributions; M John Harrison; Playing Games on a Cloud GPU; China Gamifies Real Life; Can't Help Thinking It's Thoughtcrime; Mefi Quotes; Spray Painting Bike Frame; Weeks 10 + 11; Change: No Longer Possible To Merge Metadata; Books on Old Age; Health Tree Maps; MRA - Men's Rights Activists; Writing Good C++14; Risk Assessment - Fukushima; The Future of Advertising and Surveillance; Travelling With Betaferon; I think I know what I dislike so much about Metafilter; Weeks 8 + 9; More; Pastamore - Bad Italian in Vitacura; History Books; Iraq + The (UK) Governing Elite; Answering Some Hard Questions; Pinochet: The Dictator's Shadow; An Outsider's Guide To Julia Packages

© 2006-2015 Andrew Cooke (site) / post authors (content).

Updating Wikipedia (Mediawiki) to use Postgres 8.3

From: "andrew cooke" <andrew@...>

Date: Sun, 13 Jul 2008 17:39:18 -0400 (CLT)

This was rather painful.  I can't given an exact walkthrough because it
was one of the messy iterative "push this on the stack of alternatives"
problems, but the basic idea is:

- Copy your 8.2 data directory somewhere else
- Install 8.3
- Point 8.3 at you old data and do a dump of the Wiki database
- Install Mediawiki 1.12 (this has fixes for Postgres 8.3)
- Create a new database using Mediawiki 1.12 and Postgres 8.3
- Dump the (new, empty) 8.3 database
- By hand, edit the 8.3 database dump so that it includes the data
  from the 8.2 database dump (except for the revision table and the
  the tables related to the old text search stuff)
- Delete the 8.3 database and import from the (hand-merged) dump

In other words, for the tables that are in the 8.3 database, use the data
from the 8.2 database.

I did try the various methods described on blogs, and using various
scripts in the maintenance directory.  But only the above worked.  Given
the poos support for Postgres with Mediawiki it's probably worth moving to
MySQL (although last time I tried the XML dump didn't work with Postgres,
so I'm not sure how)

Andrew

Maybe too Negative?

From: "andrew cooke" <andrew@...>

Date: Tue, 15 Jul 2008 07:22:03 -0400 (CLT)

Perhaps I was too negative above.  In general Mediawiki works perfectly
(absolutely no previous problems) with Postgres.  However, in changing
from 8.2 to 8.3 Postgres changed how they handle text searches, which are
critical for Mediaiwik and so meant "significant" changes to the database.

So hopefully this was an exception.

Andrew

Comment on this post