Search Postgresql Archives

Re: Notify client when a table was full

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



I need to be notified when the table is full to launch a script whis dumps this table.

H.S

2018-01-19 16:44 GMT+01:00 David G. Johnston <david.g.johnston@xxxxxxxxx>:
On Fri, Jan 19, 2018 at 8:34 AM, hmidi slim <hmidi.slim2@xxxxxxxxx> wrote:
Hi,
I'm looking for a function in postgresql which notify the client if a table was full or not.So I found the function Notify https://www.postgresql.org/docs/9.0/static/sql-notify.html.
This function send a notification when a new action was done to the table. Is there a way to send a notification only  when the table was full and no future actions (insertion of new rows for examples) will be done. I was connected to an external api and saving the data received from it to a postgres database and I want to be notified when the table was full and no rows will be inserted. Does it realizable or Should I create a trigger and listens for every insertion and notify the client?

​The only way a table becomes "full" is if you run out of disk space - and you should be monitoring that at the O/S level and not at a database table level...

​As for clients - if they are inserting data they will simply get failures when they attempt to do so - for me that seems like sufficient notification for something that should rarely if ever happen.

David J.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux