Обсуждение: BUG #14340: pg xlog size increasing

Поиск
Список
Период
Сортировка

BUG #14340: pg xlog size increasing

От
kgmeetsonu@gmail.com
Дата:
VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJz
aXRlOgoKQnVnIHJlZmVyZW5jZTogICAgICAxNDM0MApMb2dnZWQgYnk6ICAg
ICAgICAgIHNvbnUgZ3VwdGEKRW1haWwgYWRkcmVzczogICAgICBrZ21lZXRz
b251QGdtYWlsLmNvbQpQb3N0Z3JlU1FMIHZlcnNpb246IDkuNC45Ck9wZXJh
dGluZyBzeXN0ZW06ICAgUmVkIEhhdCA0LjguNS00LCA2NC1iaXQKRGVzY3Jp
cHRpb246ICAgICAgICAKCkhpLA0KDQpJIGNyZWF0ZWQgYSBuZXcgREIsIHdp
dGggYSBtYXN0ZXIgYW5kIDIgc2xhdmUgbm9kZXMgb24gZGlmZmVyZW50IGRh
dGEKY2VudGVycy4NCg0KSSBvYnNlcnZlZCwgcGcgeGxvZyBzaXplIGlzIGlu
Y3JlYXNpbmcgcmFwaWRseSBhbmQgbm93IGl0cyAxODMgR0IsIHdoaWxlCnNp
bXBsZSB1cGRhdGUgaXMgZ29pbmcgb24gb24gYSBzaW5nbGUgdGFibGUuDQoN
Cnhsb2cgc2l6ZSBpcyBub3QgZ2V0dGluZyBkb3duLi4uDQoNCkkgYXNzdW1l
LCBtaXNzaW5nIHNvbWUgY29uZmlnIHNldHRpbmcuDQoNClBsZWFzZSBoZWxw
IG1lLCBpdHMgdXJnZW50Lg0KDQpUaGFua3MgaW4gYWR2YW5jZSEhIQ0KDQpS
ZWdhcmRzLA0KU29udSBHdXB0YS4gCgo=

Re: BUG #14340: pg xlog size increasing

От
Vik Fearing
Дата:
On 09/26/2016 03:53 PM, kgmeetsonu@gmail.com wrote:
> The following bug has been logged on the website:
>
> Bug reference:      14340
> Logged by:          sonu gupta
> Email address:      kgmeetsonu@gmail.com
> PostgreSQL version: 9.4.9
> Operating system:   Red Hat 4.8.5-4, 64-bit
> Description:
>
> Hi,
>
> I created a new DB, with a master and 2 slave nodes on different data
> centers.
>
> I observed, pg xlog size is increasing rapidly and now its 183 GB, while
> simple update is going on on a single table.
>
> xlog size is not getting down...
>
> I assume, missing some config setting.
>
> Please help me, its urgent.
>
> Thanks in advance!!!

This is not a bug, please direct future questions like this to the
pgsql-general list.

Check that your archive_command is functioning correctly, and that you
don't have any inactive replication slots (select * from
pg_replication_slots where not active).  Also check the server logs if
both those things are okay.
--
Vik Fearing                                          +33 6 46 75 15 36
http://2ndQuadrant.fr     PostgreSQL : Expertise, Formation et Support