Ok, I think I know what happened, kind of.. One of my users' databases was currupt. I actually had to delete the entire base/<dbname> folder. Then I went in and drop/created the DB again and it seems to work fine. Is there any was to know how this happened? I have a .tar of the currupt DB if someone is interested... I would hope that 7.1 fixes this issue, any thoughts? Thanks, Jeff Davis Jeff Davis wrote: > 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 > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] > > > ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
