Re: [Dspace-tech] Illegal argument exception

2008-01-24 Thread Mathias Hjelt
 In the last few days I've been getting errors like this:
 
 -- URL Was: http://deepblue.lib.umich.edu/dspace/handle/2027.42/31692
[..]
 Exception:
 java.lang.IllegalArgumentException: 2 Dec 2007 03:08:59 GMT at

org.apache.catalina.connector.HttpRequestBase.getDateHeader(HttpRequestB
 ase.java:860)

 My guess (and it is only a guess!) is that the date format being sent
by
 the crawler is incorrect, so Tomcat burps and spits it out.

We've also seen these since a few days back. HandleServlet.java does
this when the exception strikes:

long modSince = request.getDateHeader(If-Modified-Since);

So what happens is that the crawler is using an invalid
if-modified-since parameter in the http request. 

Now, our Tomcat doesn't seem to be creating any access logs (shouldn't
it?) so I can't check the source IP of this request. 

One odd thing is that the URL Was: section in the error mail I get is
missing the port number. I.e it shows
http://hostname/dspace/handle/xxx/yyy rather than
http://hostname:port/dspace/handle/xxx/yyy which is the only way our
DSpace can be acccessed since it's not listening to port 80. Probably
just a small bug in request.getRequestURL().toString() used by
storeOriginalURL but that's not very comforting..

best regards

Mathias Hjelt



-
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/
___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech


Re: [Dspace-tech] Help! Unable to pg_restore, utterly confused

2008-01-24 Thread Richard Jones
Hi Steve,

I usually use the following round of commands:

pg_dump dspace  my-database-dump.sql

Then remove and recreate the dspace database (for example):

dropdb dspace
createdb dspace

Then reimport the dump into the blank database:

psql dspace  my-database-dump.sql

Cheers,

Richard

 Yup, sorry -- should have included that.

 Dump was done using:

 /usr/local/pgsql/bin/pg_dump \
 --verbose \
 --oids \
 --create \
 --format=c \
 --username=dspace \
 dspace  dumpfile


 or more briefly,
 /usr/local/pgsql/bin/pg_dump --verbose -o -C -Fc -U dspace dspace  dumpfile

 So using the compressed format.

 Also, using postgresql 8.0.something


 Also, restore instructions say to use

 pg_restore -C -d postgres -U dspace dumpfile

 but when I include -d postgres I get this error:

 pg_restore: [archiver (db)] connection to database postgres failed: FATAL:  
 database postgres does not exist

 which is possibly a vital clue. Leaving out the -d postgres option, it 
 seems to work -- outputs lots of CREATE TABLE messages etc. -- but ... 
 results as below.

 Am I supposed to create a database named postgres after initdb?

 As I said -- I'm confused. :-(


 Regards,
 Steve


 Mark Diggory wrote:
   
 Steve,

 can you post the pg_dump command and options you've used?

 -Mark

 On Jan 23, 2008, at 9:08 PM, Steve Thomas wrote:


 
 I need help! I'm using pg_dump to make a backup of our database,
 and ...
 sensibly, I think ... wanted to confirm that we could restore from
 this
 dump using pg_restore.

 (Actually, I've done this once without drama, when migrating from our
 dev server to our production server.)

 So, on our dev server, I followed the instructions for pg_restore, but
 cannot get it to work (and thus now have no dev database!)

 I've gone right back to square one and reinstalled postgresql. Then:

 * ran initdb -- no problem

 * ran

 createuser -U postgres -d -A -P dspace ; createdb -U dspace -E
 UNICODE dspace

 as per instructions -- no problem.

 * ran pg_restore to restore data:

 pg_restore -C  -U dspace 200712061830

 This seemed to run OK, creating all the tables and adding data,
 but ...

 * if I run

 $ psql dspace dspace

 I get

 dspace= select * from item;
 ERROR:  relation item does not exist

 -- ie apparently there's no data.


 So, can anyone help with where I'm going wrong? Right now I have no
 dev server so I'm in deep ...


 Thanks,
 Steve

 --

 Stephen Thomas,
 Senior Systems Analyst,
 University of Adelaide Library
 UNIVERSITY OF ADELAIDE SA 5005 AUSTRALIA
 Phone: +61 8 830 35190
 Fax: +61 8 830 34369
 Email: [EMAIL PROTECTED]
 URL: http://www.adelaide.edu.au/directory/stephen.thomas
 CRICOS Provider Number 00123M

 ---
 This email message is intended only for the addressee(s) and
 contains information that may be confidential and/or copyright. If
 you are not the intended recipient please notify the sender by reply
 email and immediately delete this email. Use, disclosure or
 reproduction of this email by anyone other than the intended
 recipient(s) is strictly prohibited. No representation is made that
 this email or any attachments are free of viruses. Virus scanning is
 recommended and is the responsibility of the recipient.



 -
 This SF.net email is sponsored by: Microsoft
 Defy all challenges. Microsoft(R) Visual Studio 2008.
 http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/
 ___
 DSpace-tech mailing list
 DSpace-tech@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/dspace-tech

   
 -
 This SF.net email is sponsored by: Microsoft
 Defy all challenges. Microsoft(R) Visual Studio 2008.
 http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/
 ___
 DSpace-tech mailing list
 DSpace-tech@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/dspace-tech


 

 --

 Stephen Thomas,
 Senior Systems Analyst,
 University of Adelaide Library
 UNIVERSITY OF ADELAIDE SA 5005 AUSTRALIA
 Phone: +61 8 830 35190
 Fax: +61 8 830 34369
 Email: [EMAIL PROTECTED]
 URL: http://www.adelaide.edu.au/directory/stephen.thomas
 CRICOS Provider Number 00123M

 ---
 This email message is intended only for the addressee(s) and contains 
 information that may be confidential and/or copyright. If you are not the 
 intended recipient please notify the sender by reply email and immediately 
 delete this email. Use, disclosure or reproduction of this email by anyone 
 other than the intended recipient(s) is strictly prohibited. No 
 representation is made that this email or any attachments are free of 
 viruses. Virus scanning is recommended and is the responsibility of the 
 recipient.



 

