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
