Activity for pg_statsinfo
-
lucy posted a comment on discussion General Discussion
Hi Regards When I learned to use pg_statsinfo, I typed the following command and got an error: $ pg_statsinfo a b c d ERROR: too many argumetns I noticed a spelling mistake in this error message, "argumetns" shoudle be "arguments". I made a patch (See the attachments)for it, and incidentally fixed another spelling mistake in the same file.
-
Sun Wei posted a comment on discussion General Discussion
Hi While reading the source code, I found an unnecessary plus operator in agent/bin/pgput/pgut.c line 348: tmp = pgut_malloc(strlen(value) + + 1); I think that "+ + 1" should be fixed to "+ 1". Would you fix it? Regards, Sun Wei
-
Takeshi Ideriha posted a comment on discussion General Discussion
Hi While reading the source code, I found that the argument of execl() and execlp() is not specified properly. According to "man execl", the last argument execl() or execlp() should be "(char )NULL". However, "NULL" is specified instead of "(char )NULL" in the source code: - agent/lib/port.c: execl("/bin/sh", "sh", "-c", cmd, NULL) - agent/bin/maintenance.c: execlp("/bin/sh", "sh", "-c", command, NULL) https://man7.org/linux/man-pages/man3/exec.3.html Specifying "NULL" seems harmless on many environments,...
-
Xianwu Ma modified a comment on discussion General Discussion
Hi We have created the patch to pg_statsinfo 13.0 (https://sourceforge.net/projects/pgstatsinfo/files/pg_statsinfo/13.0/) to support PostgreSQL 14. It has been tested under psql (PostgreSQL) 14.0 Please refer to attached the OSS patch for details. Regards, Xianwu Ma Email: xianwu.ma@fujitsu.com URL: https://www.postgresql.fastware.com/
-
Updated attached patch for psql (PostgreSQL) 14 as there are changes of logging format between psql (PostgreSQL) 14Beta3 and psql (PostgreSQL) 14.0
-
Updated attached patch for psql (PostgreSQL) 14 as there are changes of logging format between psql (PostgreSQL) 14Beta3 and psql (PostgreSQL) 14.
-
Hi We have created the patch to pg_statsinfo 13.0 (https://sourceforge.net/projects/pgstatsinfo/files/pg_statsinfo/13.0/) to support PostgreSQL 14. It has been tested under psql (PostgreSQL) 14. Please refer to attached the OSS patch for details. Regards, Xianwu Ma Email: xianwu.ma@fujitsu.com URL: https://www.postgresql.fastware.com/
-
Hi We have created the patch to pg_statsinfo 13.0 (https://sourceforge.net/projects/pgstatsinfo/files/pg_statsinfo/13.0/) to support PostgreSQL 14. It has been tested under psql (PostgreSQL) 14beta3. Please refer to attached the OSS patch for details. Regards, Xianwu Ma Email: xianwu.ma@fujitsu.com URL: https://www.postgresql.fastware.com/
-
Takahiro Kitayama posted a comment on discussion General Discussion
pg_statsinfo 11.x / pg_stats_reporter 11.x on RHEL 8.x pg_statsinfo 12.x has released 12.1 for RHEL 8.x, but pg_statsinfo 11.x is not supported on RHEL 8.x and the source code needs to be modified for successful compilation. The only source code modification is to add the <sys sysmacros.h=""> header file include in libstatsinfo.c.</sys> pg_stats_reporter 11.x seems to work fine on RHEL 8.x. I hope pg_statsinfo 11.x / pg_stats_reporter 11.x for RHEL 8.x will be officially released. Regards, Takahiro...
-
Tomoaki Sato modified a comment on discussion General Discussion
Hi, When I stopped PostgreSQL using systemctl, pg_statsinfo.pid was not removed. You can reproduce it as follows: # yum -y install pg_statsinfo-12.0-1.pg12.rhel7.x86_64.rpm # su - postgres $ /usr/pgsql-12/bin/initdb -E UTF8 --no-locale $ cat >> $PGDATA/postgresql.conf <<EOF shared_preload_libraries = 'pg_statsinfo' log_filename = 'postgresql-%Y-%m-%d_%H%M%S.log' EOF $ exit # systemctl start postgresql-12 # ls /var/lib/pgsql/12/data | grep .pid pg_statsinfo.pid postmaster.pid # systemctl stop postgresql-12...
-
Hi, When I stopped PostgreSQL using systemctl, pg_statsinfo.pid was not removed as follows: # yum -y install pg_statsinfo-12.0-1.pg12.rhel7.x86_64.rpm # su - postgres $ /usr/pgsql-12/bin/initdb -E UTF8 --no-locale $ cat >> $PGDATA/postgresql.conf <<EOF shared_preload_libraries = 'pg_statsinfo' log_filename = 'postgresql-%Y-%m-%d_%H%M%S.log' EOF $ exit # systemctl start postgresql-12 # ls /var/lib/pgsql/12/data | grep .pid pg_statsinfo.pid postmaster.pid # systemctl stop postgresql-12 # ls /var/lib/pgsql/12/data...
-
Hi, When I stopped PostgreSQL using systemctl, pg_statsinfo.pid was not removed. You can reproduce it as follows: # yum -y install pg_statsinfo-12.0-1.pg12.rhel7.x86_64.rpm # su - postgres $ /usr/pgsql-12/bin/initdb -E UTF8 --no-locale $ cat >> $PGDATA/postgresql.conf <<EOF shared_preload_libraries = 'pg_statsinfo' log_filename = 'postgresql-%Y-%m-%d_%H%M%S.log' EOF $ exit # systemctl start postgresql-12 # ls /var/lib/pgsql/12/data | grep .pid pg_statsinfo.pid postmaster.pid # systemctl stop postgresql-12...
-
pg_statsinfo released /pg_statsinfo/News/README_13_0_20210225.txt
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
HiguchiD posted a comment on discussion General Discussion
Hi, I have found that autovacuum statistics cannot be obtained when PostgreSQL messages are output in Japanese. I think this problem occurs not only in Japanese but also in other languages. I found this problem when using PostgreSQL 11 and pg_statsinfo 11. [Investigation] This problem may be caused by that MSG_AUTOVACUUM macro, defined in "libstatsinfo.c", differs from the PostgreSQL messages. MSG_AUTOVACUUM and the PostgreSQL "ja.po" have different message units and different variables such as "%s"....
-
-
-
-
-
-
-
-
-
-
yuji posted a comment on discussion General Discussion
Can pg_statsinfo be compiled for RHEL8? It would be great if you could respond to this as soon as possible.
-
-
-
-
-
-
-
-
Hi, I found some report items like "Total Commits" become negative value after testing of rolling update. [Issue] I got following report. "Total Commits" is negative value. ---------------------------------------- /* Summary */ ---------------------------------------- Database System ID : xxxx Host : xxxx Port : xxxx PostgreSQL Version : 10.3 Snapshot Begin : 2019-11-29 12:24:00 Snapshot End : 2019-11-29 12:26:00 Snapshot Duration : 00:02:00 Total Database Size : 24 MiB Total Commits : -96496 Total...
-
Markus Z. posted a comment on discussion General Discussion
Hi, We are running pg_statsinfo with default settings at the moment. Our 50 postgres databases are producing up to 15GB pg_statsinfo data per day. We are looking to reduce this volumina. Idea is to set "pg_statsinfo.snapshot_interval = 12h". Questions: a) Any other ideas? b) Will this setting still generate 5s session states? Cheers, Markus
-
-
-
-
-
-
-
-
-
Adnan posted a comment on discussion General Discussion
Can pg_statsinfo for postgresql 10 be compiled for RHEL/OEL 6?
-
hi, we have several postgres clusters running on the same host. we added cluster_names and dns aliases to every cluster for better differentiation and handling. we only see physical hostnames + ports in the pg_reporter overview at the moment, e.g. tstm49254:5432 tstm49251:5433 tstm49252:5432 tstm49251:5432 tstm49255:5432 would it be possible to change the physical hostname to it's appropriate dns alias, e.g. pg_clu1:5432 pg_clu5:5433 pg_clu2:5432 pg_clu3:5432 pg_clu4:5432 thanks, markus
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
Riccardo Barison posted a comment on discussion General Discussion
Hi, thanks for your work, pg_statsinfo looks very professional and useful. Have you any plan to port to Windows O.S.? Thanks, Riccardo
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
1 >