Activity for Tomoaki Sato

  • Tomoaki Sato 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...

  • Tomoaki Sato Tomoaki Sato modified a comment on discussion General Discussion

    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...

  • Tomoaki Sato Tomoaki Sato posted 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...

1