Carl von LesquereuxNov 4

Aparentemente se les fue la olla a los de #Fedora con la actualización a #Fedora43 si se tiene instalado #PostgreSQL.

#Fedora42 trae #PostgreSQL_16, mientras que la v43 trae #PostgreSQL_18. Entonces, al actualizar el SO, todo peta, porque no puedes usar `postgresql-setup --upgrade`, ya que tu cluster es v16 y el upgrade sólo sirve de v17 a v18.

Más info y solución, aquí: https://discussion.fedoraproject.org/t/cant-upgrade-postgres-after-f42-f43/171071/4

#Linux #Databases #PostgreSQL16 #PostgreSQL18 #PostgreSQL17

Can't upgrade postgres after f42->f43

Unfortunately there are a few issues. Fedora does not allow to install multiple versions of Postgres, which makes this a bit more complicated. Luckily the postgres-upgrade packages include the “old” (n-1) binaries. There are a few options available how to do the upgrade. I am trying to find a nice solution that is the least error prone. e.g. if you are not careful you might end up with things like old cluster does not use data checksums but the new one does. An upgrade always replaces your c...

Fedora Discussion
Show threadkltSep 13, 2024
@petereisentraut
Thanks for the link but the details are hard to understand. But the important sentence:
ignore these characters for sorting
I guess '*' is simply ignored,
also by unix-sort:
(echo "**F";echo "*G";echo "**K" )|sort
**F *G **K
#postgres #postgresql #postgresql16
kltSep 13, 2024
@truls46
with collate "C" the order is
**F **K *G 😀
With Unix-sort I get also the unusual order:
( echo "**F"; echo "*G"; echo "**K" ) | sort
**F *G **K
It seems that '*' is simply ignored, i.e. ordering happens on ("F", "G","K")
#postgres #postgresql #postgresql16
kltSep 13, 2024
@truls46
I use #nixos stable 24.05; I think glibc 2.39-52.
But that should not play a role!
Since '*' < 'G' ,
'**K' < '*G' should be true.
Aren't strings ordered by lexicographical char order?
#postgres #postgresql #postgresql16
Show threadkltSep 13, 2024
but since '*' < 'G' == true
I would assume '**K' < '*G'
Where am I mistaken?
#postgres #postgresql #postgresql16
Show threadkltSep 13, 2024
'**F' < '*G' evaluates to true as does '*G' < '**K'
so it holds '**F' < '*G' < '**K'
#postgres #postgresql #postgresql16
kltSep 13, 2024
Strange sorting of #postgres 16.4
select * from (values ('**K'),('*G'),('**F')) as t (c) order by c
give the following order: **F *G **K
but '*G' < '**K' evaluates to true.
#postgresql #postgresql16
Jimmy Angelakos Oct 3, 2023

Magnus Hagander ( @magnushagander ) on stage at #PGConfNYC talking about the new #Postgres release, #PostgreSQL 16!

#OpenSource #Database #Databases #Conference #PostgreSQL16

Brar PieningSep 14, 2023
Now that #PostgreSQL 16 has been released, Roji has also released the #Npgsql hotfixes 5.0.17, 6.0.10 and 7.0.6. They contain quite a few bugfixes and one replication-related compatibility fix for #PostgreSQL16, so make sure, you upgrade your #dotNET projects to the latest compatible version.
Lutin DiscretJul 20, 2023

😲 #PostgreSQL16 will have a pg_stat_io to monitor ios 🤓

Thanks @melanieplageman 👍