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 sam
On Sun, Sep 25, 2011 at 00:07, Gregg Jaskiewicz wrote:
> My apps share same databases, so no good in that.
How about different users? You can create a separate user for each
application, and then GRANT them access to a single role.
Regards,
Marti
--
Sent via pgsql-general mailing list (pgsql-g
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.
So far I managed to hack together a netstat+awk+other command line
tools to get that information. (in your face - windows "server"
developers/admins :P)
-
On Fri, Sep 23, 2011 at 13:34, Gregg Jaskiewicz wrote:
> Basically, I got bunch of local processes connecting to postgresql,
> need to aggregate some sort of report about number of connections and
> its origin every so often.
The pg_stat_activity system view gives you the database name (datname)
Basically, I got bunch of local processes connecting to postgresql,
need to aggregate some sort of report about number of connections and
its origin every so often.
pg version is 8.3
Any ideas if there's tools to gather that info on linux ?
Netstat is the only one I know, but I have to parse/awk i
