Re: PgbackRest PointTIme Recovery : server unable to start back

2024-07-25 Thread Muhammad Ikram
I don't think it has anything to do with the pg_hba.conf file. Archive seems missing. I will suggest taking a full backup, as you have mentioned that you are able to take full backup. Regards, Ikram On Fri, Jul 26, 2024 at 11:24 AM KK CHN wrote: > here the log outputs > > When I ran > > $

Re: PgbackRest PointTIme Recovery : server unable to start back

2024-07-25 Thread KK CHN
here the log outputs When I ran $sudo -u enterprisedb pgbackrest --stanza=Demo_Repo --delta --set=20240719-122703F_20240724-094727I --target-timeline=current --type=time "--target=2024-07-24 09:44:01.3255+05:30" --target-action=promote restore The Edb server log out put shows .

Re: PgbackRest PointTIme Recovery : server unable to start back

2024-07-25 Thread Muhammad Ikram
Hi KK CHN Could you check server logs ? Your service trace suggests that it started server and then failure happened ul 26 09:48:49 service01 systemd[1]: Started EDB Postgres Advanced Server 16. Jul 26 09:48:50 service01 systemd[1]: edb-as-16.service: Main process exited, code=exited, status=1/FA

PgbackRest PointTIme Recovery : server unable to start back

2024-07-25 Thread KK CHN
List, Reference: https://pgbackrest.org/user-guide-rhel.html#pitr I am following the PTR on RHEL9 EPAS16. I am able to do a backup(Full, diff and incr) and restore from a full backup and restart of EPAS16 works fine. But when I do an incremental backup after doing the procedures mentio