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/
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 |