On Mon, Sep 14, 2009 at 2:11 PM, Ævar Arnfjörð Bjarmason <avarab@gmail.com> wrote:
On Sat, Sep 12, 2009 at 11:32 AM, Ævar Arnfjörð Bjarmason
<avarab@gmail.com> wrote:
> Marcin Cieslak (saper) which was at Wikimania 2009 and he's excited
> about helping set up our OSM system on the ptolemy and ortelius
> servers (see http://lists.wikimedia.org/pipermail/wikitech-l/2009-September/045131.html).
> He wants to help set up the database / tile rendering aspect (which is
> pretty much all we're doing).
> Here are his details as required for server admins:
>  * Name: Marcin Cieślak
>  * Email: Marcin Cieslak <saper@saper.info>
>  * Address: [CUT OUT]
> And he's agreed to follow our privacy policy:
> http://wikimediafoundation.org/wiki/Privacy_policy
> (not that there are any actual privacy concerns, these servers don't
> have any access to private data as explained in the wikitech-l
> posting)
> If you approve I'll take care of setting up his accounts on those servers.

Mark gave the OK. I've created the user saper on both boxes. Marcin,
you should be able to:

  ssh ptolemy.esams.wikimedia.org
  ssh ortelius.esams.wikimedia.org

Here's the notes I kept when setting up Cassini:

It would be very helpful if you continued updating that wiki page (or
related pages) with the stuff you do.

Open issues on the servers that need to be solved:

 * They need to be partitioned. There's some empty space on /dev/sd*
that hasn't been partitioned (> 1TB)
 * Evidently hardy's kernel doesn't like the RAID card on these boxes.
So the kernel needs to be upgraded, probably to jaunty-server

Have fun!

I haven't had so much free time lately, but am comfortable with helping set up and configure PostgreSQL and PostGIS and get the OSM database import going.  Though, there are many more tasks to do that I have time to do.

Partitioning the servers in an optimal manner for us is something I'm not as comfortable with.  I could figure it out if necessary, but Saper is probably better capable of that.  One thing I do know is that the database logs should be on separate partition from the database itself, and both kept separate from the OS.

Here are a list of tasks:


On Cassini, work is needed on PostgreSQL configuration.




Maps-l mailing list