hlinnaka / pg_quota Goto Github PK
View Code? Open in Web Editor NEWPostgreSQL extension for quotas
License: Other
PostgreSQL extension for quotas
License: Other
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'
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
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.
A declarative, efficient, and flexible JavaScript library for building user interfaces.
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. ๐๐๐
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google โค๏ธ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.