| From: | Frank Lanitz <frank(at)frank(dot)uvena(dot)de> |
|---|---|
| To: | Moshe Jacobson <moshe(at)neadwerx(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Best practice non privilege postgres-user |
| Date: | 2012-08-20 16:45:07 |
| Message-ID: | 20120820184507.5dda90a364b4b55429c265ce@frank.uvena.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, 17 Aug 2012 08:53:05 -0400
Moshe Jacobson <moshe(at)neadwerx(dot)com> 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 to do, then revert back to
> my regular user.
It's not only about the things that can be done from within psql. At
least originally. Some of our currently workflows are basing on real
shell access.
Cheers,
Frank
--
Frank Lanitz <frank(at)frank(dot)uvena(dot)de>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sebastien Boisvert | 2012-08-20 16:52:41 | postmaster.pid file auto-clean up? |
| Previous Message | Thalis Kalfigkopoulos | 2012-08-20 16:33:31 | Re: Different results from view and from its defintion query [w/ windowing function] |