Martijn van Oosterhout <kleptog@svana.org> writes: > I don't think you can acheive the effect you want with a FIFO.
I think Doug had it right: the trick is to have some process holding the FIFO open for write throughout the procedure, so that the reader (psql) doesn't see an EOF. This doesn't necessarily have to be the same process(es) that're actually putting data into the FIFO. Per the read(2) man page: When attempting to read from an empty pipe or FIFO: o If no process has the pipe open for writing, read() will return 0 to indicate end-of-file. o If some process has the pipe open for writing and O_NONBLOCK is set, read() will return -1 and set errnoto EAGAIN. o If some process has the pipe open for writing and O_NONBLOCK is clear, read() will block until some data is written or the pipe is closed by all processes that had the pipe open for writing. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings