Re: Best practice non privilege postgres-user

I do not know of anything that can't be done from within psql.
We use non-privileged user roles in postgres for day-to-day operations.
When I need to modify the schema, I become postgres (you can do \c -
postgres) and do what I need to do, then revert back to my regular user.

On Fri, Aug 17, 2012 at 4:23 AM, Frank Lanitz <frank(at)frank(dot)uvena(dot)de> wrote:

> Hi folks,
>
> I'm looking for some kind of best practice for a non-privilege postgres
> user. As not all operations can be done within psql you might need
> access to postgres- on command line from time to time. Currently this is
> done via root-privvileges and »su - postgres« directly on database
> server - which is might not the best idea. Therefor our goal is to limit
> access to a little number of people on the first hand and don't
> necessary give them root-privileges on the databse server. We
> experimented a bit with sudo but had issues with some of the
> environmental variables. So my question is: do you have any best
> practice how to manage this? Is there any golden rule for this?
>
> Cheers,
> Frank
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

--
Moshe Jacobson
Nead Werx, Inc. | Senior Systems Engineer
2323 Cumberland Parkway, Suite 201 | Atlanta, GA 30339
moshe(at)neadwerx(dot)com | www.neadwerx.com