On 10/8/25 12:39, David Barsky wrote: > Hiya folks, > > I'm a bit of a newcomer when it comes to PostgreSQL, so I apologize if > this is > the wrong mailing list. Anyways, my two questions: > > 1. Is there any interest in adding a command line option to the > `postgres` CLI > that shuts down the PostgreSQL instance once (and optionally cleans > up the > data directory) once all connections have disconnected?
" stop mode shuts down the server that is running in the specified data directory. Three different shutdown methods can be selected with the -m option. “Smart” mode disallows new connections, then waits for all existing clients to disconnect. If the server is in hot standby, recovery and streaming replication will be terminated once all clients have disconnected. “Fast” mode (the default) does not wait for clients to disconnect. All active transactions are rolled back and clients are forcibly disconnected, then the server is shut down. “Immediate” mode will abort all server processes immediately, without a clean shutdown. This choice will lead to a crash-recovery cycle during the next server start. "
I think OP is looking for AUTO_CLOSE, like SQL Server (and Rdb/VMS before it). Its only real utility is OP's use-case: a Windows desktop running local testing.
We in the shell scripting daemon world don't think like that.