Re: [Dspace-tech] How to get the connection to DSpace(how to build the DSpace request in Application)

2008-01-24 Thread James Rutherford
On Tue, Jan 22, 2008 at 11:45:55PM +, Feng Wang wrote:
 I have a question still. Can u give me a example for OAI,like search
 all the Papers about a person who named John, Smith. how whould the
 request in OAI look like? You know, i just wanna know, thanks

You'd need something like OAI-SQ (http://scout.wisc.edu/Projects/OAISQ/)
which DSpace doesn't support (it's an unofficial extension to the PMH
protocol). I performed some experiments with this a few months ago where
I hooked the SQ queries up to DSpace searches. Most of the code for
doing this is available as part of the pf-dspace prototype project on
google code. The relevant file is:

http://dspace-sandbox.googlecode.com/svn/prototypes/pf-dspace/trunk/dspace-oai/src/main/java/org/dspace/app/oai/DSpaceOAICatalog.java

see doRecordHarvest() and buildSet()

Note that parameters passed in the URL must correspond to indexed
metadata fields (ie: if you can't search for it using the basic /
advanced search utilities, you can't search for it with this
implementation of OAI-SQ).

If you want to use this code, you should download the files and diff it
against your DSpaceOAICatalog.java. I'm not sure when the last time the
pf-dspace branch was synced with trunk, but I think it was a long time
ago.

cheers,

Jim

-- 
James Rutherford  |  Hewlett-Packard Limited registered Office:
Research Engineer |  Cain Road,
HP Labs   |  Bracknell,
Bristol, UK   |  Berks
+44 117 312 7066  |  RG12 1HN.
[EMAIL PROTECTED]   |  Registered No: 690597 England

The contents of this message and any attachments to it are confidential
and may be legally privileged. If you have received this message in
error, you should delete it from your system immediately and advise the
sender. To any recipient of this message within HP, unless otherwise
stated you should consider this message and attachments as HP
CONFIDENTIAL.

-
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/
___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech


Re: [Dspace-tech] Help! Unable to pg_restore, utterly confused

2008-01-24 Thread Mark Diggory
On Jan 23, 2008, at 11:53 PM, Steve Thomas wrote:

 Yup, sorry -- should have included that.

 Dump was done using:

 /usr/local/pgsql/bin/pg_dump \
 --verbose \
 --oids \
 --create \
 --format=c \
 --username=dspace \
 dspace  dumpfile


You might try dumping to a file explicitly ( -f dumpfile )


 pg_restore -C -d postgres -U dspace dumpfile

 but when I include -d postgres I get this error:

I think you want to connect to the dspace database ( -d dspace )



 pg_restore: [archiver (db)] connection to database postgres  
 failed: FATAL:  database postgres does not exist

 which is possibly a vital clue. Leaving out the -d postgres  
 option, it seems to work -- outputs lots of CREATE TABLE messages  
 etc. -- but ... results as below.

 Am I supposed to create a database named postgres after initdb?

