1) i downloaded both versions using apt-get install postgres 2) i will check the tablespace and log files tomorrow, i don't have access to the workstation right now.
po 27. 2. 2023 o 18:44 Adrian Klaver <adrian.kla...@aklaver.com> napísal(a): > 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. > > > > -- > Adrian Klaver > adrian.kla...@aklaver.com > >
