How to stop postgresql server?

Question

PostgreSQL

there is a postgresql server, there are a lot of connections to it from applications with insert to one table at some point we tell applications that we don’t need to do insert anymore, but this message may be late and someone can still do insert. it is possible to force applications before insert to pass through some global mutex but it is not an option. I am now doing a lock table after which no insert will work and then you need to either pull some script with iptables that closes the port or stop the server (I'm afraid that when you stop the lock will be released before the possible locked insert and the insert will have time to work) or let's say change the port on the fly or some property in the server. how would you do it?


Answer 1

What for to lock the table when it is possible to take away the rights to an insert simply.

Answer 2

not to do directly insert, and through ?
to do inserts into a temporary table for each application and merge into the main one? you can insert as many as you want into your own, but from it the merger checks the time stamp and the
lock table flag hangs connections