Create accountLogin

Recent searches

No recent searches

Search options

Only available when logged in.
techhub.social is one of the many independent Mastodon servers you can use to participate in the fediverse.
A hub primarily for passionate technologists, but everyone is welcome

Administered by:

Server stats:

5.3K
active users

techhub.social: AboutStatusProfiles directoryPrivacy policy

Mastodon: AboutGet the appKeyboard shortcutsView source codev4.3.7

#PostgreSQL

91 posts70 participants8 posts today
Public
Sarah Conway

@tchorix & I are presenting on data modeling within #PostgreSQL in a storytelling fashion at @posetteconf, a free virtual event hosted by #Microsoft that's all about #Postgres this June 10-12!

Want to tune in? Add the livestream to your calendar, or register (optionally) here: posetteconf.com/2025/talks/pos (or, wait until the recording is out after the event!)

Illustrations will be completed by Scarlett Riggs, who we are very excited to be working with.

This talk should be great for anyone that's looking to understand things from the perspectives of an application developer, and a seasoned database administrator; here, you'll be able to learn when it is best to handle logic within the database vs. the application!

Looking forward to seeing you there 📽️

POSETTE: An Event for Postgres 2025, hosted by Microsoft. Postgres Storytelling: Cunning Schema Design with Creative Data Modeling, delivered by Boriss Meijias (PostgreSQL Solution Architect @ EDB) and Sarah Conway (Head of DevRel @ Data Bene) from June 10-12, 2025.
#techevent#tech#opensource
Public
Julien Riou

TIL: you cannot simply dump and restore a PostgreSQL database with the TimescaleDB extension, you have to tell the extension you are dumping the database, then dump/restore and finally tell the extension you have finished the dump. You also have to make sure both clusters have the same TimescaleDB version available.

docs.timescale.com/self-hosted

docs.timescale.comTimescale Documentation | Migrate the entire database at onceMigrate a small database to self-hosted TimescaleDB in one go with `pg_dump` and `pg_restore`
#postgresql#timescaledb
Continued thread
Public
arabiccola

PS: I also discovered you can modify the `lnav` behaviour by only showing new logs at the time of using the SSH command above:

```
#!/usr/bin/env bash

export TZ='Europe/Berlin';
NOW="$(date -Iseconds | sed -e 's/+.*$//')"
LOG_FILE="$(ls -t ~/pgdata/data/logs/*.log | head -n 1)"

if [ "$1" = "now" ]; then
lnav "$LOG_FILE" -c ":hide-lines-before $NOW"
else
lnav "$LOG_FILE"
fi
```

#ssh#lnav#postgresql
Public
PostgreSQL Conference Germany

The countdown to PGConf.DE 2025 has begun!

May 8–9 in Berlin

Two days, two tracks, talks in German and English, and a great opportunity to learn all things PostgreSQL.

Tickets are limited, so don’t miss out — register now!

Check the full program and grab your ticket: 2025.pgconf.de

PostgreSQL Conference Germany – May 08–09, 2025
2025.pgconf.dePostgreSQL Conference Germany 2025A 2-day, 3-track PostgreSQL conference in Berlin, Germany.
#PGConfDE#PostgreSQL#Conference
ExploreLive feeds
About