pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Alexander B. <burbello3000@yahoo.com.br>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Strange behavior
Date: Tue, 27 Mar 2007 16:32:39 -0300
Message-ID: <46097157.3040100@yahoo.com.br> (raw)

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/



view thread (2+ messages)  latest in thread

Message-ID: <46097157.3040100@yahoo.com.br>
Permalink:  ../46097157.3040100@yahoo.com.br/
Also on:    postgresql.org/message-id/46097157.3040100@yahoo.com.br

 · 

reply

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: burbello3000@yahoo.com.br
  Subject: Re: Strange behavior
  In-Reply-To: <46097157.3040100@yahoo.com.br>

* 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