Create accountLogin

Recent searches

No recent searches

Search options

Only available when logged in.
mastodon.world is one of the many independent Mastodon servers you can use to participate in the fediverse.
Generic Mastodon server for anyone to use.

Administered by:

Server stats:

11K
active users

mastodon.world: AboutStatusProfiles directoryPrivacy policy

Mastodon: AboutGet the appKeyboard shortcutsView source codev4.3.7

#postgresql

120 posts74 participants1 post today
just4fun<p>pgAdmin 4 v9.2 Released</p><p><a href="https://www.postgresql.org/about/news/pgadmin-4-v92-released-3050/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://www.</span><span class="ellipsis">postgresql.org/about/news/pgad</span><span class="invisible">min-4-v92-released-3050/</span></a></p><p><a href="https://mastodon.social/tags/IT" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>IT</span></a> <a href="https://mastodon.social/tags/postgresql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>postgresql</span></a> <a href="https://mastodon.social/tags/pgadmin" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>pgadmin</span></a></p>
Andreas Scherbaum<p>If you are coming to <a href="https://mastodon.social/tags/PGConfDev" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>PGConfDev</span></a> in <a href="https://mastodon.social/tags/Montreal" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Montreal</span></a> in May, there's an entire "Postgres Extensions Day" on Monday before the conference!</p><p>Looking forward to see you there and talk about <a href="https://mastodon.social/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>PostgreSQL</span></a> extensions!</p><p><a href="https://pgext.day/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="">pgext.day/</span><span class="invisible"></span></a></p>
PostgreSQLThe Wide World of GiST Indexes &nbsp; In Parts I (Solving the Overlap Query Problem in PostgreSQL) an...<br><br><a href="https://www.red-gate.com/simple-talk/databases/postgresql/the-wide-world-of-gist-indexes/" rel="nofollow noopener noreferrer" target="_blank">https://www.red-gate.com/simple-talk/databases/postgresql/the-wide-world-of-gist-indexes/</a><br><br><a rel="nofollow noopener noreferrer" class="mention hashtag" href="https://mastodon.social/tags/Featured" target="_blank">#Featured</a> <a rel="nofollow noopener noreferrer" class="mention hashtag" href="https://mastodon.social/tags/PostgreSQL" target="_blank">#PostgreSQL</a> <a rel="nofollow noopener noreferrer" class="mention hashtag" href="https://mastodon.social/tags/Gist" target="_blank">#Gist</a> <a rel="nofollow noopener noreferrer" class="mention hashtag" href="https://mastodon.social/tags/Indexes" target="_blank">#Indexes</a><br><br><a href="https://awakari.com/pub-msg.html?id=SRzhzKpQuVvPJ4ybt4nCggaGWdE" rel="nofollow noopener noreferrer" target="_blank">Event Attributes</a>
PostgreSQLMulti-Version Concurrency Control (MVCC) in PostgreSQL: Learning PostgreSQL with Grant It’s a t...<br><br><a href="https://www.red-gate.com/simple-talk/databases/postgresql/multi-version-concurrency-control-mvcc-in-postgresql-learning-postgresql-with-grant/" rel="nofollow noopener noreferrer" target="_blank">https://www.red-gate.com/simple-talk/databases/postgresql/multi-version-concurrency-control-mvcc-in-postgresql-learning-postgresql-with-grant/</a><br><br><a rel="nofollow noopener noreferrer" class="mention hashtag" href="https://mastodon.social/tags/Featured" target="_blank">#Featured</a> <a rel="nofollow noopener noreferrer" class="mention hashtag" href="https://mastodon.social/tags/PostgreSQL" target="_blank">#PostgreSQL</a> <a rel="nofollow noopener noreferrer" class="mention hashtag" href="https://mastodon.social/tags/LearningPostgreSQLWithGrant" target="_blank">#LearningPostgreSQLWithGrant</a> <a rel="nofollow noopener noreferrer" class="mention hashtag" href="https://mastodon.social/tags/PlanetPostgreSQLGrantFritchey" target="_blank">#PlanetPostgreSQLGrantFritchey</a><br><br><a href="https://awakari.com/pub-msg.html?id=UHE2pwe7t9rwjWVTgNOIVooBYDA" rel="nofollow noopener noreferrer" target="_blank">Event Attributes</a>
Douglas J Hunley<p>PL/Perl now ties %ENV <a href="https://fosstodon.org/tags/perl" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>perl</span></a> <a href="https://fosstodon.org/tags/postgresql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>postgresql</span></a> <a href="https://fluca1978.github.io/2024/11/21/PLPerlTieENV.html" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">fluca1978.github.io/2024/11/21</span><span class="invisible">/PLPerlTieENV.html</span></a></p>
Claire Giordano ✨<p>New episode of <a href="https://hachyderm.io/tags/TalkingPostgres" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>TalkingPostgres</span></a> <a href="https://hachyderm.io/tags/podcast" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>podcast</span></a> 🎙️</p><p>Bruce Momjian, <a href="https://hachyderm.io/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>PostgreSQL</span></a> 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, &amp; bow ties </p><p>Boosts appreciated 🚀 to help more people discover the podcast</p><p>🎧 <a href="https://talkingpostgres.com/episodes/open-source-leadership-with-bruce-momjian" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">talkingpostgres.com/episodes/o</span><span class="invisible">pen-source-leadership-with-bruce-momjian</span></a></p><p>📺 <a href="https://youtu.be/gYG3FP-Csho?feature=shared" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">youtu.be/gYG3FP-Csho?feature=s</span><span class="invisible">hared</span></a></p><p><a href="https://hachyderm.io/tags/OpenSource" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>OpenSource</span></a> <a href="https://hachyderm.io/tags/leadership" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>leadership</span></a> <a href="https://hachyderm.io/tags/community" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>community</span></a> <a href="https://hachyderm.io/tags/Postgres" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Postgres</span></a> <a href="https://hachyderm.io/tags/databases" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>databases</span></a> <a href="https://hachyderm.io/tags/FOSDEM" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>FOSDEM</span></a></p>
Douglas J Hunley<p>Introducing pg_karnak: Transactional schema <a href="https://fosstodon.org/tags/migration" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>migration</span></a> across <a href="https://fosstodon.org/tags/tenant" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>tenant</span></a> <a href="https://fosstodon.org/tags/databases" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>databases</span></a> <a href="https://fosstodon.org/tags/postgresql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>postgresql</span></a> <a href="https://www.thenile.dev/blog/distributed-ddl" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://www.</span><span class="ellipsis">thenile.dev/blog/distributed-d</span><span class="invisible">dl</span></a></p>
POSETTE: An Event for Postgres<p>🌟 <span class="h-card" translate="no"><a href="https://mastodon.social/@iVarund" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@<span>iVarund</span></a></span> (Varun Dhawan) is back for <a href="https://mastodon.social/tags/PosetteConf" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>PosetteConf</span></a> 2025. He'll let us know "What's New with Azure Database for <a href="https://mastodon.social/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>PostgreSQL</span></a> Flexible Server in 2025" (Livestream 3 on Wed Jun 11th @ 10:00am PDT (UTC-7)) 🐘 </p><p>Find out more: <a href="https://posetteconf.com/2025/talks/what-s-new-with-azure-database-for-postgresql-flexible-server-in-2025/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">posetteconf.com/2025/talks/wha</span><span class="invisible">t-s-new-with-azure-database-for-postgresql-flexible-server-in-2025/</span></a></p>
PgUS<p>Are you ready for your close-up? Become a star today by joining PgUS!</p><p><a href="https://postgresql.us/becomeamember/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="">postgresql.us/becomeamember/</span><span class="invisible"></span></a></p><p><a href="https://fosstodon.org/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>PostgreSQL</span></a> <a href="https://fosstodon.org/tags/postgres" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>postgres</span></a></p>
Hachyderm<p>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.</p><p>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! :blobfoxscience: </p><p>Done:</p><p>✅ author ansible roles for managing postgresql, pgbackrest (backups), pgbouncer, and primary/replica failover<br>✅ decide to continue with pgbouncer and *not* use pgcat<br>✅ rotate database passwords <br>✅ order new replica database hardware<br>✅ order new future primary database hardware</p><p>To do soon:</p><p>🟨 rebuild replica database with ansible scripts<br>🟨 prepare primary database with ansible scripts<br>🟨 start replicating to new database replica<br>🟨 cut over to new database server 🎉 </p><p>We're also planning on open-sourcing our ansible roles in the coming weeks - just a little housekeeping &amp; tidying up before we do!</p><p><a href="https://hachyderm.io/tags/hachyderm" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>hachyderm</span></a> <a href="https://hachyderm.io/tags/devops" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>devops</span></a> <a href="https://hachyderm.io/tags/sre" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>sre</span></a> <a href="https://hachyderm.io/tags/ansible" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>ansible</span></a> <a href="https://hachyderm.io/tags/postgresql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>postgresql</span></a></p>
Douglas J Hunley<p><a href="https://fosstodon.org/tags/Oracle" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Oracle</span></a> to <a href="https://fosstodon.org/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>PostgreSQL</span></a>: Roles &amp; Privileges | Stormatics <a href="https://stormatics.tech/blogs/transitioning-from-oracle-to-postgresql-roles-privileges" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">stormatics.tech/blogs/transiti</span><span class="invisible">oning-from-oracle-to-postgresql-roles-privileges</span></a></p>
PostgreSQL Conference Germany<p>Come see Haralampos Gavriilidis talk about "Unleashing the Elephant Herd: Decentralized Query Processing Across PostgreSQL Instances"!</p><p><a href="https://fosstodon.org/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>PostgreSQL</span></a> <a href="https://fosstodon.org/tags/Conference" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Conference</span></a> <a href="https://fosstodon.org/tags/PGConfDE" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>PGConfDE</span></a> <a href="https://fosstodon.org/tags/Berlin" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Berlin</span></a> </p><p><a href="https://www.postgresql.eu/events/pgconfde2025/sessions/session/6548-unleashing-the-elephant-herd-decentralized-query-processing-across-postgresql-instances/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://www.</span><span class="ellipsis">postgresql.eu/events/pgconfde2</span><span class="invisible">025/sessions/session/6548-unleashing-the-elephant-herd-decentralized-query-processing-across-postgresql-instances/</span></a></p>
PostgreSQL Conference Germany<p>Check out the interview with Gold sponsor Xata just posted at <a href="https://2025.pgconf.de/sponsor-interviews/xata/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">2025.pgconf.de/sponsor-intervi</span><span class="invisible">ews/xata/</span></a>!</p><p><a href="https://fosstodon.org/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>PostgreSQL</span></a> <a href="https://fosstodon.org/tags/PGConfDE" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>PGConfDE</span></a> <a href="https://fosstodon.org/tags/berlin" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>berlin</span></a> <a href="https://fosstodon.org/tags/OpenSource" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>OpenSource</span></a> <a href="https://fosstodon.org/tags/Database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Database</span></a></p>
PostgreSQL<br><br><a href="https://www.freelancer.com/projects/qi/Bongo-Water.html" rel="nofollow noopener noreferrer" target="_blank">https://www.freelancer.com/projects/qi/Bongo-Water.html</a><br><br><a rel="nofollow noopener noreferrer" class="mention hashtag" href="https://mastodon.social/tags/PostgreSQL" target="_blank">#PostgreSQL</a> <a rel="nofollow noopener noreferrer" class="mention hashtag" href="https://mastodon.social/tags/Qi" target="_blank">#Qi</a> <a rel="nofollow noopener noreferrer" class="mention hashtag" href="https://mastodon.social/tags/Translation" target="_blank">#Translation</a><br><br><a href="https://awakari.com/pub-msg.html?id=26SRXWhaSV95y7z3YvixNobnuUK" rel="nofollow noopener noreferrer" target="_blank">Event Attributes</a>
PostgreSQLМиграция базы данных Grafana: от внутреннего хранилища к...<br><br><a href="https://habr.com/ru/articles/897400/?utm_source=habrahabr&amp;utm_medium=rss&amp;utm_campaign=897400" rel="nofollow noopener noreferrer" target="_blank">https://habr.com/ru/articles/897400/?utm_source=habrahabr&amp;utm_medium=rss&amp;utm_campaign=897400</a><br><br><a rel="nofollow noopener noreferrer" class="mention hashtag" href="https://mastodon.social/tags/grafana" target="_blank">#grafana</a> <a rel="nofollow noopener noreferrer" class="mention hashtag" href="https://mastodon.social/tags/графана" target="_blank">#графана</a> <a rel="nofollow noopener noreferrer" class="mention hashtag" href="https://mastodon.social/tags/миграция" target="_blank">#миграция</a> <a rel="nofollow noopener noreferrer" class="mention hashtag" href="https://mastodon.social/tags/бд" target="_blank">#бд</a> <a rel="nofollow noopener noreferrer" class="mention hashtag" href="https://mastodon.social/tags/postgres" target="_blank">#postgres</a> <a rel="nofollow noopener noreferrer" class="mention hashtag" href="https://mastodon.social/tags/postgresql" target="_blank">#postgresql</a> <a rel="nofollow noopener noreferrer" class="mention hashtag" href="https://mastodon.social/tags/миграция" target="_blank">#миграция</a> <a rel="nofollow noopener noreferrer" class="mention hashtag" href="https://mastodon.social/tags/данных" target="_blank">#данных</a> <a rel="nofollow noopener noreferrer" class="mention hashtag" href="https://mastodon.social/tags/миграция" target="_blank">#миграция</a> <a rel="nofollow noopener noreferrer" class="mention hashtag" href="https://mastodon.social/tags/бд" target="_blank">#бд</a> <a rel="nofollow noopener noreferrer" class="mention hashtag" href="https://mastodon.social/tags/sqlite" target="_blank">#sqlite</a><br><br><a href="https://awakari.com/pub-msg.html?id=2bdX71AJXSM3MFbKtKDByPr9MHY" rel="nofollow noopener noreferrer" target="_blank">Event Attributes</a>
PostgreSQL Conference Germany<p>Come see Gianni Ciolli talk about "The Well-Tempered Elephant"!</p><p><a href="https://fosstodon.org/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>PostgreSQL</span></a> <a href="https://fosstodon.org/tags/Conference" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Conference</span></a> <a href="https://fosstodon.org/tags/PGConfDE" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>PGConfDE</span></a> <a href="https://fosstodon.org/tags/Berlin" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Berlin</span></a> </p><p><a href="https://www.postgresql.eu/events/pgconfde2025/sessions/session/6575-the-well-tempered-elephant/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://www.</span><span class="ellipsis">postgresql.eu/events/pgconfde2</span><span class="invisible">025/sessions/session/6575-the-well-tempered-elephant/</span></a></p>
Andreas Scherbaum<p>Are you coming to <span class="h-card" translate="no"><a href="https://mastodon.social/@pgconfdev" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@<span>pgconfdev</span></a></span> ? There is a Community Summit on Tuesday before the conference. Sign up now!</p><p><a href="https://2025.pgconf.dev/schedule.html" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="">2025.pgconf.dev/schedule.html</span><span class="invisible"></span></a></p><p><a href="https://mastodon.social/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>PostgreSQL</span></a> <a href="https://mastodon.social/tags/Conference" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Conference</span></a> <a href="https://mastodon.social/tags/PGConfDev" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>PGConfDev</span></a> <a href="https://mastodon.social/tags/Montreal" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Montreal</span></a> <a href="https://mastodon.social/tags/Canada" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Canada</span></a></p>
Andreas Scherbaum<p><span class="h-card" translate="no"><a href="https://mastodon.social/@Serpent7776" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@<span>Serpent7776</span></a></span> It is strict.</p><p>If you don't specify the type, it makes a guess - and uses that, as long as the guess works.</p><p>If you specify a data type, and it doesn't fit, that is the strict you are looking for.</p><p>The '8' you are sending has no data type attached, hence <a href="https://mastodon.social/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>PostgreSQL</span></a> has to guess.</p>
PostgreSQLHAProxy-Patroni Setup Using Health Check Endpoints and Debugging Patroni has a REST API that allo...<br><br><a href="https://www.percona.com/blog/haproxy-patroni-setup-using-health-check-endpoints-and-debugging/" rel="nofollow noopener noreferrer" target="_blank">https://www.percona.com/blog/haproxy-patroni-setup-using-health-check-endpoints-and-debugging/</a><br><br><a rel="nofollow noopener noreferrer" class="mention hashtag" href="https://mastodon.social/tags/Insight" target="_blank">#Insight</a> <a rel="nofollow noopener noreferrer" class="mention hashtag" href="https://mastodon.social/tags/for" target="_blank">#for</a> <a rel="nofollow noopener noreferrer" class="mention hashtag" href="https://mastodon.social/tags/DBAs" target="_blank">#DBAs</a> <a rel="nofollow noopener noreferrer" class="mention hashtag" href="https://mastodon.social/tags/PostgreSQL" target="_blank">#PostgreSQL</a> <a rel="nofollow noopener noreferrer" class="mention hashtag" href="https://mastodon.social/tags/haproxy" target="_blank">#haproxy</a> <a rel="nofollow noopener noreferrer" class="mention hashtag" href="https://mastodon.social/tags/Lalit" target="_blank">#Lalit</a> <a rel="nofollow noopener noreferrer" class="mention hashtag" href="https://mastodon.social/tags/PP" target="_blank">#PP</a> <a rel="nofollow noopener noreferrer" class="mention hashtag" href="https://mastodon.social/tags/Patroni" target="_blank">#Patroni</a><br><br><a href="https://awakari.com/pub-msg.html?id=9MdM0LBp3cFeKwioYMbBNg623Zg" rel="nofollow noopener noreferrer" target="_blank">Event Attributes</a>
Douglas J Hunley<p>Talk Fast: The Speed of Various Collations <a href="https://fosstodon.org/tags/postgresql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>postgresql</span></a> <a href="https://thebuild.com/blog/2024/11/20/talk-fast-the-speed-of-various-collations/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">thebuild.com/blog/2024/11/20/t</span><span class="invisible">alk-fast-the-speed-of-various-collations/</span></a></p>
ExploreLive feeds
About