This is how I've done it: su postgres createuser -U postgres -d -A -P dspace exit su dspace createdb --password -E UNICODE dspace
-mathias -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Hossein Hamam Sent: 23. huhtikuuta 2008 14:42 To: [email protected] Subject: [Dspace-tech] Creating database problem Dear All, Can someone explain the -A in createuser? And using which user should I issue these commands: createuser -U postgres -d -A -P dspace createdb -U dspace -E UNICODE dspace When I su as postgres user, I am able to apply the first command but when I issue the 2nd command, it gives me the below error: createdb: could not connect to database postgres: FATAL: Ident authentication failed for user "dspace" However, if I su as dspace, I am not able to issue the first command, but am able to issue the 2nd command. After some research I found that I should edit the file pg_ident.conf. But what should I edit? Did anyone face a similar problem? Thank you, ------------------------------------------------------------------------- This SF.net email is sponsored by the 2008 JavaOne(SM) Conference Don't miss this year's exciting event. There's still time to save $100. Use priority code J8TL2D2. http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javao ne _______________________________________________ DSpace-tech mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-tech ------------------------------------------------------------------------- This SF.net email is sponsored by the 2008 JavaOne(SM) Conference Don't miss this year's exciting event. There's still time to save $100. Use priority code J8TL2D2. http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone _______________________________________________ DSpace-tech mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-tech
