pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Bablu Kumar Nayak <bablukumarnayak1432@gmail.com>
To: pgsql-general@postgresql.org
Subject: Re: Postgres Database Service Interruption
Date: Wed, 17 Jan 2024 09:41:05 +0100
Message-ID: <4d5229dc5f7ae8f49a165b35d5e97eea40e3031c.camel@cybertec.at> (raw)
In-Reply-To: <CAJmy-U==8UcTzLovxuLP-t=EDkGtbtqp6fS1BVcdEJTY0W8U8g@mail.gmail.com>
References: <CAJmy-U==8UcTzLovxuLP-t=EDkGtbtqp6fS1BVcdEJTY0W8U8g@mail.gmail.com>

On Tue, 2024-01-16 at 21:59 +0530, Bablu Kumar Nayak wrote:
> I am writing to inform you that our PostgreSQL database service is currently down.
> We are experiencing an unexpected interruption, and we are seeking your expertise
> to help us resolve this issue promptly.
> We would greatly appreciate your immediate attention to this matter. If there are
> specific steps we should follow or additional information you require, please let
> us know as soon as possible.
> Your assistance in resolving this issue is crucial, and we are confident in your
> expertise to help us bring the PostgreSQL database back online.
>  
> Here are some details about the current situation:
> 
> 2) Starting the server
> /apps/postgresdb/pgsql/bin/pg_ctl start -D /apps/postgresdb/pgsql/data
> waiting for server to start....2024-01-15 11:15:08.010 GMT [] LOG:  listening on IPv4 address "0.0.0.0", port 
> LOG:  listening on IPv6 address "::", port 
> LOG:  listening on Unix socket "/tmp/.s.PGSQL."
> LOG:  database system was interrupted while in recovery at 2024-01-15 10:51:44 GMT
> HINT:  This probably means that some data is corrupted and you will have to use the last backup for recovery.
> FATAL:  the database system is starting up
> LOG:  database system was not properly shut down; automatic recovery in progress
> LOG:  redo starts at 0/
> FATAL:  could not access status of transaction
> DETAIL:  Could not read from file "pg_xact/0001" at offset 204800: Success.
> CONTEXT:  WAL redo at 0/7A845458 for Transaction/COMMIT: 2023-12-30 23:26:16.017062+00
> LOG:  startup process (PID 2731458) exited with exit code 1
> LOG:  aborting startup due to startup process failure
> LOG:  database system is shut down
>  stopped waiting
> pg_ctl: could not start server
> Examine the log output.

You are suffering from data corruption.  What did you do to get into this state?

The canonical solution is to restore your backup.

If you have no backup, and the data are important for you (which is a contradiction
in terms), you should hire a consultant with extensive PostgreSQL knowledge in
the hope that he or she can salvage some of your data.

Yours,
Laurenz Albe





view thread (4+ messages)

Message-ID: <4d5229dc5f7ae8f49a165b35d5e97eea40e3031c.camel@cybertec.at>
Permalink:  ../4d5229dc5f7ae8f49a165b35d5e97eea40e3031c.camel@cybertec.at/
Also on:    postgresql.org/message-id/4d5229dc5f7ae8f49a165b35d5e97eea40e3031c.camel@cybertec.at

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-general@postgresql.org
  Cc: laurenz.albe@cybertec.at, bablukumarnayak1432@gmail.com
  Subject: Re: Postgres Database Service Interruption
  In-Reply-To: <4d5229dc5f7ae8f49a165b35d5e97eea40e3031c.camel@cybertec.at>
  References: <CAJmy-U==8UcTzLovxuLP-t=EDkGtbtqp6fS1BVcdEJTY0W8U8g@mail.gmail.com> <4d5229dc5f7ae8f49a165b35d5e97eea40e3031c.camel@cybertec.at>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox