One small annoyance

Поиск
Список
Период
Сортировка
От Chris Travers
Тема One small annoyance
Дата
Msg-id CAKt_Zfswyk7nz8yOOGNMyHvjHV9k+w_k1eRHhzvN0UcNPW+Lxg@mail.gmail.com
обсуждение исходный текст
Список 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

В списке pgsql-general по дате отправления:

Предыдущее
От: Rob Sargent
Дата:
Сообщение: Re: Rules going away
Следующее
От: Merlin Moncure
Дата:
Сообщение: Re: [Solved] Generic logging system for pre-hstore using plperl triggers