From: | Ram Pratap Maurya <ram(dot)maurya(at)lavainternational(dot)in> |
---|---|
To: | "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org> |
Subject: | Server unable to UP after restore |
Date: | 2023-07-21 04:06:45 |
Message-ID: | KL1PR0601MB44337E6BE959E78CEB3D1D0BF03FA@KL1PR0601MB4433.apcprd06.prod.outlook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin 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(at)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Jef Mortelle | 2023-07-21 07:22:39 | Re: Upgrade from PG12 to PG |
Previous Message | Scott Ribe | 2023-07-20 18:34:18 | Re: Upgrade from PG12 to PG |
From | Date | Subject | |
---|---|---|---|
Next Message | Les | 2023-07-21 05:25:20 | invalid value for parameter "default_text_search_config": "public.pg" |
Previous Message | gzh | 2023-07-21 02:02:51 | Re:How to improve the performance of my SQL query? |