Thread: Postgres Database Service Interruption

Postgres Database Service Interruption

From
Bablu Kumar Nayak
Date:

Dear PostgreSQL Team,

 

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:

1) checking the status:-

/apps/postgresdb/pgsql/bin/pg_ctl status -D /apps/postgresdb/pgsql/data
pg_ctl: no server running


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.


Thanks 
Bablu Nayak

Re: Postgres Database Service Interruption

From
"David G. Johnston"
Date:
On Tuesday, January 16, 2024, Bablu Kumar Nayak <bablukumarnayak1432@gmail.com> wrote:

Dear PostgreSQL Team,

 

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.


This list is here to discuss patch development for the project.  As an open source project there isn’t really a formal support list, though requests for help are expected to be sent to the -general list, or maybe -admin in this case.

If urgency is indeed a thing in your world you might consider paid support which comes with an expectation of timeliness for help.

You might need to just restore from a backup as the log file says.

David J.