Skip site navigation (1) Skip section navigation (2)

Re: Tons of postgres.exe processes

From: "Stan Vassilev" <sv_forums(at)fmethod(dot)com>
To: <pgsql-hackers-win32(at)postgresql(dot)org>
Subject: Re: Tons of postgres.exe processes
Date: 2005-07-02 09:09:03
Message-ID: 004301c57ee5$b3c2dd30$0201a8c0@SV (view raw or flat)
Thread:
Lists: pgsql-hackers-win32
>> Hi, so I installed native 8.03 on my XP SP2 box - just for
>> testing, I need only support for about 3-4 simult. connections.
>>
>> However I installed it and open the Task manager - and see at
>> least a hundred instances of postgres.exe process in there...
>> And I can't find a way to remedy this. I have no running
>> connections so technically it's redundant to have that amount
>> of processes.
>
>That's certainly not supposed to happen.
>
>What kind of application are you using? Are you 100% sure that it
>actually closes the connections as it should? The situation sounds a bit
>like a runaway connection pooling or such thing...
>
>If you run a "SELECT * FROM pg_stat_activity" query, does it show up all
>the processes as active backends?

no idea, psql doesn't want to accept my password... while pgAdmin connects 
fine with the same.... no idea what's going on anymore. can I run sql query 
from pgadmin? how?

>
>> Also I started experiening apps failing to start, show menus
>> or init other controls properly when running postgres.
>> Otherwise I could connect with the GUI admin and make a db
>> and a table in it...
>
>That would be the classic symptoms of a windows system running out of
>memory...

The processes appear to take 60kb RAM (most), and I don't have anything 
taking a lot of RAM (I have 1GB ram). So I guess an x-file again :( 


In response to

Responses

pgsql-hackers-win32 by date

Next:From: John A MeinelDate: 2005-07-02 15:26:42
Subject: Re: Tons of postgres.exe processes
Previous:From: Magnus HaganderDate: 2005-07-01 22:35:16
Subject: Re: Tons of postgres.exe processes

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group