We would like to setup a hot standby server with a forced delay. Is it possible to setup a hot standby based ONLY on WAL shipping and NOT use streaming replication?
Whether a slave is a hot standby is not determined by whether you're using streaming replication or WAL replay. It is determined by setting the parameter "hot_standby" on the slave and ensuring the master has a minimum "wal_level" of "hot_standby" as well. So both streaming and wal replay slaves can be hot standbys.
-- Keith Fiske Database Administrator OmniTI Computer Consulting, Inc. http://www.keithf4.com