Thank you very much @Adrian Klaver <[email protected]> . On Mon, Feb 19, 2024 at 2:45 PM Adrian Klaver <[email protected]> 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. > > It is not really linked to the upgrade per say. > > I would say it is. > > From: > > https://www.postgresql.org/docs/current/storage-file-layout.html > > pg_xact Subdirectory containing transaction commit status data > > I'm guessing what ever process you used to upgrade did not transfer all > the files. Or you have some ongoing process that is removing the files > prematurely. > > > > > However, This is occurring in clusters that I recently upgraded to 14. > > Which contradicts, "It is not really linked to the upgrade per say.". > > > > > > > > > > > On Mon, Feb 19, 2024 at 12:17 PM Adrian Klaver > > <[email protected] <mailto:[email protected]>> wrote: > > > > 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 with your upgrading > > procedures. By now you should know that the above does not qualify as > > close to being a sufficient problem report. Respond with a complete > > explanation of your setup and the commands run that got you into this > > situation. > > > > > > > > > > Kind regards > > > Johnathan T > > > > -- > > Adrian Klaver > > [email protected] <mailto:[email protected]> > > > > -- > Adrian Klaver > [email protected] > >
