Hang up on connect

Greetings,

  I have a problem with one of my databases. When I try to connect to
one of my 3 databases using psql it's just hangs and I can't connect.
The other databases are still ok even after I get a hangup from the
damaged one.

  I'm sorry but I couldn't collect too much information. It simply
doesn't show any error messages or warnings.

  The only valuable info collected was from single user connection
atempt. But I still not sure if that zero length record could be the
responsible for the problem.

-bash-2.05b$ postgres -D /home/postgres/data bxs
LOG:  database system was interrupted at 2005-04-15 18:01:28 BRT
LOG:  checkpoint record is at 0/A0A8034
LOG:  redo record is at 0/A0A8034; undo record is at 0/0; shutdown FALSE
LOG:  next transaction id: 202541; next oid: 202391
LOG:  database system was not properly shut down; automatic recovery in
progress
LOG:  ReadRecord: record with zero length at 0/A0A8074
LOG:  redo is not required
LOG:  database system is ready

select * from cnfg_geral;
**hangs here**


By the way, pg_resetxlog doens't work too.

Has anyone seen something like this happening? Is there a way to fix it?

Thanks in advance.

Vilson


--
*José Vilson de Mello de Farias*
/Analista de Sistemas//
APL - IBD  (Interfaces e Bancos de Dados) /

*DÍGITRO TECNOLOGIA*
*E-mail:* vilson.farias@digitro.com.br
<mailto:vilson.farias@digitro.com.br%20>
*Messenger: *vilson.farias@hotmail.com
<mailto:vilson.farias@digitro.com.br%20>
*Fone:* (0xx48) 281-7314
*Fax:* (0xx48) 281-7000
*Site:* www.digitro.com.br <http://www.digitro.com.br%20>
<http://www.digitro.com.br%20>