| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | Benedek Laszlo <bene33(at)freemail(dot)hu> |
| Cc: | Pgsql General list <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: recovery do not finish |
| Date: | 2008-07-11 20:53:08 |
| Message-ID: | 20080711205308.GK4110@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Roberts, Jon | 2008-07-11 20:55:11 | Re: Default fill factor for tables? |
| Previous Message | Scott Marlowe | 2008-07-11 20:51:17 | Re: Default fill factor for tables? |