Open MPI logo

MTT Devel Mailing List Archives

  |   Home   |   Support   |   FAQ   |  

This web mail archive is frozen.

This page is part of a frozen web archive of this mailing list.

You can still navigate around this archive, but know that no new mails have been added to it since July of 2016.

Click here to be taken to the new web archives of this list; it includes all the mails that are in this frozen archive plus all new mails that have been sent to the list since it was migrated to the new archives.

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