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: Ethan Mallove (ethan.mallove_at_[hidden])
Date: 2008-12-01 12:04:08


On Mon, Dec/01/2008 11:52:09AM, Josh Hursey wrote:
> 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 :)

Thanks Josh!

-Ethan

>
> 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
>
> _______________________________________________
> mtt-devel mailing list
> mtt-devel_at_[hidden]
> http://www.open-mpi.org/mailman/listinfo.cgi/mtt-devel