Re: Update actions (with user name) inside PostgreSQL DB - any version on postgreSQL

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Khangelani Gama <kgama(at)argility(dot)com>
Cc: Robin Iddon <robin(at)edesix(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: Update actions (with user name) inside PostgreSQL DB - any version on postgreSQL
Date: 2012-03-14 17:10:26
Message-ID: CAOR=d=0efof4ezKPmVixniJi6JbLTf3zvrG4fCZWQA6O+1mcMQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Wed, Mar 14, 2012 at 5:24 AM, Khangelani Gama <kgama(at)argility(dot)com> wrote:
> thanks, the issue we have is that we have many Linux users having root
> access into the system.

That's the problem right there. Setup a separate db server that only
your DBA can log into the shell on. Then make it so that you have
proper access controls to the db via pg_hba.conf.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message David Fennell 2012-03-14 17:47:38 Streaming Replication Hooks
Previous Message Robin Iddon 2012-03-14 16:44:31 Re: Update actions (with user name) inside PostgreSQL DB - any version on postgreSQL