From: | hmidi slim <hmidi(dot)slim2(at)gmail(dot)com> |
---|---|
To: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Notify client when a table was full |
Date: | 2018-01-19 15:47:15 |
Message-ID: | CAMsqVxtixNwz95Q6aVir9cW0o0MfJ8Civzeg+cihKEZgOOWWRA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(dot)g(dot)johnston(at)gmail(dot)com>:
> On Fri, Jan 19, 2018 at 8:34 AM, hmidi slim <hmidi(dot)slim2(at)gmail(dot)com> 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.
>
From | Date | Subject | |
---|---|---|---|
Next Message | David G. Johnston | 2018-01-19 15:50:58 | Re: Notify client when a table was full |
Previous Message | kpi6288 | 2018-01-19 15:46:21 | Use left hand column for null values |