From: Craig Ringer <ringerc@ringerc.id.au>
To: iliya g <gyozov2004@yahoo.com>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Postgres process
Date: Wed, 10 Aug 2011 14:14:56 +0800
Message-ID: <4E4221E0.8030907@ringerc.id.au> (raw)
In-Reply-To: <1312860397.93185.YahooMailNeo@web120526.mail.ne1.yahoo.com>
References: <1312860397.93185.YahooMailNeo@web120526.mail.ne1.yahoo.com>
On 9/08/2011 11:26 AM, iliya g wrote:
> Hi guys,
>
> I need some help discovering the processes that run on an instance. I
> know that there are many processes running on one instance and they are
> all called postges, but I was hoping you can help me find a way to
> uniquely identify each one of them. I want to discover what the process
> name is and what the does. Let me know if you have any suggestions.
On operating systems that support it, postgresql changes the process
name to tell you what it's doing.
On other operating systems, use the pg_stat_activity view. See the manual.
If you still need more information, please read this so you provide
enough detail to get a proper answer before following up:
http://wiki.postgresql.org/wiki/Guide_to_reporting_problems
... since you didn't even mention what operating system you were running
on in your question!
--
Craig Ringer
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: ringerc@ringerc.id.au, gyozov2004@yahoo.com
Subject: Re: Postgres process
In-Reply-To: <4E4221E0.8030907@ringerc.id.au>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox