From: | Gabriele Bartolini <Gabriele(dot)Bartolini(at)2ndQuadrant(dot)it> |
---|---|
To: | Gabriele Bartolini <Gabriele(dot)Bartolini(at)2ndQuadrant(dot)it> |
Cc: | Gabriele Bulfon <gbulfon(at)sonicle(dot)com>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Running postgres with a different user/group |
Date: | 2010-11-03 11:26:04 |
Message-ID: | ccd4c543b3e2cea4490a811e2c4caa82@mail.xcon.it |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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 the same name as
the user that ran initdb.
Try and connect to either the postgres or the template1 database, by
executing:
psql template1
or
psql postgres
and then type:
\du
This will give you a list of the roles (users) inside the database.
Please make sure you specify the right port and host (or Unix socket) to
psql.
Ciao,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
Gabriele(dot)Bartolini(at)2ndQuadrant(dot)it - www.2ndQuadrant.it
From | Date | Subject | |
---|---|---|---|
Next Message | Gabriele Bulfon | 2010-11-03 11:43:50 | Re: Running postgres with a different user/group |
Previous Message | Gabriele Bartolini | 2010-11-03 11:19:32 | Re: Running postgres with a different user/group |