Re: pg_xlog disk full error, i need help

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" <vygen@gmx.de>
> 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