On Tue, Mar 31, 2009 at 10:07:47PM +0700, Panyarak Ngamsritragul wrote: > As postgres, I tried to create a database: > createdb -U dspace -E UNICODE dspace > > But the command returned an error message: > createdb: could not connect to database postgres: FATAL: Ident > authentication failed for user "dspace"
Rightly so. Your user process is owned by 'postgres', not 'dspace',
and that is what the Ident daemon will report to PostgreSQL. Your
user and database credentials do not match, and that match is required
for Ident authentication.
> It is possible to create the database when I 'sudo su dspace'. This can
> even be done without specifying '-U dspace' in the command line.
Yes. Since the database/user pair in question is authenticated with
Ident, the matching usernames are sufficient.
> Is there anything wrong in this step ? I did do further to install the
> package, but finally failed.
Well, I think that the command should be 'createdb -O dspace -E
UNICODE dspace'. The database needs to be owned by 'dspace' but it
need not be *created by* 'dspace'. You should be able to use the
PostgreSQL superuser ('postgres') to create the database.
But it sounds like you have created the database properly. Maybe you
should tell us how far you got and what the error was that has stopped you.
--
Mark H. Wood, Lead System Programmer [email protected]
Friends don't let friends publish revisable-form documents.
pgp2vHAjgpHiT.pgp
Description: PGP signature
------------------------------------------------------------------------------
_______________________________________________ DSpace-tech mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-tech
