Re: URGENT: Out of disk space pg_xlog

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

 



Sorry for my rushed posting, as I was in a bit of a panic.

We moved the pg_xlog directory over to a 70GB partition, and after 15-20
minutes the automatic recovery finished.  Everything is working fine
now.

I would still appreciate a PG guru explaining how to estimate size for a
pg_xlog partition.  It seems like it can vary considerably depending on
how intensive your current transactions are.  Is there a way to
determine a maximum?

On Fri, 22 Dec 2006 11:06:46 -0500, "Jeremy Haile" <jhaile@xxxxxxxxxxx>
said:
> I created a 10GB partition for pg_xlog and ran out of disk space today
> during a long running update.  My checkpoint_segments is set to 12, but
> there are 622 files in pg_xlog.  What size should the pg_xlog partition
> be?  
> 
> Postmaster is currently not starting up (critical for my organization)
> and reports "FATAL: The database system is starting up" .
> 
> The log reports:
> 2006-12-22 10:50:09 LOG:  checkpoint record is at 2E/87A323C8
> 2006-12-22 10:50:09 LOG:  redo record is at 2E/8729A6E8; undo record is
> at 0/0; shutdown FALSE
> 2006-12-22 10:50:09 LOG:  next transaction ID: 0/25144015; next OID:
> 140986
> 2006-12-22 10:50:09 LOG:  next MultiXactId: 12149; next MultiXactOffset:
> 24306
> 2006-12-22 10:50:09 LOG:  database system was not properly shut down;
> automatic recovery in progress
> 2006-12-22 10:50:09 LOG:  redo starts at 2E/8729A6E8
> 
> 
> This has been running for 20 minutes.  What can I do?  Please help!
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
> 
>                http://archives.postgresql.org


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux