Strange behavior

From: "Alexander B(dot)" <burbello3000(at)yahoo(dot)com(dot)br>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Strange behavior
Date: 2007-03-27 19:32:39
Message-ID: 46097157.3040100@yahoo.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

some developers were using the database, and suddenly no one could connect.
Just only some connections that was established before.

As soon as I was advised, I noticed that no postgres process were
present, just only connections and they could run queries normally.
Like this:
desenv:~# ps -ef |grep postgres
postgres 28010 27886 0 15:28 ? 00:00:00 postgres: desenv fabrica
10.90.2.116(57749) idle in transaction
postgres 28013 27886 0 15:29 ? 00:00:00 postgres: desenv fabrica
10.90.2.112(51326) idle
postgres 28051 27886 0 15:33 ? 00:00:01 postgres: desenv fabrica
10.90.2.115(51671) idle in transaction
postgres 28110 27886 0 15:36 ? 00:00:00 postgres: desenv teste
10.90.2.14(48903) idle in transaction
postgres 28134 27886 0 15:36 ? 00:00:01 postgres: desenv fabrica
10.90.2.115(60894) idle in transaction

Strange that no log about what happened, were written.
When I tried to stop, no process message was returned.
Then, I started postgres again, and everything come back to run.

Is there some patch to apply? Is it normal?

Using PostgreSQL 8.1.4 on x86_64-pc-linux-gnu, compiled by GCC cc (GCC)
3.3.5 (Debian 1:3.3.5-13)

Thanks
Alexander


_______________________________________________________
Yahoo! Mail - Sempre a melhor opção para você!
Experimente já e veja as novidades.
http://br.yahoo.com/mailbeta/tudonovo/

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Simon Riggs 2007-03-27 20:24:10 Re: Priorities for users or queries?
Previous Message Alvaro Herrera 2007-03-27 17:06:29 Re: autovacuum question