postgres locks...

From: Jeff Davis <jdavis(at)dynworks(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: postgres locks...
Date: 2001-03-04 08:43:11
Message-ID: 3AA2001F.2020807@dynworks.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I think this is a bug, but I don't have really enough info to go on for
a report. I was running postgres on my server and everything seemed OK.
Eventually I figured out that some of my websites weren't loading and
connected it to postgres.

Basically, psql would sit there trying to connect, meanwhile all the
attempted connections wouldn't die. I had to "kill -9" all the
postgres/postmaster processes. Then I ran pg_ctl start, and it seemed
OK. However, same problem. So, I killed again, then ran ipcclean (there
were shm errors), the started and it worked. I had to delete a socket
file in /tmp also in order to get it going again.

During the time, I appearently lost several unimportant tables. I am
running 7.0.3/debian-woody. Is this a known problem? I really need to
have a reliable version of postgres running.

Thanks for any advice,
Jeff Davis

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bell John 2001-03-04 09:01:58 Set Like Data
Previous Message Christopher Sawtell 2001-03-04 06:49:35 Re: AW: AW: Addison-Wesley looking for authors