Server unable to UP after restore - Mailing list pgsql-general

From Ram Pratap Maurya
Subject Server unable to UP after restore
Date
Msg-id KL1PR0601MB44337E6BE959E78CEB3D1D0BF03FA@KL1PR0601MB4433.apcprd06.prod.outlook.com
Whole thread Raw
In response to RE: Huge archive log generate in Postgresql-13  (Ram Pratap Maurya <ram.maurya@lavainternational.in>)
List pgsql-general

Hi Team,

 

I am facing error during restore of PG_BASEBACKUP , server is not going UP after restoring .

We follow below process .

 

  1. First we take backup by command : pg_basebackup -h127.0.01 -U postgres -D /mnt/backup
  2. Maintain  restore_command = 'cp /var/lib/pgsql/13/data/pg_log_archive/%f %p' in postgresql.conf file .
  3. Create file recovery.signal file in data directory.

 

But when we starting server showing error below error , can you please suggest .

 

[root@NHQ-MYLAVA-DB01 data]# systemctl status postgresql-13

● postgresql-13.service - PostgreSQL 13 database server

   Loaded: loaded (/usr/lib/systemd/system/postgresql-13.service; enabled; vendor preset: disabled)

   Active: failed (Result: exit-code) since Fri 2023-07-21 09:00:15 IST; 17s ago

     Docs: https://www.postgresql.org/docs/13/static/

  Process: 8407 ExecStart=/usr/pgsql-13/bin/postmaster -D ${PGDATA} (code=exited, status=1/FAILURE)

  Process: 8401 ExecStartPre=/usr/pgsql-13/bin/postgresql-13-check-db-dir ${PGDATA} (code=exited, status=0/SUCCESS)

Main PID: 8407 (code=exited, status=1/FAILURE)

 

Jul 21 09:00:15 NHQ-MYLAVA-DB01 systemd[1]: Starting PostgreSQL 13 database server...

Jul 21 09:00:15 NHQ-MYLAVA-DB01 systemd[1]: postgresql-13.service: Main process exited, code=exited, status=1/FAILURE

Jul 21 09:00:15 NHQ-MYLAVA-DB01 systemd[1]: postgresql-13.service: Failed with result 'exit-code'.

Jul 21 09:00:15 NHQ-MYLAVA-DB01 systemd[1]: Failed to start PostgreSQL 13 database server.

 

 

 

Regards,

Ram Pratap.

 

pgsql-general by date:

Previous
From: gzh
Date:
Subject: Re:How to improve the performance of my SQL query?
Next
From: Les
Date:
Subject: invalid value for parameter "default_text_search_config": "public.pg"