Notices tagged with postgresql

@dansup@mastodon.social and still the question remains... are #Loops going to support #postgreSQL 16+

Um ex-colega de faculdade e de trabalho era fã de #Python e PostgreSQL.

Minha experiência com #PostgreSQL sempre foi ruim. No começo, eu tinha muita dificuldade em instalar e quando dava certo, não conseguia fazer o #PHP se conectar a base de dados.

Passa o tempo, eu aprendo #Docker e depois #NixOS e decido que a base de dados da minha instância #Nextcloud seria PostgreSQL.

Resultado: toda vez que eu preciso atualizar o sistema, o Nextcloud para de funcionar porque o PostgreSQL não tem um script de atualização próprio. Aí eu passo dois dias ou mais sem poder acessar a minha instância do Nextcloud.

Dessa vez, eu vou abolir de vez o PostgreSQL da minha vida. Só vou usar se for estritamente necessário (ou obrigado) e vou fazer de tudo para não atualizar.

余裕だったはずの採番が最大値に到達してしまった話 #PostgreSQL - Qiita https://share.google/KRTEfedVomW4p9fTf

わお

Datadog is hiring Manager I, Engineering - Data & Analytics, Governance

🔧 #golang #python #react #api #kafka #kubernetes #postgresql
🌎 New York City, New York
⏰ Full-time
🏢 Datadog

Job details https://jobsfordevelopers.com/jobs/manager-i-engineering-data-analytics-governance-at-datadoghq-com-aug-27-2025-281bad?utm_source=mastodon.world&utm_medium=social&utm_campaign=posting
#jobalert #jobsearch #hiring

A question for the #MastoAdmin community:

What's your PostgreSQL backup strategy?

How much data would you expect to lose if your primary DB died suddenly?

Seconds? Hours? Days?

#Mastodon #PostgreSQL

@id

I run both @prosodyim and @ejabberd. IMHO, both are easy to set up and maintain nowadays.

Just make sure that you use the file store for #Prosody (not an #RDBMS) and #PostgreSQL for #Ejabberd (not Mnesia) 🙂

Both have some minor features, that might be not present in the other, though. E.g. "great invitations", which are ATM only present in Prosody (but WiP for Ejabberd).

https://blog.prosody.im/great-invitations/

#Jabber #XMPP

After supper tonight, I'm going to try upgrading three #PostgreSQL "clusters" from 14 to 15. I don't think there are any anticipated gotchas, but that's why we do these things on little personal databases before taking a wrecking ball to prod.

Still going to have to research how to upgrade a "cluster" that is running streaming replication. That'll be a hassle for sure.

The #PostgreSQL upgrade (14->15) was shockingly easy on all three servers, which makes me wonder what horrors it has in store for me when I go to do the same thing on my work database servers, which have much more complicated access controls, replication, and other fun stuff like that.

Currently I'm working on extending my #Ansible collection more specifically the ansible_podman role.

I'm extending my #podman role with plugins, so it will not only deploy but also configure the containerized application / service.

Currently I'm supporting #postgresql and #borgmatic #borgbackup
In that very process I'm also reworking those roles as the plugins just use the existing roles.

Jumpstart a host with postgresql database, borgmatic backup and apprise notifications.
#docker

https://github.com/gristlabs/grist-core#:~:text=the%20grist-core%20repo%20is%20the%20heart%20of%20grist%2C

Grist is the evolution of #spreadsheets.

The grist-core repo is the heart of Grist, including the hosted services offered by Grist Labs, an NYC-based company 🇺🇸 and Grist's main developer.

The French government 🇫🇷 organizations ANCT Données et Territoires and DINUM (Direction Interministérielle du Numérique) have also made significant contributions to the codebase.

- https://github.com/gristlabs/grist-core/commit/7bfe88bb3ee08d2393210e26bbc240aba4a0f5a7

#grist #excel #databases #slalite #postgresql #dinum #communs

Esta es la lista con los capítulos del tutorial de #PostgreSQL y el lenguaje #SQL:

https://www.youtube.com/watch?v=8_HFyjcUt6Q&list=PLtdeXn2f7ZbNOTrW0POHNuoNbgpc-Qo-6.

Suscríbete a mi canal.

#bbdd #SiguemeYTeSigo #Followback

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

Encontraram um bug grave no PostgreSQL que teria permitido a invasão ao Departamento do Tesouro estadunidense.

É um bug zero-day, ou seja, recém descoberto. Ele já foi informado aos desenvolvedores e corrigido semana passada.

Esse é um dos motivos para se utilizar sempre as versões mais recentes de softwares para ter acesso a correções como esta.

Como o Mastodon e outros softwares do fediverso usam PostgreSQL, verifiquem se já estão na versão mais recente (v17.3).

Se estiver numa versão anterior (como a 15 ou 16), a lógica de atualização é esta:

:xp_server: https://medium.com/@gembit.soultan/how-to-upgrade-postgresql-15-to-postgresql-16-using-pg-upgradeclusters-in-ubuntu-22-04-c9f279c5d3ab

Lembrem-se de fazer backup antes.

Notícias sobre o bug:

:xp_virus_protection: https://www.bleepingcomputer.com/news/security/postgresql-flaw-exploited-as-zero-day-in-beyondtrust-breach/
:xp_virus_protection: https://www.theregister.com/2025/02/14/postgresql_bug_treasury/

@fediadminbr

#FediAdminBR #MastoAdmin #PostgreSQL

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

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