Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group