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:
So we should be all set for 2009 :)
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:
> 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
> ./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.
> On Dec 1, 2008, at 10:07 AM, Ethan Mallove wrote:
>> \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
>> mtt-devel mailing list
> mtt-devel mailing list