On Fri, Apr 11, 2008 at 7:09 AM, Stefan Sturm <stefan.s.sturm@xxxxxxxxxxxxxx> 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.
