Re: DETAIL: Could not open file "pg_xact/0EEA": No such file or directory

2024-02-19 Thread Johnathan Tiamoh
Thank you very much @Adrian Klaver . On Mon, Feb 19, 2024 at 2:45 PM Adrian Klaver wrote: > On 2/19/24 11:36, Johnathan Tiamoh wrote: > > Reply to list also. > Cc'ing list. > > > Sorry Adrian, > > > > This is occurring at every checkpoint. This actually has to do with > > Listen/Notify. > > I

Re: DETAIL: Could not open file "pg_xact/0EEA": No such file or directory

2024-02-19 Thread Adrian Klaver
On 2/19/24 11:36, Johnathan Tiamoh wrote: Reply to list also. Cc'ing list. Sorry  Adrian, This is occurring at every checkpoint. This actually has to do with Listen/Notify. It is not really linked to the upgrade per say. I would say it is. From: https://www.postgresql.org/docs/current/s

Re: DETAIL: Could not open file "pg_xact/0EEA": No such file or directory

2024-02-19 Thread Adrian Klaver
On 2/19/24 08:59, Johnathan Tiamoh wrote: Hello, Please, I need help in resolving this issue.  I recently upgraded to postgresql and have experienced the above error with 2 clusters  already. I keep losing data in the pg_exact directory. We have been down this rabbit hole multiple times wi

DETAIL: Could not open file "pg_xact/0EEA": No such file or directory

2024-02-19 Thread Johnathan Tiamoh
Hello, Please, I need help in resolving this issue. I recently upgraded to postgresql and have experienced the above error with 2 clusters already. I keep losing data in the pg_exact directory. Kind regards Johnathan T