2009/9/4 Lee, Mija <mija@scharp.org>:
> 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 ? 5:22
> /services/8.3.5/bin/postgres -D /services/pgdata2
> postgres 5074 22678 0 Aug 12 ? 710:08
> /services/8.3.5/bin/postgres -D /services/pgdata2
> postgres 8677 22678 0 Aug 13 ? 894:39
> /services/8.3.5/bin/postgres -D /services/pgdata2
> postgres 8347 22678 0 Aug 25 ? 357:27
> /services/8.3.5/bin/postgres -D /services/pgdata2
> postgres 343 22678 0 Aug 13 ? 368:30
> /services/8.3.5/bin/postgres -D /services/pgdata2
> postgres 8678 22678 0 Aug 13 ? 695:15
> /services/8.3.5/bin/postgres -D /services/pgdata2
> postgres 24793 22678 0 Aug 12 ? 2048:13
> /services/8.3.5/bin/postgres -D /services/pgdata2
> postgres 22690 22678 0 Aug 06 ? 106:15
> /services/8.3.5/bin/postgres -D /services/pgdata2
> postgres 22686 22678 0 Aug 06 ? 3:09
> /services/8.3.5/bin/postgres -D /services/pgdata2
> postgres 22691 22678 0 Aug 06 ? 1145:42
> /services/8.3.5/bin/postgres -D /services/pgdata2
> postgres 350 22678 0 Aug 13 ? 262:39
> /services/8.3.5/bin/postgres -D /services/pgdata2
> postgres 16593 22678 0 Aug 12 ? 731:57
> /services/8.3.5/bin/postgres -D /services/pgdata2
> postgres 22688 22678 0 Aug 06 ? 104:59
> /services/8.3.5/bin/postgres -D /services/pgdata2
>
> If I'm wrong about the ps commands, please correct me.
> When I cross reference this against pg_stat_activity, 5 of them don't
> show up, and a top shows the same processes using 0% cpu but almost a
> gig of memory. Are these internal postgres processes that don't make a
> connection?
> Mija
>
What is the value of update_process_title in your postgresql.conf? By
default is on, so you must see the title off the process.
what about ps auxw?
--
Emanuel Calvo Franco
DBA at: www.siu.edu.ar
www.emanuelcalvofranco.com.ar