#postgresql16 — Public Fediverse posts

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

@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

@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

@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

but since '*' < 'G' == true
I would assume '**K' < '*G'
Where am I mistaken?
#postgres #postgresql #postgresql16

'**F' < '*G' evaluates to true as does '*G' < '**K'
so it holds '**F' < '*G' < '**K'
#postgres #postgresql #postgresql16

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

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

#OpenSource #Database #Databases #Conference #PostgreSQL16

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.

😲 #PostgreSQL16 will have a pg_stat_io to monitor ios 🤓

Thanks @melanieplageman 👍

The latest version of PostgreSQL is available for testing https://www.admin-magazine.com/News/PostgreSQL-16-Beta-Now-Available #PostgreSQL16 #beta #security #testing #monitoring #OpenSource #database