[Gmod-help] Chado Installation!

[Scott Cain]

Argh!  I meant "PostgreSQL 8.3".  I don't know if there ever was a
Postgres 3.0!

Scott

On Fri, 2008-03-28 at 11:04 -0400, Scott Cain wrote:
> Hi Ishen,
> 
> While there are places where a unix-like file system is assumed, it
> might not be too hard.  When many of the current tools were written,
> there wasn't an installer for PostgreSQL on Windows, so there wasn't
> much question about supporting it.  Now you can get postgres on Windows,
> so it might be doable.  Also, I've tried (though probably not with
> complete success) to allow command line switches to override assumptions
> about file locations (like /usr/local/gmod).
> 
> One Chado user, dictyBase.org, actually installed Chado on Oracle on
> Windows, they just had to put in a lot of work to make it happen; though
> I believe now they are in the process of migrating to Linux and
> PostgreSQL.
> 
> As Dave mentioned, I am working on the 1.0 release right now.  If you
> try to install on Windows and find that there are changes in the code
> that you need to make, please let us know, so that they can be rolled
> into the 1.1 release.
> 
> Finally, if you go down the path of use Windows without Cygwin, I would
> suggest that you avoid PostgreSQL 3.0 or greater.  I'm concerned that
> changes made to the database server may be incompatible with some of the
> software written for Chado.
> 
> Scott
> 
> On Fri, 2008-03-28 at 08:34 -0600, Dave Clements, GMOD Help Desk wrote:
> > Dear Ishen,
> > 
> > I am posting my response to your inquiry to the GMOD Schema list.
> > People on that list may have more to add.  If you have specific
> > questions about using Chado on Windows then that is a good place to
> > post them.  I recommend you subscribe to that list.
> > 
> > The short answer to your question is that we discourage people from
> > using Chado on Windows platforms.  Many parts of GMOD have a
> > Linux/Unix assumption and require work to adapt it to Windows.
> > 
> > However, I believe there are sites that run Chado on Windows, and your
> > use of Postgres will greatly reduce the number of problems you
> > encounter.
> > 
> > Another thing worth noting is that the 1.0 release of Chado is
> > imminent.  I would wait until it is released before starting your
> > Chado installation (or I would restart it when 1.0 comes out).
> > 
> > My recommendations:
> > 1. Subscribe to gmod-schema:
> > https://lists.sourceforge.net/lists/listinfo/gmod-schema
> > 2. Get the 1.0 release when it come out, and start installation
> > 3. When you hit problems, search the gmod-schema list to see if anyone
> > else has hit the same problem.  If not post your questions.
> > 
> > In the long term, the help desk has plans to provide more useful
> > information about GMOD on Windows, but this probably won't happen in
> > the next few months.
> > 
> > Regards,
> > 
> > Dave C
> > 
> > 
> > On Wed, Mar 26, 2008 at 6:02 AM, Ishen Seocharan
> > <Ishen.Seocharan at mrc.ac.za> wrote:
> > >
> > >
> > >
> > >
> > > Dear Sir,
> > >
> > >
> > >
> > > I am currently working on the MDSS project which is part of the IVCC funded
> > > project at the Medical Research Council in South Africa.
> > >
> > >
> > >
> > > We are in the process of designing a component of the MDSS and we want to
> > > use the Chado database in the development. From all the research which we
> > > have conducted on the internet, we have only come up with solutions which
> > > operate in UNIX platform. We don't use UNIX here.
> > >
> > >
> > >
> > > We are running Windows platforms at our workplace. Is it possible for you to
> > > help/guide us in any way to install Chado in a Windows platform.
> > >
> > >
> > >
> > > We are currently running the following:
> > >
> > > Windows XP/Windows Server 2003
> > > Postgres 8.2
> > >
> > >
> > >
> > > Any help will be appreciated.
> > >
> > >
> > >
> > > Regards,
> > >
> > > Ishen Seocharan
> > >
> > > IT Advisor
> > >
> > > Medical Research Council (SA)
> > >
> > > Recept: +27 31 203 4700
> > >
> > > Office: +27 31 203 4810
> > >
> > > Mobile: +27 83 681 4000
> > >
> > >
-- 
------------------------------------------------------------------------
Scott Cain, Ph. D.                                         cain at cshl.edu
GMOD Coordinator (http://www.gmod.org/)                     216-392-3087
Cold Spring Harbor Laboratory