Re: Search connections created per day

>> Hi there,
>>
>> I want to know how many connections is created simultaneously in data
base
>> per day.
>
>Do you want to know the max simo connections at any given time, or the
>total connections in a given day?  Assuming you want to know the max
>simo connections at any given time, I think you're going to have to
>check pg_stat_activity every x minutes and store the number of rows
>somewhere to retrieve later.
>
>> Are there some table where i can search it?
>
>pg_stat_activity, but it only has the info for "right now" in it.

Thanks...

I want to know the max simo connections at any given time, but I only have
a backup of the database, so, I don't can use the pg_stat_activity.

This database is running in a client, and I should to know if he is creating
more connections of it is allowed.

Thanks.