No


 createuser -U postgres -d -A -P dspace ; createdb -U dspace -E   
 UNICODE dspace

I usually use UTF8, I'm not sure if UNICODE is valid or not.


-Mark



~
Mark R. Diggory - DSpace Systems Manager
MIT Libraries, Systems and Technology Services
Massachusetts Institute of Technology




-
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/
___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech


[Dspace-tech] reindexing error

2008-01-24 Thread Chad Hansen
I recently upgraded to the 1.5 alpha version of DSpace.
Now, however, I would like to go back to my trusty 1.4.1 version (or 1.4.2 
would work too).

I am having a problem with the reindexing process.

When I run /dspace/bin/index-all, I get the following output:

Creating browse index
Indexing all Items in DSpaceError: Browse index NOT created
java.sql.SQLException: ERROR:  relation itemsbyauthor does not exist

at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:126)
at 
org.postgresql.jdbc1.AbstractJdbc1Connection.ExecSQL(AbstractJdbc1Connection.java:451)
at 
org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.java:281)
at 
org.postgresql.jdbc1.AbstractJdbc1Statement.executeUpdate(AbstractJdbc1Statement.java:179)
at 
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101)
at 
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101)
at 
org.dspace.storage.rdbms.DatabaseManager.updateQuery(DatabaseManager.java:519)
at 
org.dspace.storage.rdbms.DatabaseManager.updateQuery(DatabaseManager.java:539)
at org.dspace.browse.Browse.indexRemoveAll(Browse.java:631)
at org.dspace.browse.Browse.indexAll(Browse.java:599)
at org.dspace.browse.InitializeBrowse.main(InitializeBrowse.java:74)
Creating search index
Done with indexing

what do I do now?

--
Chad G.

-
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/
___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech


Re: [Dspace-tech] How to get the connection to DSpace(how to build the DSpace request in Application)

2008-01-24 Thread Mark Diggory

In SRW we have an example from our dome.mit.edu service

http://dome.mit.edu/dspace-srw/search/DSpace?query=dc.title+%3D+% 
22David%22+and+dc.creator+%3D+%22Michelangelo% 
22version=1.1operation=searchRetrievemaximumRecords=10startRecord=1 
resultSetTTL=300recordPacking=xml


-Mark

On Jan 24, 2008, at 7:03 AM, James Rutherford wrote:


On Tue, Jan 22, 2008 at 11:45:55PM +, Feng Wang wrote:

I have a question still. Can u give me a example for OAI,like search
all the Papers about a person who named John, Smith. how whould the
request in OAI look like? You know, i just wanna know, thanks


You'd need something like OAI-SQ (http://scout.wisc.edu/Projects/ 
OAISQ/)

which DSpace doesn't support (it's an unofficial extension to the PMH
protocol). I performed some experiments with this a few months ago  
where

I hooked the SQ queries up to DSpace searches. Most of the code for
doing this is available as part of the pf-dspace prototype project on
google code. The relevant file is:

http://dspace-sandbox.googlecode.com/svn/prototypes/pf-dspace/trunk/ 
dspace-oai/src/main/java/org/dspace/app/oai/DSpaceOAICatalog.java


see doRecordHarvest() and buildSet()

Note that parameters passed in the URL must correspond to indexed
metadata fields (ie: if you can't search for it using the basic /
advanced search utilities, you can't search for it with this
implementation of OAI-SQ).

If you want to use this code, you should download the files and  
diff it
against your DSpaceOAICatalog.java. I'm not sure when the last time  
the

pf-dspace branch was synced with trunk, but I think it was a long time
ago.

cheers,

Jim

--
James Rutherford  |  Hewlett-Packard Limited registered  
Office:

Research Engineer |  Cain Road,
HP Labs   |  Bracknell,
Bristol, UK   |  Berks
+44 117 312 7066  |  RG12 1HN.
[EMAIL PROTECTED]   |  Registered No: 690597 England

The contents of this message and any attachments to it are  
confidential

and may be legally privileged. If you have received this message in
error, you should delete it from your system immediately and advise  
the

sender. To any recipient of this message within HP, unless otherwise
stated you should consider this message and attachments as HP
CONFIDENTIAL.

-- 
---

This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/
___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech


-
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech


[Dspace-tech] Anchor for Add button in submission process

2008-01-24 Thread yinjin
Hi All,

I have this problem with DSpace 1.5 manakin, and probably the same in JSPUI 
too. 

In submission process, if I want to add more than one subject, when I click on 
Add button, the page refreshes and brings me back the top of the page, so 
that I have to scroll down to where I was. 

