Search Postgresql Archives

Re: help: production db stuck in startup mode

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Wednesday July 20 2005 1:13 pm, Ed L. wrote:
> I have a 7.4.6 db running on itanium hpux 11.23.  It appears a
> vacuum ran out of disk space,

Oh, and of course, we created extra diskspace before 
restarting...

Ed

>
> 2005-07-20 13:47:43 [6161]   ERROR:  DBI::do failed for SQL
> [VACUUM VERBOSE] to database clincomm:  DBI error:  PANIC:
> could not write to file
> "/users/postgresql-7.4.6/data/pg_xlog/xlogtemp.6178": No space
> left on device
>
> Pgsql was unresponsive, so we sent SIGINT, then SIGQUIT, both
> with no response, so finally, sent SIGKILL, then used ipcrm to
> clear the shm and semaphores.  Then restarted, but upon
> restart, it's stuck in "FATAL:  the database system is
> starting up" mode.
>
> Any clues???
>
> Thanks,
> Ed
>
> ---------------------------(end of
> broadcast)--------------------------- TIP 3: Have you checked
> our extensive FAQ?
>
>                http://www.postgresql.org/docs/faq

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux