On 2/27/23 09:10, Adrian Klaver wrote: > On 2/27/23 09:05, Dávid Suchan wrote: > > Please use Reply All > Ccing list > >> My bad, >> \l+ lists databases and their respective sizes- I used that and also >> pg_size_pretty(), the result size was the same - before it was 20gb >> for the biggest db, after it was 700mb. >> I counted rows before the upgrade in one of the biggest and most >> important table that I was watching and comparing - before there were >> hundreds of thousands or millions of rows(not sure about the exact >> number, just a lot), after the upgrade only like 15, but the first 15 >> rows matched after the upgrade when I checked with select of that table.
Hmm, I can't see how you got that state without there being some sort of error messages.
Just to be clear:
1) The 9.6 and 14 instances where installed from the same source?
2) Are you using tablespaces other then the default?
Scan the Postgres log for the 14 instance at /var/log/postgresql for error messages.