Open MPI logo

MTT Devel Mailing List Archives

  |   Home   |   Support   |   FAQ   |   all MTT Devel mailing list

Subject: Re: [MTT devel] Time to make the 2009 mtt database partitions?
From: Josh Hursey (jjhursey_at_[hidden])
Date: 2008-12-01 11:52:09


I just created the partitions and updated the scripts so they Grant
the proper permissions after creating the tables.

I also updated the wiki to document how to add these new tables:
   https://svn.open-mpi.org/trac/mtt/wiki/
ServerMaintenance#YearlyMaintenance

So we should be all set for 2009 :)

Cheers,
Josh

On Dec 1, 2008, at 11:06 AM, Josh Hursey wrote:

> Good catch. I have a reminder email set to be sent out later this
> month regarding this so we don't hit the same problem we had last
> year. But we should probably do it now so we don't forget later.
>
> There is a script here:
> server/sql/support/create-partitions.sh
>
> This will generate SQL files for all of the tables and indexes that
> we need. For 2009 it looks something like (XX is a short-cut for all
> months):
> ./create-partitions-mpi-install.pl 2009 XX > 2009-mpi-install.sql
> ./create-partitions-test-build.pl 2009 XX > 2009-test-build.sql
> ./create-partitions-test-run.pl 2009 XX > 2009-test-run.sql
> ./create-partition-indexes.pl 2009 XX > 2009-indexes.sql
>
> Then just run the generated SQL scripts into the database to create
> the tables.
>
> I can do this today, and send an email when it is done. I'll also
> add some documentation about this to the Wiki.
>
> Thanks,
> Josh
>
> On Dec 1, 2008, at 10:07 AM, Ethan Mallove wrote:
>
>> Folks,
>>
>> \dt doesn't show any 2009 tables in the "mtt" Postgres database. Will
>> the following commands (using 0-11) set us up for 2009?
>>
>> $ server/sql/support/create-partitions-mpi-install.pl 2009 00
>> $ server/sql/support/create-partitions-mpi-install.pl 2009 01
>> $ server/sql/support/create-partitions-mpi-install.pl 2009 02
>> ...
>> $ server/sql/support/create-partitions-test-build.pl 2009 00
>> $ server/sql/support/create-partitions-test-build.pl 2009 01
>> $ server/sql/support/create-partitions-test-build.pl 2009 02
>> ...
>> $ server/sql/support/create-partitions-test-run.pl 2009 00
>> $ server/sql/support/create-partitions-test-run.pl 2009 01
>> $ server/sql/support/create-partitions-test-run.pl 2009 02
>> ...
>>
>> -Ethan
>> _______________________________________________
>> mtt-devel mailing list
>> mtt-devel_at_[hidden]
>> http://www.open-mpi.org/mailman/listinfo.cgi/mtt-devel
>
> _______________________________________________
> mtt-devel mailing list
> mtt-devel_at_[hidden]
> http://www.open-mpi.org/mailman/listinfo.cgi/mtt-devel