stux, to random
@stux@mstdn.social avatar

⚠️ I am aware there are still issues with mstdn.social and I'm still working on fixing it all❤️

Everything should work as intended except sometimes things could be a little slow :sad_cat:

I've been in talks with the devs for some days to try and solve this issue and we'll keep going until it's fixed

All I ask is a little understanding and patience :cat_hug_triangle: I'll be posting less since I'm working on this from the moment I wake up until I go to sleep again but do know I'm working on it!

stux,
@stux@mstdn.social avatar

I shall try and explain the issue a bit

When we moved our database to a new server the import did not go as planned since there was a change in the DB software

After manually correcting the database issue we now are left with a slow database, that should be super fast

A reason COULD BE that we now use Hetzner volume to store the DB instead of internal disk but we're not sure..

Currently our DB is reindexing the status table but that's going for over 18 hours already

hunleyd, to PostgreSQL
@hunleyd@fosstodon.org avatar
hunleyd, to PostgreSQL
@hunleyd@fosstodon.org avatar

Contemplating Decentralized Extension Publishing #postgresql https://justatheory.com/2024/02/decentralized-extension-publishing/

ascherbaum, to PostgreSQL
@ascherbaum@mastodon.social avatar

Event Calendar, Reminder:

🌐 The San Francisco Bay Area PostgreSQL Meetup Group

Date: 2024-05-08T19:00:00Z - 2024-05-08T20:30:00Z

ICS file: https://ics.postgresql.life/bpv3t2qgktncf50cj76ict0ddsqnr6eslnanscmed7vbu1nam6abjh3kkj.ics

hunleyd, to PostgreSQL
@hunleyd@fosstodon.org avatar
hunleyd, to PostgreSQL
@hunleyd@fosstodon.org avatar
ascherbaum, to PostgreSQL
@ascherbaum@mastodon.social avatar

New entry in Event Calendar:

🌐 The San Francisco Bay Area PostgreSQL Meetup Group

Date: 2024-05-08T19:00:00Z - 2024-05-08T20:30:00Z

ICS file: https://ics.postgresql.life/bpv3t2qgktncf50cj76ict0ddsqnr6eslnanscmed7vbu1nam6abjh3kkj.ics

hunleyd, to PostgreSQL
@hunleyd@fosstodon.org avatar
ascherbaum, to PostgreSQL
@ascherbaum@mastodon.social avatar

New entry in #PostgreSQL Event Calendar:

👫 PGDay Israel 2024

Date: 2024-10-20
Location: Tel Aviv-Yafo, Israel

ICS file: https://ics.postgresql.life/3clb656j2vtcpf0tbont0d0cra.ics

genevarb, to OpenAI
@genevarb@ruby.social avatar

Next meetup alert!

On june 5th, @yannis will show how to use 's GPT-4 and Embedding APIs to implement a semantic search system in using the pg_vector extension and the neighbor gem.

🥗 He will illustrate this with concrete examples from MyFoodRepo, the application he is currently working on.

📆 Details and RSVP: https://www.meetup.com/geneva-rb/events/299288852/

🙏 Thanks to our sponsors mobilidee.ch & @rorvswild

hunleyd, to PostgreSQL
@hunleyd@fosstodon.org avatar
paulox, to ubuntu
@paulox@fosstodon.org avatar

🚀 I just published a short guide explaining how to upgrade PostgreSQL 🐘 from version 15 to 16 just after an upgrade to Ubuntu 24.04 LTS (Noble Numbat) 🦘

#Ubuntu #NobleNumbat #Noble #Numbat #LTS #PostgreSQL #Postgres #HowTo #Upgrade

Read it 👇
https://www.paulox.net/2024/05/20/upgrading-postgresql-from-version-15-to-16-on-ubuntu-24-04-noble-numbat/

nicd, to random

