Notices tagged with postgresql

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

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

#FOSDEM #PostgreSQL #postgres

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

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 #Programacion #SiguemeYTeSigo #Followback

Tengo publicado en YouTube un tutorial para la instalación y configuración del driver #JDBC de #PostgreSQL en el servidor de aplicaciones #Wildfly.

https://youtu.be/yeOi8FfVIAI

#Gratis #Free #SiguemeYTeSigo #folloback #FolloMe #Java

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 #Programacion #SiguemeYTeSigo #Followback

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

@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.

procrastination and slow progress with #misskey #migration; I plan on migrating my #postgresql onto a #container, currently running on #baremetal #KbC #S4S #shittycode #justDeveloperThings

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!

#Mastodev #SelfHosted #SelfHosting #Postgresql #mysql

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

@mk @p @djsumdog I can understand you both. On one hand, software X can migrate/upgrade its file structure (e.g. "binary format") by itself by running automatically some migration/upgrade script. These scripts can be bound to version numbers (when the upgrade takes place) so the user=admin isn't bothered by it. The "in-place" migration also forces the upgrade on the user=admin.

But it seems like #PostgreSQL seem to follow an other philosophy that says that administrators are the responsible persons and it should be in their full control when the migration/upgrade should take place. So they don't want to force the upgrade on the admin's decision-making progress and let him decide whenever it takes place.

So what would be the solution? A simple script like pg_upgrade.sh that the administrator can manually run or for those people like @mk is that the installer asks "Should pg_upgrade.sh run for your automatically?" and it is done then during upgrade.

Sometimes I forget how a simple index in a column may provide a significant impact in the performance of our system ...

https://github.com/lhc/thebook/commit/8830e9f0e15943dbad4bc85d6588f67cbf3b11a0#diff-641b4ae0a3769c5f1eee1f471ee7292ed173d2f600aa9e766b1d4630227cc6baR20

Now the transactions page loads faster 🙂

#django #index #sql #postgresql