Bug#930728: pg_cltlcluster leaks logfile descriptor into PostgreSQL backends

2019-07-02 Thread Christoph Berg
Re: Andrey Borodin 2019-06-26 > Maybe we can somehow get rid of 1 and 2 attached to logfile (that will be > logrotated and deleted)? > Can we redirect output to some temporary file and after pg_ctl append this > file to logfile? > > I simply want to be able to delete this file via logrotate...

Bug#930728: pg_cltlcluster leaks logfile descriptor into PostgreSQL backends

2019-06-26 Thread Andrey Borodin
Hi! > 26 июня 2019 г., в 19:22, Christoph Berg написал(а): > > Re: Andrey Borodin 2019-06-19 > <4178a7b3-b742-49d7-afa9-fcb3439a0...@yandex-team.ru> >> On my observation - yes, descriptor 4 is no longer in lsof. > > Ah, I had not noticed the "4" before. Only 1 and 2 are expected. > We can simp

Bug#930728: pg_cltlcluster leaks logfile descriptor into PostgreSQL backends

2019-06-26 Thread Christoph Berg
Re: Andrey Borodin 2019-06-19 <4178a7b3-b742-49d7-afa9-fcb3439a0...@yandex-team.ru> > On my observation - yes, descriptor 4 is no longer in lsof. Ah, I had not noticed the "4" before. Only 1 and 2 are expected. We can simply close() that one after dup2()'ing it to stdout/stderr. Thanks for spott

Bug#930728: pg_cltlcluster leaks logfile descriptor into PostgreSQL backends

2019-06-20 Thread Andrey Borodin
> 19 июня 2019 г., в 21:05, Andrey Borodin написал(а): > > But I've checked only on Yandex.Cloud clusters. I think I'll do repro on > fresh Ubuntu... So, I've tried the fix on Ubuntu 18. There are much more leaked descriptors in this case and fix helps only partially postgres@x4m-pg-test:/h

Bug#930728: pg_cltlcluster leaks logfile descriptor into PostgreSQL backends

2019-06-19 Thread Andrey Borodin
> 19 июня 2019 г., в 20:57, Christoph Berg написал(а): > > Control: tags -1 moreinfo > > Re: Andrey Borodin 2019-06-19 > <3fd6aec7-55c8-4129-a46c-0bb3e4296...@yandex-team.ru> >> Package: postgresql-common >> Version: 199 >> >> When I execute >> service postgresql start >> I observe that logf

Bug#930728: pg_cltlcluster leaks logfile descriptor into PostgreSQL backends

2019-06-19 Thread Christoph Berg
Control: tags -1 moreinfo Re: Andrey Borodin 2019-06-19 <3fd6aec7-55c8-4129-a46c-0bb3e4296...@yandex-team.ru> > Package: postgresql-common > Version: 199 > > When I execute > service postgresql start > I observe that logfile descriptor will leak into postmaster and every > backend. This is not

Bug#930728: pg_cltlcluster leaks logfile descriptor into PostgreSQL backends

2019-06-19 Thread Andrey Borodin
Package: postgresql-common Version: 199 When I execute service postgresql start I observe that logfile descriptor will leak into postmaster and every backend. This is not fd opened by PG's syslogger. root@rc1b-tl7je3ulcm4z9v3c ~ # lsof | grep 'postgresql-10-data.log' | grep postgres | grep '/va