Re: [MTT devel] Time to make the 2009 mtt database partitions?
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
Re: [MTT devel] Time to make the 2009 mtt database partitions?
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-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
Re: [MTT devel] Time to make the 2009 mtt database partitions?
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] Time to make the 2009 mtt database partitions?
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