Is this a bug has been reported? If not, I will do it.

Thanks,
Ying-
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech


[Dspace-tech] Is v1.5 buildable in Eclipse? Please help.

2008-01-24 Thread Eric Luhrs
I have been trying to build v1.5 in Eclipse for the last few days, but have
been unsuccessful.  First I tried following the video tutorials, but ran
into POM validation errors.  Next, I followed the instructions on the wiki,
and got quite a bit closer.  The second time, I checked out the entire
1.5.xcode base as one project, and then tried to assemble it with
Maven.  I
didn't see any errors, but I couldn't find a target dir with the
pre-installation package of DSpace 1.5.

Am I doing something wrong, are the tutorials out of date, or is
v1.5unbuildable?

Eric

Output from Maven assemble:

[INFO] Reactor Summary:
[INFO]

[INFO] DSpace Parent Project . SUCCESS [
3.188s]
[INFO] DSpace Kernel :: API and Implementation ... SUCCESS [
5.321s]
[INFO] DSpace I18N :: Language Packs . SUCCESS [
4.913s]
[INFO] DSpace JSPUI :: Web Application ... SUCCESS [
11.401s]
[INFO] DSpace XMLUI (Manakin)  SUCCESS [
0.305s]
[INFO] DSpace XMLUI (Manakin) :: Wing-Framework .. SUCCESS [
2.503s]
[INFO] DSpace XMLUI (Manakin) :: API and Core Aspects  SUCCESS [
1.879s]
[INFO] DSpace XMLUI (Manakin) :: Web Application . SUCCESS [
10.989s]
[INFO] DSpace LNI  SUCCESS [
0.357s]
[INFO] DSpace LNI :: Core Implementation . SUCCESS [
1.268s]
[INFO] DSpace LNI :: Web Application . SUCCESS [
6.129s]
[INFO] DSpace LNI :: CLI Client Application .. SUCCESS [
9.867s]
[INFO] DSpace OAI :: Parent .. SUCCESS [
0.257s]
[INFO] DSpace OAI :: Libraries to support Web Application  SUCCESS [
0.812s]
[INFO] DSpace OAI :: Web Application . SUCCESS [
5.622s]
[INFO]

[INFO]

[INFO] BUILD SUCCESSFUL
[INFO]

[INFO] Total time: 1 minute 6 seconds
[INFO] Finished at: Thu Jan 24 14:43:11 EST 2008
[INFO] Final Memory: 22M/41M
[INFO]

-
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech


Re: [Dspace-tech] Is v1.5 buildable in Eclipse? Please help.

2008-01-24 Thread Mark Diggory
Eric,

Did you build in the top level directory or within the directory  
called dspace ( i.e. branches/dspace-1_5_x/dspace )

You need to build in the latter to get dspace to build an installable  
distribution in branches/dspace-1_5_x/dspace/traget/dspace-1.5- 
SNAPSHOT

This will get easier with our current plans for packaging the  
install for dspace, soon we will more than likely only distribute  
the above dspace directory alone as a sort of bootstrap  
distribution.

-Mark

On Jan 24, 2008, at 11:06 PM, Eric Luhrs wrote:


 I have been trying to build v1.5 in Eclipse for the last few days,  
 but have been unsuccessful.  First I tried following the video  
 tutorials, but ran into POM validation errors.  Next, I followed the  
 instructions on the wiki, and got quite a bit closer.  The second  
 time, I checked out the entire 1.5.x code base as one project, and  
 then tried to assemble it with Maven.  I didn't see any errors, but  
 I couldn't find a target dir with the pre-installation package of  
 DSpace 1.5.

 Am I doing something wrong, are the tutorials out of date, or is  
 v1.5 unbuildable?

 Eric

 Output from Maven assemble:

 [INFO] Reactor Summary:
 [INFO]  
 
 [INFO] DSpace Parent Project .  
 SUCCESS [ 3.188s]
 [INFO] DSpace Kernel :: API and Implementation ...  
 SUCCESS [ 5.321s]
 [INFO] DSpace I18N :: Language Packs .  
 SUCCESS [4.913s]
 [INFO] DSpace JSPUI :: Web Application ...  
 SUCCESS [11.401s]
 [INFO] DSpace XMLUI (Manakin)   
 SUCCESS [ 0.305s]
 [INFO] DSpace XMLUI (Manakin) :: Wing-Framework ..  
 SUCCESS [2.503s]
 [INFO] DSpace XMLUI (Manakin) :: API and Core Aspects   
 SUCCESS [1.879s]
 [INFO] DSpace XMLUI (Manakin) :: Web Application .  
 SUCCESS [ 10.989s]
 [INFO] DSpace LNI   
 SUCCESS [0.357s]
 [INFO] DSpace LNI :: Core Implementation .  
 SUCCESS [1.268s]
 [INFO] DSpace LNI :: Web Application .  
 SUCCESS [ 6.129s]
 [INFO] DSpace LNI :: CLI Client Application ..  
 SUCCESS [9.867s]
 [INFO] DSpace OAI :: Parent ..  
 SUCCESS [0.257s]
 [INFO] DSpace OAI :: Libraries to support Web Application   
 SUCCESS [ 0.812s]
 [INFO] DSpace OAI :: Web Application .  
 SUCCESS [5.622s]
 [INFO]  
 
 [INFO]  
 
 [INFO] BUILD SUCCESSFUL
 [INFO]  
 
 [INFO] Total time: 1 minute 6 seconds
 [INFO] Finished at: Thu Jan 24 14:43:11 EST 2008
 [INFO] Final Memory: 22M/41M
 [INFO]  
 
 -
 This SF.net email is sponsored by: Microsoft
 Defy all challenges. Microsoft(R) Visual Studio 2008.
 http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/___
 DSpace-tech mailing list
 DSpace-tech@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/dspace-tech


