Elektrine
Log in Register

#postgresql

13 posts · Last used 13d

Back to Timeline
@Larvitz@mastodon.bsd.cafe · Apr 14, 2026

Latest quarterly FreeBSD package upgrade broke my Nextcloud 😮‍💨

Post mortem: The new version of php85-pdo_pgsql is now compiled against PostgreSQL 18, not 17. So pkg upgrade removed postgresql17-server, leaving Nextcloud dysfunctional without a database.

Solution:

  • Reinstalled postgresql17-server
  • Dumped the db with pg_dump
  • Installed postgresql18-server & php85-pdo_pgsql
  • Copied over pg_hba.conf & postgresql.conf
  • Created empty db/user in PG18
  • Imported the db dump
  • Ran occ maintenance:data-fingerprint

Restarted php-fpm & nginx

All fine again. But that was unpleasant 🙂

#SysAdmin #SelfHosted #FreeBSD #Nextcloud #Postgresql

21
4
14
@tmuwa@burningboard.net · Apr 12, 2026
https://tabularis.dev/ A great project with a dedicated maintainer.Definitly check it out if you need a graphical #database client for #PostgreSQL, #MySQL/#MariaDB or #SQLite. And yes I contributed one or two little commits myself. 😜
0
0
0
@guiadeti@flipboard.social · Feb 26, 2026
Certificação em Bancos de Dados Relacionais da freeCodeCamp: Curso Gratuito com Projetos Práticos https://guiadeti.com.br/certificacao-bancos-de-dados-relacionais-freecodecamp/ #bancodedados #bash #certificacao #freecodecamp #postgresql #programacao #sql https://guiadeti.com.br/certificacao-bancos-de-dados-relacionais-freecodecamp/?fsp_sid=1050
0
0
0
@socallinuxexpo@social.linux.pizza · Feb 23, 2026
Speaker Spotlight: Henrietta Dombrovskaya PostgreSQL and Academia—Establishing Partnership Watch the full talk: https://youtu.be/6sgV0UxZw5Y?si=eFG9FQs67e0ImYey Join us at SCaLE 23x to explore how open source is transforming education! 🚀 #SCaLE23x #OpenSource #PostgreSQL #SoCalLinuxExpo
0
1
0
@jobsfordevelopers@mastodon.world · Feb 23, 2026
SoFi is hiring Staff Software Engineer, Member 🔧 #java #kotlin #kubernetes #postgresql 🌎 San Francisco, California ⏰ Full-time 🏢 SoFi Job details https://jobsfordevelopers.com/jobs/staff-software-engineer-member-at-sofi-com-jan-23-2026-5515c0?utm_source=mastodon.world&utm_medium=social&utm_campaign=posting #jobalert #jobsearch #hiring
0
0
1
@rperezrosario@mastodon.social · Feb 19, 2026
Tiger Data author Raja Rao makes a pretty good case for reducing operational complexity by using a single database server (PostgreSQL) to supplant non-relational use cases that were previously handled by the likes of Elasticsearch, Redis, and MongoDB to name a few. He goes on to list and explain the different PostgreSQL extensions that can provide equivalent services without the database sprawl. "It's 2026, Just Use Postgres" https://www.tigerdata.com/blog/its-2026-just-use-postgres #programming #sql #postgresql #databases
3
0
4
@semurjengkol@misskey.sangeunahna.com · Feb 21, 2026
Sip, #postgresql #replication antar data center instance misskey ini dah beres. Yuk kita lanjut ibadah alias tidur disaat puasa.
0
1
0
@tiagojferreira@bolha.us · Feb 21, 2026
PostgreSQL sustentando 800 milhões de usuários na OpenAI https://openai.com/pt-BR/index/scaling-postgresql/ #postgresql #CodigoAberto #SoftwareLivre
0
0
0
@fox@cytag.nl · Feb 11, 2026
Renaming a table in SQL Since I am currently overhauling many websites, I needed in one particular case to rename a table. Never needed this before, I searched and found the following. Bog-standard SQL (which worked for me) RENAME TABLE ohu1y_docman_file_counts TO ohu1y_docman_file_counts_bak; PostgreSQL / SQLite ALTER TABLE ohu1y_docman_file_counts RENAME TO ohu1y_docman_file_counts_bak; --- https://3xn.nl/projects/2026/02/11/renaming-a-table-in-sql/ --- #mysql #postgresql #rename #sqlite #table
1
1
1
@upscene@mstdn.business · Feb 11, 2026
📣 New release of #DatabaseWorkbench now available! 🖥 Database Workbench is a developer tool for #SQLServer, #Firebird, #Oracle, #SQLite, #MySQL, #MariaDB, #PostgreSQL, #InterBase and #NexusDB. ⬇️ Grab your trial copy now. https://www.upscene.com/database_workbench/
0
0
0
@jobsfordevelopers@mastodon.world · Feb 06, 2026
SumUp is hiring Developer Experience Engineer - Quality Infrastructure 🔧 #golang #java #kotlin #python #aws #cicd #docker #kafka #kubernetes #postgresql 🌎 Vilnius, Lithuania ⏰ Full-time 🏢 SumUp Job details https://jobsfordevelopers.com/jobs/developer-experience-engineer-quality-infrastructure-at-sumup-com-jan-14-2026-ae1228?utm_source=mastodon.world&utm_medium=social&utm_campaign=posting #jobalert #jobsearch #hiring
2
0
0
@jobsfordevelopers@mastodon.world · Feb 02, 2026
Remote is hiring Senior Backend Engineer (Elixir) 🔧 #angular #react #vue #aws #cicd #docker #kubernetes #postgresql #seniorengineer 🌎 Remote; Asia ⏰ Full-time 🏢 Remote Job details https://jobsfordevelopers.com/jobs/senior-backend-engineer-elixir-at-remote-com-dec-23-2025-068583?utm_source=mastodon.world&utm_medium=social&utm_campaign=posting #jobalert #jobsearch #hiring
0
0
1
@phantasus@fedi.at · Jan 27, 2026
I'm a senior software developer who is proficient in #ruby #elixir #sql #java #linux #clang #javascript #python #postgresql #postgis #mqtt #rabbitmq I search for a #job and I reside currently in #austria #vienna and I'm fluent in #german and #english I love #foss #opensource and #rest #api Let's #getfedihired #gethired #hiring
13
0
59

You've seen all posts