Re: [GENERAL] recovery do not finish

2008-07-11 Thread Greg Smith
On Fri, 11 Jul 2008, Benedek Laszlo wrote: We have waited for more than 2 hours, but psql still says that the system is starting up. In addition to the suggestions you've gotten to try a later version instead, I'd add that you should consider running vmstat in another window while the recov

Re: [GENERAL] recovery do not finish

2008-07-11 Thread Simon Riggs
On Fri, 2008-07-11 at 16:53 -0400, Alvaro Herrera wrote: > Benedek Laszlo wrote: > > Hello, > > > > I have a serious problem with a production database. > > We had a no disk space left on device problem, and postgres did not stop, > > so it was killed ( kill -9 ) > > we made free space and reboo

Re: [GENERAL] recovery do not finish

2008-07-11 Thread Alvaro Herrera
Benedek Laszlo wrote: > Hello, > > I have a serious problem with a production database. > We had a no disk space left on device problem, and postgres did not stop, so > it was killed ( kill -9 ) > we made free space and reboot, but postgres not start properly. > We have waited for more than 2 hou

[GENERAL] recovery do not finish

2008-07-11 Thread Benedek Laszlo
Hello, I have a serious problem with a production database. We had a no disk space left on device problem, and postgres did not stop, so it was killed ( kill -9 ) we made free space and reboot, but postgres not start properly. We have waited for more than 2 hours, but psql still says that the sys