Garrett Wollman
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.
Garrett Wollman
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.
Junicast
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
pvergain (framapiaf)
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
kreuger458
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.
kreuger458
Tengo publicado en YouTube un tutorial para la instalación del servidor de base de datos #PostgresQL en una máquina virtual con #Ubuntu.
#Gratis #Free #SiguemeYTeSigo #folloback #FolloMe #Linux #SQL #BBDD
Cadu Silva :verifiedcat:
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:
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/
kreuger458
Tengo publicado en YouTube un tutorial para la instalación del servidor de base de datos #PostgresQL en una máquina virtual con #Ubuntu.
#Gratis #Free #SiguemeYTeSigo #folloback #FolloMe #Linux #SQL #BBDD
kreuger458
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.
kreuger458
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.
Lyyn ☮️
kreuger458
Tengo publicado en YouTube un tutorial para la instalación del servidor de base de datos #PostgresQL en una máquina virtual con #Ubuntu.
#Gratis #Free #SiguemeYTeSigo #folloback #FolloMe #Linux #SQL #BBDD
kreuger458
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.
kreuger458
Tengo publicado en YouTube un tutorial para la instalación y configuración del driver #JDBC de #PostgreSQL en el servidor de aplicaciones #Wildfly.
kreuger458
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.
kreuger458
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.
kuteboiCoder
@brigrammer@poa.st
no fucking clue.
I'm using misskey, outta the box. It's got almost no English-language documentation. Takes a little bit of brainpower (and practice) just to run the bash installer.
#Misskey is a #Node #Typescript application, running on port 3000, and uses #postgresql and #redis for data backend. I'm assuming that the redis does fast cacheing of some sort, not sure what all is there. Also has #nginx set up as a #reverseproxy on port 80, even though the the documentation tells us to expose port 3000 to the world.
That's what I did. I'm assuming that most federation would still work even with port 3000 closed, but it's not worth taking the chance.
The entire application is very fast running and very snazzy looking when it's running all on one box with a good deal of hardware available.
I know that misskey works, and it's a good program, but I want it to be slightly budget-optimized and somewhat containerized so that I can tinker with other containerized applications with the #VPS I already have running.
kuteboiCoder
procrastination and slow progress with #misskey #migration; I plan on migrating my #postgresql onto a #container, currently running on #baremetal #KbC #S4S #shittycode #justDeveloperThings
Jerry on Mastodon
Hey, Fediverse! I'm looking for informed opinions on database choices.
I can stand up an Internet-facing application and have it use either mysql or postgresql. Which is the better choice, and why do you think so?
Thanks!
kreuger458
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.
GNU social JP is a social network, courtesy of GNU social JP管理人. It runs on GNU social, version 2.0.2-dev, available under the GNU Affero General Public License.
All GNU social JP content and data are available under the Creative Commons Attribution 3.0 license.