Gilles Darold
Gilles Darold
@okbob I have run a script to check the `to_date(..., 'J')` day bye day since now until the date returned by Oracle and PostgreSQL differs. The result: ``` Oracle :...
I forgot to say that I that tested against a 11g and 21c with the failing date.
I agree, I will fix that in that way.
What do you think the default value for the GUC should be? I think it should be enabled by default.
ok, I will do that today
@prensgold when you plan to run pgcluu_collectd permanently and especially on PostgreSQL cluster with high activity you must use the incremental mode using the `--rotate-daily` or better with `--rotate-hourly` When...
Yes: `ExecStart=/usr/local/bin/pgcluu_collectd --daemonize --rotate-daily --pid-file $PIDFILE $STATDIR` Use `--rotate-hourly` instead, I will change the default.
Hi @prensgold yes it is fully working. Can you please run manually the following command and post the output. ``` mkdir /tmp/pgcluudata/ /usr/bin/pgcluu_collectd -i 10 --rotate-houlry --pid-file /tmp/pgluu.pid /tmp/pgcluudata/ ```...
When you start pgcluu_collectd using the service file, what does `ps auwx | grep pgcluu` reports? Maybe the --rotate-hourly option is lost for some reason?
Commit 881aa8c might solve this issue. Actually I think that the problem was that main ora2pg process was ending without waiting for last forked processes end.