-
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/
___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech


Re: [Dspace-tech] Help! Unable to pg_restore, utterly confused

2008-01-24 Thread Filippos Kolovos
Dear Sir,

We had similar problems concerning the database restore.
The difference between us, is that we are using the pg_dumpall command, 
which exports
all the transactions of the database (i.e. with the relations creation, the 
user creations, etc).

Without knowing whether we could be of any help, I provide you with what we 
do in order
to restore our database.

1) With the pg_dumpall tool we create several bzipped2 dump files (i.e. 
database-dump-date.bzip2)
2) Choosing the desired bzipped file, we unzip it.
3) As root we execute psql -U postgres -f dbfilename, where the 
dbfilename is the extracted bzipped file.
4) We do an ant update to the dspace installation
5) We restart postgres and Tomcat

After that everything is OK. We have followed this prodecure to several 
dspace installations we have in our institution
and everything works out fine.

However, I would suggest to try this out to a test db first, because the 
information above is provided as is, with no warranty
of their success.

Hoping that we have helped you

Best Regards,

-Fk

-- 
Filippos Kolovos
Software Systems Analyst  Engineer
M.Sc. (Eng.) in Data Communications

Automation  Networking Department
University of Macedonia Library
Egnatia 156, P.O.Box 1591
540 06 Thessaloniki, Greece

E-Mail: [EMAIL PROTECTED],
   [EMAIL PROTECTED]
Profile: http://www.linkedin.com/in/filipposkolovos
---


- Original Message - 

 Message: 1
 Date: Thu, 24 Jan 2008 09:31:32 -0500
 From: Mark Diggory [EMAIL PROTECTED]
 Subject: Re: [Dspace-tech] Help! Unable to pg_restore, utterly
 confused
 To: Steve Thomas [EMAIL PROTECTED]
 Cc: Dspace-Tech dspace-tech@lists.sourceforge.net
 Message-ID: [EMAIL PROTECTED]
 Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes

 On Jan 23, 2008, at 11:53 PM, Steve Thomas wrote:

 Yup, sorry -- should have included that.

 Dump was done using:

 /usr/local/pgsql/bin/pg_dump \
 --verbose \
 --oids \
 --create \
 --format=c \
 --username=dspace \
 dspace  dumpfile


 You might try dumping to a file explicitly ( -f dumpfile )


 pg_restore -C -d postgres -U dspace dumpfile

 but when I include -d postgres I get this error:

 I think you want to connect to the dspace database ( -d dspace )



 pg_restore: [archiver (db)] connection to database postgres
 failed: FATAL:  database postgres does not exist

 which is possibly a vital clue. Leaving out the -d postgres
 option, it seems to work -- outputs lots of CREATE TABLE messages
 etc. -- but ... results as below.

 Am I supposed to create a database named postgres after initdb?

 No


 createuser -U postgres -d -A -P dspace ; createdb -U dspace -E
 UNICODE dspace

 I usually use UTF8, I'm not sure if UNICODE is valid or not.


 -Mark



 ~
 Mark R. Diggory - DSpace Systems Manager
 MIT Libraries, Systems and Technology Services
 Massachusetts Institute of Technology
 


-
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/
___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech