postgres locks...
От | Jeff Davis |
---|---|
Тема | postgres locks... |
Дата | |
Msg-id | 3AA2001F.2020807@dynworks.com обсуждение исходный текст |
Ответы |
Re: postgres locks...
|
Список | 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
В списке pgsql-general по дате отправления: