On 09/24/11 2:07 PM, Gregg Jaskiewicz wrote:
My apps share same databases, so no good in that. And I am very well aware of the new feature in 9.0 - but we're stuck in the 8.3 land for now.
you can still give the various apps different user accounts (roles) even if they all have to have the same permissions (perhaps by being members of the role that has the actual permissions). We're usually more specific about our roles.
and, do note, the pg_stat_activity table has the process ID as well as the client port.
netstat etc won't do you any good at all if any of the connections are remote.
-- john r pierce N 37, W 122 santa cruz ca mid-left coast -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
