If you are coming to #PGConfDev in #Montreal in May, there's an entire "Postgres Extensions Day" on Monday before the conference!

Looking forward to see you there and talk about #PostgreSQL extensions!

https://pgext.day/

New episode of #TalkingPostgres #podcast

Bruce Momjian, #PostgreSQL core team member, joined me on Ep26 to talk about open source leadership—with rabbitholes on servant leadership, the art of public speaking, the power of gratitude, & bow ties

Boosts appreciated to help more people discover the podcast

https://talkingpostgres.com/episodes/open-source-leadership-with-bruce-momjian

https://youtu.be/gYG3FP-Csho?feature=shared

@iVarund (Varun Dhawan) is back for #PosetteConf 2025. He'll let us know "What's New with Azure Database for #PostgreSQL Flexible Server in 2025" (Livestream 3 on Wed Jun 11th @ 10:00am PDT (UTC-7))

Find out more: https://posetteconf.com/2025/talks/what-s-new-with-azure-database-for-postgresql-flexible-server-in-2025/

Hello, hachyderm! we've been working hard on building up our ansible runbooks and improving hachyderm's overall resilience. Recently, we've been focusing on is database resilience.

We're getting close to retiring our original database server (finally!) and preparing to move to a fully ansible-managed set of databases servers, primary and replica on new hardware. We'll send another announcement when we do the cut over. The team has done excellent work to make this highly automated, quick, and painless!

Done:

author ansible roles for managing postgresql, pgbackrest (backups), pgbouncer, and primary/replica failover
decide to continue with pgbouncer and *not* use pgcat
rotate database passwords
order new replica database hardware
order new future primary database hardware

To do soon:

rebuild replica database with ansible scripts
prepare primary database with ansible scripts
start replicating to new database replica
cut over to new database server

We're also planning on open-sourcing our ansible roles in the coming weeks - just a little housekeeping & tidying up before we do!

Are you coming to @pgconfdev ? There is a Community Summit on Tuesday before the conference. Sign up now!

https://2025.pgconf.dev/schedule.html

Really #postgresql ? I can insert text value into an integer column?

Updated entry in #PostgreSQL Event Calendar:

Boston Meetup: Kubernetes operators for Postgres

Date: 2025-04-17T22:30:00Z - 2025-04-18T00:30:00Z
Location: Filippo's Restaurant 283 Causeway St · Boston, MA

ICS file: https://ics.postgresql.life/7kfoa5lv6j0hdcpesv9agk64uf.ics

Headway is hiring Engineering Manager (Claims Platform)

#python #typescript #nextjs #react #remix #aws #kafka #postgresql #redis #awss3 #engineeringmanager
Remote; New York City, New York; San Francisco, California; Seattle, Washington
Full-time
Headway

Job details https://jobsfordevelopers.com/jobs/engineering-manager-claims-platform-at-headway-co-mar-18-2025-ec76fb?utm_source=mastodon.world&utm_medium=social&utm_campaign=posting
#jobalert #jobsearch #hiring

#PostgreSQL Event Calendar, Reminder:

Postgres Extensions Ecosystem Mini-Summit #3

Date: 2025-04-09T16:00:00Z - 2025-04-09T17:00:00Z
Location: https://meetu.ps/e/NX69T/k17qn/i

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

Welcome back to #PosetteConf 2025 @cyberdemn (Alexander Kukushkin). Looking forward to your talk on "Myths and Truths about Synchronous Replication in #PostgreSQL" (Livestream 3 on Wed Jun 11th @ 9:30am PDT (UTC-7))

Read more: https://posetteconf.com/2025/talks/myths-and-truths-about-synchronous-replication-in-postgresql/

#PostgreSQL Event Calendar, Reminder:

Postgres Meetup for All

Date: 2025-04-09T17:00:00Z - 2025-04-09T18:00:00Z

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

https://pganalyze.com/blog/postgresql-vs-sql-server-btree-index-deduplication

"Managing #PostgreSQL at scale: Challenges, Tools, & Techniques" will be presented by @karenhjex (Karen Jex) at #PosetteConf 2025 (Livestream 3 on Wed Jun 11th @ 9:00am PDT (UTC-7))

Learn more: https://posetteconf.com/2025/talks/managing-postgres-at-scale-challenges-tools-techniques/

Video: Adding a foreign key constraint to an existing #SQLite table using Database Workbench.

https://www.youtube.com/watch?v=ZnFf4sj8jro

#MySQL
#MariaDB
#SQLServer
#Oracle
#Firebird
#InterBase
#PostgreSQL
#NexusDB
#databasetools #databasedevelopment #DatabaseWorkbench

#PostgreSQL Event Calendar, Reminder:

Stockholm PostgreSQL Meetup

Date: 2025-04-08T16:00:00Z - 2025-04-08T19:30:00Z
Location: Frever AB Torkel Knutssonsgatan 24 · Stockholm

ICS file: https://ics.postgresql.life/66usah9r4kbb6v30s7r4fb698a.ics

#PostgreSQL Event Calendar, Reminder:

The San Francisco Bay Area PostgreSQL Meetup Group

Date: 2025-04-08T18:00:00Z - 2025-04-08T19:30:00Z
Location: online

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

Sponsor Opportunities Now Available! https://www.postgresql.eu/events/pgdaynapoli2025/news/sponsor-opportunities-now-available-166/

A LIVE recording of Ep26 of the #TalkingPostgres #podcast will happen on Wed Apr 2 @ 10am PDT

If open source—or Postgres—is your jam , come join the parallel live text chat (& listen to the LIVE recording) on the Microsoft Open Source Discord

Guest: Bruce Momjian of EDB, member of #PostgreSQL core team & co-founder of the PostgreSQL Global Development Group
Topic: Open Source Leadership
Cal invite for parallel live text chat https://aka.ms/TalkingPostgres-Ep26-cal

#Postgres #databases #OpenSource #community #leadership #Microsoft

p.s. Boost to your friends please! And yes, you can also wait til the episode is published & download wherever you get your podcasts, to listen at your convenience!

MySQLとPostgreSQLのコマンドの違いまとめ
https://qiita.com/kojiro513/items/1ec19bdadddcf4c732c2?utm_campaign=popular_items&utm_medium=feed&utm_source=popular_items