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.
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? |