One small annoyance

From: Chris Travers <chris(dot)travers(at)gmail(dot)com>
To: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: One small annoyance
Date: 2011-09-28 17:42:58
Message-ID: CAKt_Zfswyk7nz8yOOGNMyHvjHV9k+w_k1eRHhzvN0UcNPW+Lxg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Browse pgsql-general by date

  From Date Subject
Next Message Roger Niederland 2011-09-28 17:51:56 Create Extension search path
Previous Message Chris Travers 2011-09-28 17:19:03 Re: What about improving the rules system we have, was Re: Rules going away