On 03/11/2010 10:29, Gabriele Bulfon wrote:
Hi,
I installed latest postgres from sources inside a custom environment of
mine.
This environment runs various services, all under a common user/group.
I need to run postgres under the same user/group, witout having to
create and use postgres user.
I could do it, and postgres starts.
But now I can't seem to connect to the database, because it says:
FATAL: role "postgres" does not exist
How can I let postgres run under my own user instead of postgres?
I can rebuild from sources, if needed.
Roles, or database users, are nothing whatever to do with operating
system users. The error you're getting is that the role under which
you're trying to connect doesn't exist within the PostgreSQL cluster.
Just specify the role when you're connecting - e.g., if using psql, do
something like this:
psql -U <role> <database>
HTH,
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
