Message-ID: <646373198c53bc02e47ece9836494acf0b0caa04.camel@cybertec.at>
Subject: Re: PostgreSQL Service Unable to Start After Archive Log delete
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: loganathan P <plogandba@gmail.com>, Justin <zzzzz.graf@gmail.com>,
	pgsql-general@lists.postgresql.org
Cc: Oli Sennhauser <oli.sennhauser@fromdual.com>
Date: Thu, 10 Sep 2026 23:21:48 +0200
In-Reply-To: 
 <CAFX4Q9+KB=A1qVunAryajzVuZQtU0fzjqvOU+9cOg48Ff63W6A@mail.gmail.com>
References: 
	<CAFX4Q9+z686bXOLuxd1pQ7nLCPVFAhLJwVy7qDbtQA5y8i+D8g@mail.gmail.com>
	 <db04fd73-f128-4a68-a853-d40e48e9faba@fromdual.com>
	 <1789057250740.237174659@boxbe>
	 <CAFX4Q9+KB=A1qVunAryajzVuZQtU0fzjqvOU+9cOg48Ff63W6A@mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
User-Agent: Evolution 3.60.2 (3.60.2-1.fc44) 
MIME-Version: 1.0
Archived-At: 
 <https://www.postgresql.org/message-id/646373198c53bc02e47ece9836494acf0b0caa04.camel%40cybertec.at>
Precedence: bulk

On Fri, 2026-09-11 at 01:59 +0530, loganathan P wrote:
> As per the provided link, the pg_resetwal command was executed successful=
ly, and the services
> have been started. However, a rollback transaction error is appearing in =
the Tomcat catalina.out logs.

That's because pg_resetwal has the side effect of corrupting your database.
It is *not* a tool to fix database corruption.
It is a tool to get a corrupted server to somehow start so that you can
more easily salvage those data that can be salvaged.

Restore your backup.

Yours,
Laurenz Albe