"Lee, Mija" writes:
> Again, 5 extra processes. 6939 is one example. I'm not sure what you are
> looking for from this command that is different from ps -ef?
> Update_process_title is turned on.
5 extra processes would be exactly what I'd expect in an 8.3
installation. I don't remember the mag
Calvo Franco; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] postgres processes not reflected in
pg_stat_activity
On Fri, Sep 4, 2009 at 12:17 PM, Lee, Mija wrote:
> I got it once I pointed to the ucb ps per Alvaro's suggestion. Thanks!
Here's what I see with a ps auwx :
So what do
On Fri, Sep 4, 2009 at 12:17 PM, Lee, Mija wrote:
> I got it once I pointed to the ucb ps per Alvaro's suggestion. Thanks! Here's
> what I see with a ps auwx :
So what does ps ax|grep postgres say?
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscri
y/what they are before doing so.
Mija
-Original Message-
From: Emanuel Calvo Franco [mailto:postgres@gmail.com]
Sent: Friday, September 04, 2009 11:01 AM
To: Lee, Mija
Cc: Scott Marlowe; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] postgres processes not reflected in pg_stat_activit
2009/9/4 Lee, Mija :
> Hi -
> Thanks for the response.
> I'm on solaris so the ps ax doesn't work for me. I think the equivalent
> is ps -ef which shows:
> postgres 6939 22678 0 15:49:49 ? 1:33
> /services/8.3.5/bin/postgres -D /services/pgdata2
> postgres 22678 16072 0 Aug 06 ?
Lee, Mija escribió:
> Hi -
> Thanks for the response.
> I'm on solaris so the ps ax doesn't work for me. I think the equivalent
> is ps -ef which shows:
hmm, did you try /usr/ucb/ps?
--
Alvaro Herrerahttp://www.CommandPrompt.com/
The PostgreSQL Company - Command
On Fri, Sep 4, 2009 at 10:32 AM, Lee, Mija wrote:
> Hi -
> Thanks for the response.
> I'm on solaris so the ps ax doesn't work for me. I think the equivalent
> is ps -ef which shows:
> postgres 6939 22678 0 15:49:49 ? 1:33
> /services/8.3.5/bin/postgres -D /services/pgdata2
> postgres
tgres processes that don't make a
connection?
Mija
-Original Message-
From: Scott Marlowe [mailto:scott.marl...@gmail.com]
Sent: Thursday, September 03, 2009 7:54 PM
To: Lee, Mija
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] postgres processes not reflected in
pg_stat_activity
On Thu, Sep 3, 2009 at 5:26 PM, Lee, Mija wrote:
> Hello:
> I have a server that has many more postgres processes (postgres -D
> , owned by postgres, listed with an ps -ef) than connections in
> pg_stat_activity. How can I find out what those processes are?
> I have been going through the docs and
Hello:
I have a server that has many more postgres processes (postgres -D
, owned by postgres, listed with an ps -ef) than connections in
pg_stat_activity. How can I find out what those processes are?
I have been going through the docs and found a reference to if the
autovacuum launcher should show
10 matches
Mail list logo
