Re: [Dspace-tech] connections to db seem to be getting stuck (Dorothea Salo)

2007-01-19 Thread Damian Marinaccio
We've had this problem for years as well. It went away in 1.2.2, but upon moving to 1.3.2 and 1.4 its back... And for us its been worse this week than usual as well!! I've reported this a number of times to this list and the responses have always been varied. I've tried increasing the number

Re: [Dspace-tech] connections to db seem to be getting stuck (Dorothea Salo)

2007-01-19 Thread Mark H. Wood
What version of Postgres are you all running? We used to have these problems all the time. I think things got a lot better when I moved from the dusty old 7.4 recommended in the docs to 8.0.something and a recent JDBC driver. (I'm actually using the 8.1 driver.) -- Mark H. Wood, Lead System

Re: [Dspace-tech] connections to db seem to be getting stuck (Dorothea Salo)

2007-01-19 Thread Mark Diggory
The following does a decent postgres dump of dspace (we use it nightly to production as a backup and as means to copy/move the database into another instance: as your dspace user: pg_dump -o -C -Fc dspace /tmp/dspace-db.out' pg_restore -c -d dspace /tmp/dspace-db.out' I used the same to