Hi Adrian,
ah ok, so i wasn't the only one ;-) I did a couple of postgres
upgrades with pg_upgrade and installing the new posgres version in
parallel, that felt "normal" for me, so that's why i got confused. Thx
for the clarification! :-)
Hubert
Am Do., 20. Nov. 2025 um 19:35 Uhr schrieb Adrian
On 11/20/25 04:37, Hu Bert wrote:
Hi Rob,
yes, this directory exists with all the files, but the rest doesn't -
so one has to create the other directories and the cluster manually?
"Long time ago" this happened when installing the packages - must've
changed at some point :-)
https://salsa.debi
Hi Álvaro,
interesting - about one and a half year ago i upgraded postgresql from
14 to 16 - installed the v16 packages, and both versions and two
clusters were running.
upgrade:
/usr/lib/postgresql/16/bin/pg_upgrade --link --old-options "-c
config_file=/etc/postgresql/14/main/postgresql.conf" --
Hi Rob,
yes, this directory exists with all the files, but the rest doesn't -
so one has to create the other directories and the cluster manually?
"Long time ago" this happened when installing the packages - must've
changed at some point :-)
Thx,
Hubert
Am Do., 20. Nov. 2025 um 13:26 Uhr schrieb
On 2025-Nov-20, Hu Bert wrote:
> Hi there,
> i have a debian bookworm with postgresql-16 installed, from postgresql
> repository. I wanted to install postgresql-17 and then do a an inplace
> upgrade via pg_upgrade.
>
> Install: apt install postgresql-17 postgresql-17-postgis-3
> postgresql-17-pos
On Thu, 2025-11-20 at 12:35 +0100, Hu Bert wrote:
> Hi there,
> i have a debian bookworm with postgresql-16 installed, from
> postgresql
> repository. I wanted to install postgresql-17 and then do a an
> inplace
> upgrade via pg_upgrade.
>
> Install: apt install postgresql-17 postgresql-17-postgis
Hi there,
i have a debian bookworm with postgresql-16 installed, from postgresql
repository. I wanted to install postgresql-17 and then do a an inplace
upgrade via pg_upgrade.
Install: apt install postgresql-17 postgresql-17-postgis-3
postgresql-17-postgis-3-scripts postgresql-client-17
But after
On Wed, Nov 19, 2025 at 8:04 PM Tom Lane wrote:
> > The same thing happens with
> > update t set i = 2 from (select i from t for update) x where t.i = x.i;
>
> Right, the common advice if you need to make such scenarios work
> is to add FOR UPDATE to the non-target relations. But here, that
> j
