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