I have a home server with various services running (all isolated with different user accounts). The server has a small SSD and a big external HDD, but I'd like to make external backups to my cloud account. The cloud service has a proprietary command line application to sync data, so backups would ideally be date separated compressed tar files that it can then sync. An additional complication are PostgreSQL and SQLite databases that can't just be copied without risking breaking the integrity of the files.

How would you do the backups? Do you have some existing app that you could suggest? I'm sure I can whip up some script to do it, but I wouldn't mind if there was something already made.

#SelfHosting #HomeServer

adelgado, (edited )
@adelgado@eu.mastodon.green avatar

@nicd
Restic is a command line tool that supports a lot of storage solutions S3, SFTP, DAV, etc. There are some beta UI but I run it in scheduled jobs using a systemd timer. It can encrypt the data. For the database: postgresql have a backup tool to dump the databases to a file that then you can backup with the rest (I keep 7 local copies)

erinc, to python
@erinc@mastodon.social avatar

After an 8-year break from web development, I evaluated modern tech stacks to build my personal projects in 2024. This post chronicles my journey in selecting the perfect combination of backend, frontend, database, and hosting.

https://erinc.ca/tech-stack-2024

linuxmagazine, to linux
@linuxmagazine@fosstodon.org avatar
hunleyd, to PostgreSQL
@hunleyd@fosstodon.org avatar
hunleyd, to PostgreSQL
@hunleyd@fosstodon.org avatar
ascherbaum, to PostgreSQL
@ascherbaum@mastodon.social avatar

New entry in Event Calendar:

⌛ CfP PGDay Israel 2024

Date: 2024-06-30
Location: Tel Aviv-Yafo, Israel

ICS file: https://ics.postgresql.life/066q4a72l06tibvgledlbcqib4.ics

linuxmagazine, to PostgreSQL
@linuxmagazine@fosstodon.org avatar

From today's Linux Update newsletter: Artur Skura provides an introduction to PostgreSQL and helps you get started with some useful features. https://www.linux-magazine.com/Issues/2024/283/PostgreSQL
#database #PostgreSQL #OpenSource #DBMS #MariaDB #NoSQL #MongoDB

preslavrachev, to programming
@preslavrachev@mastodon.social avatar

Let's put an end to the age-old database debate, shall we?


#programming #sqlite #postgresql

hunleyd, to PostgreSQL
@hunleyd@fosstodon.org avatar

PGSQL Phriday #015: UUID: let's fight! #postgresql https://mydbanotebook.org/post/uuid-fight/

ascherbaum, to PostgreSQL
@ascherbaum@mastodon.social avatar
ascherbaum, to PostgreSQL
@ascherbaum@mastodon.social avatar

Event Calendar, Reminder:

👫 Prague PostgreSQL Meetup

Date: 2024-04-29T16:00:00Z - 2024-04-29T18:00:00Z
Location: Betsys
Karolinská 650/1, 186 00 Karlín, Tschechien

ICS file: https://ics.postgresql.life/pis3qbjbsslhduch28u5ji5oq0937piuipi45cphr22bljiht9cmfkpc9j.ics

pgconfeu, to PostgreSQL
@pgconfeu@mastodon.social avatar

We plan to open our call for sponsors at 10:00 Athens time on Wednesday, May 22nd. You can already preview the sponsorship options at:

https://2024.pgconf.eu/become-sponsor/

Limited levels often sell out fast, so act quickly!

#postgresql #database #opensource #athens

hunleyd, to PostgreSQL
@hunleyd@fosstodon.org avatar
  • All
  • Subscribed
  • Moderated
  • Favorites
  • provamag3
  • tacticalgear
  • magazineikmin
  • InstantRegret
  • GTA5RPClips
  • ngwrru68w68
  • Youngstown
  • cisconetworking
  • slotface
  • everett
  • rosin
  • Durango
  • kavyap
  • DreamBathrooms
  • JUstTest
  • mdbf
  • thenastyranch
  • normalnudes
  • tester
  • modclub
  • khanakhh
  • ethstaker
  • cubers
  • osvaldo12
  • megavids
  • Leos
  • anitta
  • lostlight
  • All magazines