Re: Send a command to postgres and close the program

On 8/09/2010 8:01 PM, Thiago Godoi wrote:

Hello guys,

I'm doing a program that will send a command to the database but the
execution of this command spends a lot of time and client probably will
close the java program .

The problem is that I need the command continue running after the client
close the program.

If they close the program, presumably they might also do things like reboot their machine, so you can't rely on the client at all.

I'd want something running server-side to handle this. LISTEN / NOTIFY can be a good way of waking the server-side helper and telling it that it has work to do.

It might help if you explained in more detail what this long-running work is. Is it critical to data integrity or security? Does it produce a lot of data that must be sent to the server, or is it processing that's done on existing data the server already has? etc.


--
Craig Ringer

Tech-related writing at http://soapyfrogs.blogspot.com/