pg_rewind Issue: Trying to read Incorrect WAL file for checkpoint record

olving this issue? I cannot find the WAL file that pg_rewind is trying to open and read in the data/pg_wal directory or my WAL archive directory. -- Thanks Azeem Subhani

Re: PgbackRest and EDB Query

erver running locally and accepting connections on that > socket? > ERROR: [056]: unable to find primary cluster - cannot proceed > HINT: are all available clusters in recovery? > 2024-07-17 17:42:13.936 P00 INFO: stanza-create command end: aborted > with exception [056] > [root@uaterssdrservice01 ~]# > > > > > -- Thanks Azeem Subhani

Re: PgbackRest and EDB Query

aterssdrservice01 ~]# sudo -u postgres pgbackrest --stanza=OD_DM2 >>> --log-level-console=info stanza-create >>> 2024-07-17 17:42:13.935 P00 INFO: stanza-create command begin 2.52.1: >>> --exec-id=1301876-7e055256 --log-level-console=info --log-level-file=debug >>> --pg1-path=/var/lib/pgsql/16/data --repo1-host=10.x.y.7 >>> --repo1-host-user=postgres --stanza=OD_DM2 >>> WARN: unable to check pg1: [DbConnectError] unable to connect to >>> 'dbname='postgres' port=5432': connection to server on socket >>> "/tmp/.s.PGSQL.5432" failed: No such file or directory >>> Is the server running locally and accepting connections on that >>> socket? >>> ERROR: [056]: unable to find primary cluster - cannot proceed >>>HINT: are all available clusters in recovery? >>> 2024-07-17 17:42:13.936 P00 INFO: stanza-create command end: aborted >>> with exception [056] >>> [root@uaterssdrservice01 ~]# >>> >>> >>> >>> >>> -- Thanks Azeem Subhani

Re: PgbackRest and EDB Query

t; EDB ] ? >>>> >>>> >>>> Any hints much appreciated. >>>> >>>> Thank you, >>>> Krishane >>>> >>>> >>>> ERROR: >>>> root@uaterssdrservice01 ~]# sudo -u postgres pgbackrest >>>> --stanza=OD_DM2 --log-level-console=info stanza-create >>>> 2024-07-17 17:42:13.935 P00 INFO: stanza-create command begin 2.52.1: >>>> --exec-id=1301876-7e055256 --log-level-console=info --log-level-file=debug >>>> --pg1-path=/var/lib/pgsql/16/data --repo1-host=10.x.y.7 >>>> --repo1-host-user=postgres --stanza=OD_DM2 >>>> WARN: unable to check pg1: [DbConnectError] unable to connect to >>>> 'dbname='postgres' port=5432': connection to server on socket >>>> "/tmp/.s.PGSQL.5432" failed: No such file or directory >>>> Is the server running locally and accepting connections on that >>>> socket? >>>> ERROR: [056]: unable to find primary cluster - cannot proceed >>>>HINT: are all available clusters in recovery? >>>> 2024-07-17 17:42:13.936 P00 INFO: stanza-create command end: aborted >>>> with exception [056] >>>> [root@uaterssdrservice01 ~]# >>>> >>>> >>>> >>>> >>>> -- Thanks Azeem Subhani