Re: [GENERAL] Running postgres with a different user/group

2010-11-03 Thread Raymond O'Donnell
On 03/11/2010 11:43, Gabriele Bulfon wrote: Thanx guys, all of your solutions are fine, but I could manage it in a different manner. Modified the ident map file to map my special system user to postgres, so I don't have to specify the postgres user any more ;) Good stuff! Glad you got it to wor

Re: [GENERAL] Running postgres with a different user/group

2010-11-03 Thread Gabriele Bulfon
bTop2 =- -- Da: Gabriele Bartolini A: Gabriele Bartolini Cc: Gabriele Bulfon pgsql-general@postgresql.org Data: 3 novembre 2010 12.26.04 CET Oggetto: Re: [GENERAL] Running postgres with a different user/group Hi Gabriele, I forgot to mention one thing.

Re: [GENERAL] Running postgres with a different user/group

2010-11-03 Thread Gabriele Bartolini
Hi Gabriele, I forgot to mention one thing. > That means that PostgreSQL is successfully running. Try and connect to the > database using a different user by passing the '-U' option to psql or by > setting the PGUSER environment variable. PostgreSQL creates a role/user inside the cluster with

Re: [GENERAL] Running postgres with a different user/group

2010-11-03 Thread Gabriele Bartolini
Hi Gabriele, On Wed, 3 Nov 2010 11:29:25 +0100 (CET), Gabriele Bulfon wrote: > I need to run postgres under the same user/group, witout having to create > and use postgres user. That's reasonable and perfectly doable with Postgres. > But now I can't seem to connect to the database, because it s

Re: [GENERAL] Running postgres with a different user/group

2010-11-03 Thread Raymond O'Donnell
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 c

[GENERAL] Running postgres with a different user/group

2010-11-03 Thread Gabriele Bulfon
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 ca