Re: Number of Connections

> Hello,
>
> I'm a bit new to postgres.  Is there anyway to tell the current number of
> connections on a database or server?  I'm having a connection closing
> problem and would like to debug it somehow.  I know on Sybase you can
check
> a sys table to determine this.  Not familiar with how to do this on
> Postgres.

I use:
    ps ax | grep postgres | wc -l
Note the value is often one to high because is picks up the grep process.

Use
    ps ax | grep postgres
to look at the processes and see what IP are connected, what users, and what
the backend is doing (IDLE, SELECT, ..)