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(dot)farias(at)digitro(dot)com(dot)br
<mailto:vilson(dot)farias(at)digitro(dot)com(dot)br%20>
*Messenger: *vilson(dot)farias(at)hotmail(dot)com
<mailto:vilson(dot)farias(at)digitro(dot)com(dot)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>