Re: help me understand logs

From: Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
To: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
Cc: pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: help me understand logs
Date: 2022-05-11 23:50:33
Message-ID: 08B20C87-32D3-4151-946D-3F3611C0D4A6@elevated-dev.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

> On May 9, 2022, at 8:53 PM, David G. Johnston <david(dot)g(dot)johnston(at)gmail(dot)com> wrote:
>
> I think you've managed to restore a functioning warm standby that found some WAL to process and proceeded to do so.

Yes, that is exactly what I was doing.

> If you want to bring the server backup in non-standby mode you will need to remove the stuff that is making it be a standby. I don't know that stuff off the top of my head and it also has recently changed. The v13 documentation will be more useful than I for those specifics.
>
> I don't know what the warnings are - they read like something that should crash the server...

I'd not noticed those messages before. Reviewing another instance, I did see a few before it started into what I recognize as the "normal" sequence of applying WAL.

My subsequent theory about confusing containers and starting a second PG instance, was itself the result of confusion, and I had not done that after all.

On a second try, it did the same thing, I left it alone, and it eventually came up.

I'd still like to understand what those warnings are, and why I usually see only a handful followed by a lot of messages about WAL having applied, but this instance I see a lot of these, and then the server claims all is good without a log of those messages about WAL being applied.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message yanliang lei 2022-05-13 14:07:24 Re:Re:Re: PostgreSQL14.2 can not start because of huge_page_size is equal to 1048576
Previous Message Nathan Bossart 2022-05-11 15:57:19 Re: Estimating HugePages Requirements?