[megous]

This all depends on what the program does. If you have some app specific service that waits for postgresql NOTIFY messages, and does something in response, it doesn't matter that working dir is not /. You just stop the service and perform maintenance.

If it's something like sshd, it better not prevent any filesystems from umounting unless necessary.