Argh. Now ya tell me. =P Thanks Stuart. I'll give this a try when I set up the second controller.
Warm regards, Jordan Michaels Vivio Technologies http://www.viviotech.net/ BlueDragon Alliance Member [EMAIL PROTECTED] Stuart James wrote: > Hi Jordan, > > Depending on what version of Sequoia you are using, if you create a > blank database which the recovery user has access to, when Sequoia > originally starts up it will create all the relevant tables for you. I > discovered this after trying to determine how to create the tables > myself. > > Regards, > > > > On Tue, 02 Oct 2007 11:49:05 -0700 > Jordan Michaels <[EMAIL PROTECTED]> wrote: > >> There we go. I found what I was looking for (example "Create table" >> statements) in the DTD: >> >> http://sequoia.continuent.org/dtds/sequoia-2.10.9.dtd >> >> =) >> >> Warm regards, >> Jordan Michaels >> Vivio Technologies >> http://www.viviotech.net/ >> BlueDragon Alliance Member >> [EMAIL PROTECTED] >> >> >> Jordan Michaels wrote: >>> Hey Robert, >>> >>> Hmm... That XML file looks almost exactly like the one I've been >>> looking at. I guess I'm just confused as to how the XML file >>> explains what fields I need to create in order to build proper >>> recovery tables. >>> >>> So no one has any working examples of tables that they're using? I'm >>> just looking for example structures to point me in the right >>> direction. >>> >>> Thanks in advance! >>> >>> Warm regards, >>> Jordan Michaels >>> Vivio Technologies >>> http://www.viviotech.net/ >>> BlueDragon Alliance Member >>> [EMAIL PROTECTED] >>> >>> >>> Robert Hodges wrote: >>>> Hi Jordan, >>>> >>>> Look in the example XML files under doc/example, such >>>> as RAIDb1-postgresl-cluster.xml. They show the tags to define >>>> recovery log tables. >>>> >>>> Thanks, Robert >>>> >>>> Robert Hodges, CTO, Continuent, Inc. >>>> Email: [EMAIL PROTECTED] >>>> <mailto:[EMAIL PROTECTED]> Mobile: +1-510-501-3728 >>>> Skype: hodgesrm >>>> >>>> >>>> On Oct 1, 2007, at 3:32 PM, Jordan Michaels wrote: >>>> >>>>> Hey all, >>>>> >>>>> I'm in the process of setting up a proof-of-concept cluster using >>>>> Sequoia. If I can get it up and working, I will be demonstrating >>>>> it to a board of directors in the next couple weeks who are >>>>> pretty anxious to see a functional example. >>>>> >>>>> Right now, I'm at the part where you set up the recovery tables >>>>> in your recovery database, but I'm concerned that I'm not seeing >>>>> all the columns that I will be needing in my databases. I'm >>>>> looking at this page: >>>>> >>>>> http://sequoia.continuent.org/doc/infocenter/topic/org.continuent.sequoia.doc/html/Write_the_RequestManager_element_definition.html >>>>> >>>>> And it implicitly gives SQL code on how to set up the first >>>>> table, but there are three more that it doesn't give example SQL >>>>> code for. I could attempt to guess at the table structure based >>>>> on the parameters of the example XML virtual database config >>>>> file, but I noticed that the example recovery log table does have >>>>> an actual table row that is not specified in the attributes of >>>>> the XML file (the "sqlColumnName_param" column - it's not >>>>> mentioned in the "hsqldb-raidb1-distribution-1.xml" file). >>>>> >>>>> Would someone be willing to share the SQL table structure code >>>>> for these other 3 tables they have set up and working? If someone >>>>> wouldn't mind posting that, I would be very appreciative. >>>>> >>>>> Thanks in advance! >>>>> -- >>>>> Warm regards, >>>>> Jordan Michaels >>>>> Vivio Technologies >>>>> http://www.viviotech.net/ >>>>> BlueDragon Alliance Member >>>>> [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> >>>>> _______________________________________________ >>>>> Sequoia mailing list >>>>> [email protected] >>>>> <mailto:[email protected]> >>>>> https://forge.continuent.org/mailman/listinfo/sequoia >>>> ------------------------------------------------------------------------ >>>> >>>> _______________________________________________ >>>> Sequoia mailing list >>>> [email protected] >>>> https://forge.continuent.org/mailman/listinfo/sequoia >>> _______________________________________________ >>> Sequoia mailing list >>> [email protected] >>> https://forge.continuent.org/mailman/listinfo/sequoia >>> >>> >> _______________________________________________ >> Sequoia mailing list >> [email protected] >> https://forge.continuent.org/mailman/listinfo/sequoia > > _______________________________________________ Sequoia mailing list [email protected] https://forge.continuent.org/mailman/listinfo/sequoia
