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 hours, but psql still says that the system is starting up. > ( Db size is about 20 gb ) > the os is Ubuntu 4.0.3-1ubuntu5 > postgres is 8.1.4 There are known bugs in the recovery code; IIRC some of them may cause the recovery to hang. Update to 8.1.13 and try again. -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc.
