On 20/2/20 15:47, Tom Lane wrote: > > Unfortunately, not having an up-to-date copy of the xlog info is > practically fatal to your hopes of getting back consistent data. > [...] > Ok, so if the only way to restore the data is getting the content in pg_xlog directory I'm looking for it. I went to my restored pg_xlog directory and I found that it has an empty directory called arhive_status and 7 binary files with names: 00000001000000000000000A 00000001000000000000000B 00000001000000000000000C 00000001000000000000000D 00000001000000000000000E 00000001000000000000000F 000000010000000000000010 pg_filedump recognize them as a PostgreSQL files but doesn't show anything, I'm going to try with pg_xlogdump. Is my first time for me trying to use this program, so sintax is not familiar to me, so, anyway I saw that those files have each exactly the size of 16777216 bytes, so is easier to try to find some files with that size in my lost+found. I got 5 files with that size the names are: #288294 (date 2019-04-01) #288287 (date 2019-05-14) #288293 (date 2019-07-02) #261307 (date 2019-11-27) #270185 (date 2020-01-28) (the inode name where ddrescue found) Ok, they are not 7 but maybe I don't need 7 (I don't know), maybe I have 7 now because I was testing some restores from dump in addition at the first one. Also my old dump is from 2019-04-23, so the first one could be the same? So my next step is going to try to read those files with pg_xlogdump and/or trying to name them with those namefiles (beginning with 00000001000000000000000A by date). In the meantime I'm going to wait from other help from you, because is my first time studying PostgreSQL File Layout. It's fascinating but is huge documentation and I need some orientation to no lose the path to my particular issue. Thank you so much.
