Running postgres with a different user/group

From: Gabriele Bulfon <gbulfon(at)sonicle(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Running postgres with a different user/group
Date: 2010-11-03 10:29:25
Message-ID: 31725673.36.1288780165320.JavaMail.root@www
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.
Thanx,
Gabriele.
-= Mail sent through WebTop2 =-

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Gerrit Seré 2010-11-03 11:00:35 Compiling PostgreSql 9.0 on Sparc Solaris (64 bit)
Previous Message Jasen Betts 2010-11-03 10:15:23 Re: Why Select Count(*) from table - took over 20 minutes?