Safest pgupgrade jump distance

Hi, I was wondering what is the safest pg_upgrade version upgrade distance going from 9.6 version. Do I need to go version by version or I can go from 9.6 to 15? We have a very huge database(TBs) with one replication server, so we will first run the pgupgrade on the main server and then rsync to a

Re: pg_upgrade Only the install user can be defined in the new cluster

I installed both postgres versions on ubuntu machine with 'apt-get install postgres', which installed both client and server packages. Is that where I made a mistake? Od: David G. Johnston Odoslané: pondelok 20. marca 2023 14:57 Komu: Dávid Suchan

Re: pg_upgrade Only the install user can be defined in the new cluster

rolname --- anon api heartbeat postgres only the default users.. Od: Tom Lane Odoslané: štvrtok 16. marca 2023 19:24 Komu: Dávid Suchan Kópia: Daniel Gustafsson ; pgsql-gene...@postgresql.org Predmet: Re: pg_upgrade Only the install user can be

Re: pg_upgrade Only the install user can be defined in the new cluster

everywhere. The ' SELECT COUNT(*) FROM pg_catalog.pg_roles WHERE rolname !~ '^pg_'; ' prints count 4 and ' SELECT rolname FROM pg_roles WHERE oid = 10; ' prints rolname postgres. Od: Daniel Gustafsson Odoslané: štvrtok 16. marca 202

Re: pg_upgrade Only the install user can be defined in the new cluster

It prints out: count --- 1 (1 row) Od: Daniel Gustafsson Odoslané: streda 15. marca 2023 13:27 Komu: Dávid Suchan Kópia: pgsql-gene...@postgresql.org Predmet: Re: pg_upgrade Only the install user can be defined in the new cluster > On 15 Mar 2023,

Re: pg_upgrade Only the install user can be defined in the new cluster

Can i create a brand new cluster and check it that way? Since I had to stop / shut down the 14 cluster in order to proceed with pg_upgrade and I dont know how can i connect to it now ... Od: Dávid Suchan Odoslané: streda 15. marca 2023 14:47 Komu: Daniel

pg_upgrade Only the install user can be defined in the new cluster

Hello, Im trying to upgrage the db version to a newer one with the command: '/usr/lib/postgresql/14/bin/pg_upgrade --old-bindir /usr/lib/postgresql/9.6/bin --new-bindir /usr/lib/postgresql/14/bin --old-datadir /etc/postgresql/9.6/main --new-datadir /var/lib/postgresql/14/data -U postgres' (logged

Re: pg_upgradecluster transfering only a portion of the data

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 napísal(a): > On 2/27/23 09:10, Adrian Klaver wrote: > > On 2/27/23 09:05

Re: pg_upgradecluster transfering only a portion of the data

I used "pg_upgradecluster 9.6 main", all commands are in my first message: I freshly installed pg 14 -> ran pg_dropcluster 14 main --stop -> and then upgraded using pg_upgradecluster 9.6 main. po 27. 2. 2023 o 18:40 Laurenz Albe napísal(a): > On Mon, 2023-02-27 at 18:18

Re: pg_upgradecluster transfering only a portion of the data

I did not use the -k --link argument while upgrading as that I presume does not copy the data Dňa po 27. 2. 2023, 18:10 Adrian Klaver napísal(a): > On 2/27/23 09:05, Dávid Suchan wrote: > > Please use Reply All > Ccing list > > > My bad, > > \l+ lists databases an

pg_upgradecluster transfering only a portion of the data

Hello, I tried upgrading pg db from version 9.6 to 14 by using pg_upgradecluster command. I freshly installed pg 14 -> ran pg_dropcluster 14 main --stop -> and then upgraded using pg_upgradecluster 9.6 main. After a successful prompt finished, I checked the database and the size went from originall