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