| Lists: | pgsql-hackers-win32 |
|---|
| From: | "Magnus Hagander" <mha(at)sollentuna(dot)net> |
|---|---|
| To: | "Stan Vassilev" <sv_forums(at)fmethod(dot)com>, <pgsql-hackers-win32(at)postgresql(dot)org> |
| Subject: | Re: Tons of postgres.exe processes |
| Date: | 2005-07-01 22:35:16 |
| Message-ID: | 6BCB9D8A16AC4241919521715F4D8BCE094581@algol.sollentuna.se |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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?
> 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...
//Magnus
| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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 :(
| From: | John A Meinel <john(at)arbash-meinel(dot)com> |
|---|---|
| To: | Stan Vassilev <sv_forums(at)fmethod(dot)com> |
| Cc: | pgsql-hackers-win32(at)postgresql(dot)org |
| Subject: | Re: Tons of postgres.exe processes |
| Date: | 2005-07-02 15:26:42 |
| Message-ID: | 42C6B232.90801@arbash-meinel.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers-win32 |
Stan Vassilev wrote:
>>> 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 :(
Is there any way that you might have 2 postgresql processes running? Say
one cygwin process and one win32?
Just curious. That might explain why psql is not letting you connect,
because it is trying to connect to a different one.
Anyway, for pgAdmin, there is a button that looks like a pencil which
lets you execute arbitrary SQL requests. Or it should be under
"Tools/Query Tool" if you want it from the menu.
John
=:->