When I want to download postgresql, I found a problem that makes me unable to install and how can I fix it? In ubuntu 24.04.2 LTS #apt #packagemanagement #updates #postgresql

https://askubuntu.com/q/1553754/612

Database collates are ridiculous. Why would I want to *globally* configure a database's ordering rules? Either I care about presenting locale-appropriate orderings, in which case I need that to be configured PER APPLICATION USER, or I don't care, in which care just use whatever makes the most sense for performance/simplicity (probably ordering by byte value). I don't understand the use case for database-global collate settings. #postgresql #postgres #mysql #databases #rdbms #programming

If anyone decided to set up #Nextcloud, I've learned that it runs so much better on #PostgreSQL than #MySQL or #MariaDB.

after bitnami went rogue and giving 28th August deadline to move away from their charts, had to move ≈2Ti #PostgreSQL database. Decided to go for @CloudNativePG and happy I did so.

Clearly the operator handles professionally and gives signals that its developers & maintainers are definite pro-gamers in managing PostgreSQL clusters at scale. Thank you for this amazing project

What if your #PostgreSQL cluster is running, and the demo app is generating traffic — but there's no visibility into the health of the #Kubernetes cluster, services, or applications? https://t.ly/lYDc6

Daniil Bazhenov shows you how to set up #Coroot in a #GitOps setup using #ArgoCD to gain complete observability, and stay in control of your system health.

Odoo multiple database issues #2004 #python #nginx #postgresql #odoo

https://askubuntu.com/q/1553441/612

#JeRecrute un•e ingénieur•e data/backend #Python / #PostgreSQL pour Ecobalyse, la startup d’État qui calcule combien coûtent à la planète les mer^Wtrucs qu'on achète

PS: ça va faire super malpoli/yolo mais je me casse en vacances ce soir et j'ai vraiment besoin d'un gros break donc je laisse mes adorables collègues dont @vjousse vous filer toutes les infos complémentaires dont vous auriez besoin (désolé copain cœur sur tes mentions)

https://www.welcometothejungle.com/fr/companies/communaute-beta-gouv/jobs/data-back-end-pour-ecobalyse-mte-ademe_paris

Upgraded a PostgreSQL server from Debian 12 to 13, and got hit by this bug:

https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=960789

resutling in the new postgresql version running with the wrong configuration after running pg_upgradecluster.

its amazing how #pgbounce can reduce the direct connections to #postgresql improving the responses and reducing error like: too many clients already

Log analysis can take only seconds (not hours) with time-mapped heat graphs, pattern clustering and analysis, and errors sorted by severity. Try it out yourself: https://t.ly/DiUdd

New blog post Bits of engineering wisdom from a year of the #TalkingPostgres #podcast

featuring highlights from 13 episodes in the past year with amazing #PostgreSQL guests including: Tom Lane, Bruce Momjian, Daniel Gustafsson, David Rowley, Melanie Plageman, Robert Haas, Affan Dar, Andrew Atkinson, @BajoranEngineer, Peter Cooper, Peter Farkas, Pino de Candia, & Shireesh Thota

Hope y'all enjoy it! And big +1 to @asw for co-producing this monthly pod with me https://techcommunity.microsoft.com/blog/adforpostgresql/bits-of-wisdom-from-a-year-of-talking-postgres/4434622

He creado un canal en Rumble con las partes del tutorial #PostgreSQL y el lenguaje #SQL:

https://rumble.com/c/c-4781052

Suscríbete a mi canal.

#bbdd #Programacion #SiguemeYTeSigo #Followback

Nota: imagen generada con IA generativa.

I've been busy these last few months working part-time on this database, web api, and web front end to store, and report on architectural project data. The source code for the web api can be found on Github (https://github.com/rperez-rosario/XPM_Server). The source code for the front end will soonish follow.

Need to quickly teach someone why observability matters? Share this video of Coroot Co-founder Peter Zaitsev explaining the value in 1min

Tengo publicado en YouTube un tutorial para la instalación del servidor de base de datos #PostgresQL en una máquina virtual con #Ubuntu.

https://youtu.be/HKfhKnmIFLU

#Gratis #Free #SiguemeYTeSigo #folloback #FolloMe #Linux #SQL #BBDD

Nota: imagen generada con IA generativa.

Renaming things in the db because we want proper naming in this household!

Tengo publicado en YouTube un tutorial para la instalación de la base de datos PostgreSQL (la base de datos de código abierto más usada).

https://youtu.be/1GXXMnXs6gI

#PostgreSQL #BBDD #Gratis #Free #SiguemeYTeSigo #folloback #FolloMe

Nota: imagen generada con IA generativa.

nice #postgresql extension i came across: pgstattuple, to better know if a vacuum/repack would help much in decreasing database size

Write for our community blog to share #SRE tips, experiences, or an #opensource observability project you're working on, so everyone can improve their skills together! http://coroot.com/submit-a-blog/