Re: PostgreSQL Processes on a linux box

On Fri, Apr 11, 2008 at 7:09 AM, Stefan Sturm
<stefan(dot)s(dot)sturm(at)googlemail(dot)com> wrote:
> Hello,
>
> altered a database using DBVisualizer. When I hit execute, DBVisualizer
> stoped working and no I have two processes on my server:
> postgres 30873 0.0 0.7 46552 7124 ? Ss 12:33 0:01 postgres:
> postgres dbName 10.0.1.198(53658) ALTER TABLE waiting
> postgres 31007 0.0 0.6 46708 6500 ? Ss 13:07 0:00 postgres:
> postgres dbName 10.0.1.198(53799) SELECT waiting

Are these the only two postgres processes on this box? You should
have a few others that look something like this:

/usr/lib/postgresql/8.3/bin/postgres -D .......
postgres 5178 0.0 0.0 40268 692 ? Ss Apr07 0:00
postgres: writer process
postgres 5179 0.0 0.0 40268 612 ? Ss Apr07 0:00
postgres: wal writer process
postgres 5180 0.0 0.0 40268 836 ? Ss Apr07 0:00
postgres: autovacuum launcher process
postgres 5181 0.0 0.0 11588 588 ? Ss Apr07 0:00
postgres: stats collector process

If those are the only two postgres processes then something's gone wrong.

If not, then find out what other processes are blocking the ones you
have that are waiting.