Hi Vinsenso,
7) Database
If you have pgadmin3 working, and connected to your database. Then the query
tool there works fine. You can just open the patch sql file, and hit
play/run, and it should work. I think thats your easiest route.
Linux users typically have the terminal open the entire day, and you type
psql right in the terminal and it executes postgres sql right there. Under
windows, I'm not so confident that that is as simple to do using command
prompt
8) Configs
The dspace.cfg.new files are from ant update. To be safe, ant didn't want to
blow out your existing configs, because you have local customizations that
might not be backed up, so it creates the overlay it wanted to write right
next to the file. So you can look at each dspace.cfg and dspace.cfg.new and
look for differences, such as local customizations you have made that might
not be in the *.new file. So it might be best to copy your local settings
i.e. password, My University into the *.new config file. While leaving
whatever new features that exist in the *.new file (1.6 new feature 1...)
and then rename *.new to *.cfg ..
Or, you can apply your local customizations to the
[dspace-source]/config/dspace.cfg file so that when you do mvn package, and
ant update, the code will all already have your customizations in it. In
this case, you can then do ant update -Doverwrite=true and instead of making
dspace.cfg*.new* files, it will instead just overwrite whatever was there...
with what is in [dspace-source]/config/dspace.cfg
So, know what you want to do, otherwise it might eat your existing
configuration.
10) Once you execute the database upgrade script (7), then your dspace will
work correctly. That means internal server errors should be gone, and you
can run the index command.
Good luck
On Thu, Apr 8, 2010 at 8:52 AM, Mark H. Wood <[email protected]> wrote:
> On Wed, Apr 07, 2010 at 07:19:08PM -0700, Vinsenso wrote:
> > > Um, 'psql', as the example says. Or do you mean, what OS user should
> > > you be at this point? it doesn't matter; the DBMS user determines your
> > > access to the DBMS.
> >
> > Hmm...
> > I mean I don't know where to write the command (psql -U dspace -f
> > /dspace-1.6.0-src-release/dspace/etc/postgres/database_schema_15-16.sql
> > dspace).
> >
> > Whether it is from SQL shell(psql) / Command Prompt / Query tool in
> pgAdmin
> > III / others..?
>
> It starts with 'psql', which is the name of the Pg commandline query
> tool, so it's entered at the command prompt.
>
> --
> Mark H. Wood, Lead System Programmer [email protected]
> Balance your desire for bells and whistles with the reality that only a
> little more than 2 percent of world population has broadband.
> -- Ledford and Tyler, _Google Analytics 2.0_
>
>
> ------------------------------------------------------------------------------
> Download Intel® Parallel Studio Eval
> Try the new software tools for yourself. Speed compiling, find bugs
> proactively, and fine-tune applications for parallel performance.
> See why Intel Parallel Studio got high marks during beta.
> http://p.sf.net/sfu/intel-sw-dev
> _______________________________________________
> DSpace-tech mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/dspace-tech
>
>
--
Peter Dietz
Systems Developer/Engineer
Ohio State University Libraries
------------------------------------------------------------------------------
Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
_______________________________________________
DSpace-tech mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-tech
