[Dspace-general] FW: [Dspace-tech] Postgres install

[Kevin Weekes]

-----Original Message-----
From: Kevin Weekes 
Sent: Thursday, July 29, 2004 12:39 PM
To: 'Jörn Nettingsmeier'
Subject: RE: [Dspace-tech] Postgres install


Thanks everyone for the insights.

I am getting a new error message though:


[dspace at localhost dspace-1.1.1-source]$ ant fresh_install
Buildfile: build.xml
...
setup_database:
     [java] 2004-07-28 16:20:00,689 INFO
org.dspace.storage.rdbms.InitializeDatabase @ Initializing Database



load_registries:
     [java] 2004-07-28 16:20:13,760 FATAL
org.dspace.administer.RegistryLoader @
anonymous:no_context:error_loading_registries:
     [java] java.sql.SQLException: ERROR:  SET AUTOCOMMIT TO OFF is no
longer supported

     [java]     at
org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:131)
     [java]     at
org.postgresql.jdbc1.AbstractJdbc1Connection.ExecSQL(AbstractJdbc1Connection
.java:482)
     [java]     at
org.postgresql.jdbc1.AbstractJdbc1Connection.ExecSQL(AbstractJdbc1Connection
.java:461)
     [java]     at
org.postgresql.jdbc1.AbstractJdbc1Connection.setAutoCommit(AbstractJdbc1Conn
ection.java:957)
     [java]     at
org.apache.commons.dbcp.DelegatingConnection.setAutoCommit(DelegatingConnect
ion.java:237)
     [java]     at org.dspace.core.Context.<init>(Context.java:103)
     [java]     at
org.dspace.administer.RegistryLoader.main(RegistryLoader.java:102)



BUILD FAILED
/usr/ds3rdPT/dspace-1.1.1-source/build.xml:258: Java returned: 1

Total time: 1 minute 9 seconds"

I'm a bit new to the whole Linux environment but I'm learning,

Thanks in advance.

-----Original Message-----
From: Jörn Nettingsmeier [mailto:pol-admin at uni-duisburg.de]
Sent: Monday, July 26, 2004 8:04 AM
To: Kevin Weekes
Cc: 'dspace-tech at lists.sourceforge.net'
Subject: Re: [Dspace-tech] Postgres install


Kevin Weekes wrote:
> Good day,
> I am in the process of following a dspace installation
> 
> I've gone thru the steps for the installation of the pre-requisite
software
> and they all appear fine.
> 
> However, when I try the ant fresh_install command I run into some
> difficulties.
> The message I get basically is that I can't connect to the database.
> 
> I find this odd as the relevant changes were made to the pg_hba and
> postgresql.conf files in the /var/lib directory
> 
> Can anyone shed some light on my predicament

did you restart postgres after changing the config?
it might help to post the relevant lines from your postgres config 
files, and the output of netstat -lpn.




-- 
Jörn Nettingsmeier, EDV-Administrator
Institut für Politikwissenschaft
Universität Duisburg-Essen, Standort Duisburg
Mail: pol-admin at uni-duisburg.de, Telefon: 0203/379-2736