hlinnaka / pg_quota Goto Github PK

When make pg_quota on postgresql(install from source code on centos7)

Tried several release branches of postgresql, from REL9_4_STABLE to REL_11_STABLE.

pg_quota compile can only be sucessfully done on REL_11_STABLE or later.

Hello,
I had conpile and install pg_quota in my Postgresql 12.4 database, all things seem to be OK and background worker also lanch and running.
But when I doing test ,the "used" cloumn does not update and remain 0 ,the quota enforcement also not be effect.
My machine is Centsos7.6 with PostgreSQL 12.4 installed.

Following are related information with this problem:

DB Log:
2022-09-02 22:54:14.179 CST [32321] LOG: database system is ready to accept connections
2022-09-02 22:54:14.186 CST [32329] LOG: pg_quota worker for "qzit3" initialized

postgresql.conf
shared_preload_libraries = '$libdir/pg_quota'
pg_quota.databases='qzit3'
pg_quota.refresh_naptime='10 s'
pg_quota.restart_interval='60 s'

Space info:
qzit3=# select pg_size_pretty(pg_total_relation_size('qzibs.test'));
pg_size_pretty

36 MB
(1 row)

qzit3=# SELECT rolname,
qzit3-# pg_size_pretty(space_used) as used,
qzit3-# pg_size_pretty(quota) as quota
qzit3-# FROM quota.status
qzit3-# WHERE rolname::text like 'qzibs%';
rolname | used | quota
---------+---------+-------
qzibs | 0 bytes | 10 kB
(1 row)

What is the matter with this,waiting for your reply.

Thanks in advance,
zhou