Re: Hot Standby Not So Hot Anymore

From: "Kevin Grittner" <kgrittn(at)mail(dot)com>
To: "Darren Duncan" <darren(at)darrenduncan(dot)net>,"General PostgreSQL List" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Hot Standby Not So Hot Anymore
Date: 2012-11-06 13:45:09
Message-ID: 20121106134509.61230@gmx.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Darren Duncan wrote:
> Ian Harding wrote:

>> It says everything is happy as normal...
>>
>> 2012-11-05 16:22:41.200 PST - :LOG: invalid record length at BA6/6DCBA48
>
> What does this log line mean? Is that "happy as normal"?

Note that the message level is LOG, not WARNING or ERROR or anything
more severe. It found the end of the valid WAL stream in WAL files it
was provided, and it's telling you how it decided it was at the end.

One thing I don't think you've really described is how you took your
base backup. You did follow all the instructions, like using
pg_start_backup() and pg_stop_backup(), excluding the pg_xlog
directory contents, and excluding the postmaster.pid file, right? If
you missed some details there you might see odd behavior.

-Kevin

Responses

Browse pgsql-general by date

  From Date Subject
Next Message hari.fuchs 2012-11-06 13:48:46 Re: Exclusion constraints with time expressions
Previous Message Bryan Montgomery 2012-11-06 13:04:06 Tuning / performance questions