[sNip]
Do a shutdown -h on a live database machine with pg. It will gracefully shut itself down.
Is that true for all OS flavors and is it dependent upon the DBA having set up proper shutdown scripts?
[sNip]
When I tested this on PostgreSQL on Novell NetWare 6 it shut down gracefully. I don't see why this would be different on other Operating Systems since the code base is essentially the same (isn't it?).
No it's not. Don't confuse the PostgreSQL code base with the operating system it's running on.
On Mac OS X (desktop version, at least) there are no shutdown scripts. All running applications are simply sent the "TERM" signal, then later sent the "KILL" signal. Luckily enough, PostgreSQL seems to respond to TERM by shutting down gracefully.
Totally off topic, but this lack of shutdown scripts, along with a lack of proper package management are the two most painful faults in Mac OS X.
Alex
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
