Am Montag, 28. März 2005 13:46 schrieb Gustavo Franklin Nóbrega - Planae: > Hi Janning! > > You need to expand your pg_xlog partition. If you use reiserfs, you can > do this with resize_reiserfs. If you use ext2/ext3 you may try reise2fs.
This is not an option to me at the moment. because my disk is only 120 GB. With 100 GB of xlog files i dont have any space at all besides some small amount of disk space on other partitions like /usr etc. > If you need to repartition your filesystem, by myself experience, I > recommend to you to use LVM. With LVM, you can expand easily, add more disk > to you volume group and grow your logical volume. This already saved me > some hours of maintenance a time. Yes, i really need to take a look to LVM after cooling down again. kind regards, janning > Atenciosamente, > > Gustavo Franklin Nóbrega > Infraestrutura e Banco de Dados > Planae Tecnologia da Informação > (+55) 14 2106-3514 > http://www.planae.com.br > ----- Original Message ----- > From: "Janning Vygen" <[EMAIL PROTECTED]> > To: <pgsql-general@postgresql.org> > Sent: Monday, March 28, 2005 7:19 AM > Subject: [GENERAL] pg_xlog disk full error, i need help > > > PANIC: could not write to file > > "/home/postgres/data/pg_xlog/xlogtemp.6434": > > No space left on device > > server closed the connection unexpectedly > > This probably means the server terminated abnormally before or while -- PLANWERK 6 websolutions Herzogstraße 85, 40215 Düsseldorf Tel.: 0211-6015919 Fax: 0211-6015917 http://www.planwerk6.de ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
