Re: PostgreSQL Connections?

Can you show us the output for:

ps auxwww | grep ^postgres

that should explain a little more...

-------------
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)

On 1/10/07, Ashish Karalkar <ashish_karalkar(at)yahoo(dot)com> wrote:
>
> Hello All,
> I am running PostgresSQL 8.2 on Redhat Linux 4.
> When I look for the processes that are using postgres
> using ps aux|more
> I got lots of Idle processes with servers own IP
> address. Can anybody please tell me why this is
> happening.
>
> Also there are multiple processes for my single
> client(same IP) of which maximum are idle. are these
> processes means connection or there is a single
> connection starting many processes.
>
>
>
> I am having max connection =200
>
>
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>