Re: [MASSMAIL]My pg_xlog directory is becoming huge !?

From: "Gilberto Castillo" <gilberto(dot)castillo(at)etecsa(dot)cu>
To: "ben(dot)play" <benjamin(dot)cohen(at)playrion(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: [MASSMAIL]My pg_xlog directory is becoming huge !?
Date: 2016-09-12 13:51:58
Message-ID: 57728.192.168.207.54.1473688318.squirrel@webmail.etecsa.cu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


> Hi all,
>
> We tried to replicate our database and since this moment, our pg_xlog
> directory is becoming HUGE ! (more than 500 Gb !)
>
> In fact, each minute, there is a new file of 16Mb, called like
> 00000001000001370000004D ...
>
> This is our main parameters in postgresql.conf
>
>
>
> The replication is stopped (it was only a test). And I cannot put
> wal_level=minimal without having an error at startup.
>
> Do you have any idea to reduce the size of the directory ?

What schema type of replication you use?

--
Saludos,
Gilberto Castillo
ETECSA, La Habana, Cuba

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Albe Laurenz 2016-09-12 14:03:16 Re: My pg_xlog directory is becoming huge !?
Previous Message Mohamed MANSOUR 2016-09-12 12:58:15 Se désabonner