[Dspace-tech] PSQL Error when making a copy of postgres db

2009-11-11 Thread Timo Aalto
Hi, I'm trying to copy a DSpace PostgreSql database from one server to another to create a separate testing/dev environment. Dumping (pg_dump database db.sql) and reloading (psql database db.sql) the SQL to the second server seems to work fine. However when I try to access the DSpace XMLUI using

[Dspace-tech] PSQL error

2007-11-05 Thread Mika Stenberg
I started having these out of nowhere when trying to submit files to DSpace. Any ideas how can I fix this. Restaring, re-indexing or vacuuming the db doesnt help. My guess is that some item is maliciously left hanging and thus blocking the way for other items. -Mika

[Dspace-tech] Psql error

2007-09-05 Thread Mika Stenberg
Im getting a whole lot of errors in my log file (Dspace 1.4.2, Manakin 1.1 (trunk)) . The one Im worried about is this. Has anyone experienced this and perhaps solved it? Thanks, Mika LOG: unexpected EOF on client connection org.postgresql.util.PSQLException: An I/O error occured while

Re: [Dspace-tech] Psql error

2007-09-05 Thread James Rutherford
On Wed, Sep 05, 2007 at 04:27:27PM +0300, Mika Stenberg wrote: LOG: unexpected EOF on client connection This is a problem caused by DSpace not properly closing database connections. It's nothing to worry about really (although it is probably indicative of sloppy / incorrect use of the Context