jspath55, to til
@jspath55@chaos.social avatar

of a handy SQL statement to put a table in another schema from where it was last:

ALTER TABLE [ IF EXISTS ] name SET SCHEMA new_schema

H/T: https://postgrespro.com/list/thread-id/2426057

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

Call for Papers for PGDay Hyd 2024 (Hyderabad, India) is open, until June 7th. Not a lot of time to submit your talks!

#CfP #CallForPapers #PostgreSQL #Conference #India #Hyderabad

https://pghyd.in/

pamelafox, to python
@pamelafox@fosstodon.org avatar

My talk for Posette this year will be about "pgvector for Python developers" - two of my current fav things. The conf is virtual and free, so join us on June 12th!

https://www.citusdata.com/posette/speakers/pamela-fox#abstract

Pamela pointing at her slides about pgvector for Python developers

ascherbaum, to PostgreSQL
@ascherbaum@mastodon.social avatar

New entry in Event Calendar:

⌛CfP PGDay UK 2024

Date: 2024-06-09
Location: London, UK

ICS file: https://ics.postgresql.life/6srjgob46ss34b9lcph36b9kckqm4b9o61h3ebb1c9i3gp3570s32phm6o.ics

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 https://justatheory.com/2024/02/decentralized-extension-publishing/

ascherbaum, to PostgreSQL
@ascherbaum@mastodon.social avatar

#PostgreSQL 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 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) 🦘

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.

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

#python #django #typescript #golang #postgresql #swift

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?


  • All
  • Subscribed
  • Moderated
  • Favorites
  • megavids
  • thenastyranch
  • magazineikmin
  • osvaldo12
  • cubers
  • mdbf
  • Youngstown
  • tacticalgear
  • slotface
  • rosin
  • kavyap
  • ethstaker
  • everett
  • khanakhh
  • JUstTest
  • DreamBathrooms
  • InstantRegret
  • normalnudes
  • GTA5RPClips
  • tester
  • ngwrru68w68
  • cisconetworking
  • modclub
  • Durango
  • Leos
  • provamag3
  • anitta
  • lostlight
  • All magazines