I don't know if this has been changed in 9.1 but in 9.0.5 we were trying to set up streaming replication and kept getting the warning about wal_level=minimal and hence hot standby not being possible. It was the same message as this (found in one of the emails I found when researching the problem): WARNING: WAL was generated with wal_level=minimal, data may be missing HINT: This happens if you temporarily set wal_level=minimal without taking a new base backup. FATAL: hot standby is not possible because wal_level was not set to "hot_standby" on the master server After a bunch of troubleshooting I discovered the problem: primary_conninfo was not set in the recovery.conf. Apparently this error will be thrown not only due to wal levels being inadequate but due to not being told to connect to the primary. I know this won't get changed in a stable branch, but it might save a bunch of people significant stress if this condition had its own error message, if this hasn't been done already for 9.1. Best Wishes, Chris Travers -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
