On Fri, 17 Aug 2012 08:53:05 -0400
Moshe Jacobson wrote:
> 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
Frank Lanitz wrote:
> 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 d
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
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 -
