mastodontech.de ist einer von vielen unabhängigen Mastodon-Servern, mit dem du dich im Fediverse beteiligen kannst.
Offen für alle (über 16) und bereitgestellt von Markus'Blog

Serverstatistik:

1,4 Tsd.
aktive Profile

#pgsql

0 Beiträge0 Beteiligte0 Beiträge heute
🦇 thomas 🗺️<p>Professionnellement, je commence doucement à me projeter dans l'après CDD, c'est à dire au printemps-été 2026. <br>J'aimerais aller vers <a href="https://mapstodon.space/tags/ClermontFerrand" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>ClermontFerrand</span></a> pour me rapprocher de gens que j'aime.</p><p>Donc si vous êtes dans un service public, une association ou une SCOP du coin qui recherche ou est susceptible de chercher un géomaticien, n'hésitez pas à me faire signe.</p><p><a href="https://mapstodon.space/tags/PGSQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>PGSQL</span></a> <a href="https://mapstodon.space/tags/RStats" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>RStats</span></a> <a href="https://mapstodon.space/tags/Python" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Python</span></a> <a href="https://mapstodon.space/tags/Flask" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Flask</span></a> <a href="https://mapstodon.space/tags/QGIS" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>QGIS</span></a> <a href="https://mapstodon.space/tags/ecologie" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>ecologie</span></a> <a href="https://mapstodon.space/tags/leaflet" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>leaflet</span></a> <a href="https://mapstodon.space/tags/geoserver" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>geoserver</span></a> <a href="https://mapstodon.space/tags/SIG" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>SIG</span></a> <a href="https://mapstodon.space/tags/logicielLibre" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>logicielLibre</span></a></p>
ferricoxide<p><span>My search-fu is either really lacking, today, or nobody bothers to set up </span><a href="https://evil.social/tags/PGSQL" rel="nofollow noopener" target="_blank">#PGSQL</a><span> users with the _bare-minimum_ permissions necessary to successfully run </span><code>pg_dump</code><span> against a specific database?</span></p>
gyptazy<p>I'm happy to announce that we're <span class="h-card" translate="no"><a href="https://mastodon.social/@credativde" class="u-url mention" rel="nofollow noopener" target="_blank">@<span>credativde</span></a></span> hosting the 5th <a href="https://mastodon.gyptazy.com/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>PostgreSQL</span></a> User Group meeting in <a href="https://mastodon.gyptazy.com/tags/NRW" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>NRW</span></a>, <a href="https://mastodon.gyptazy.com/tags/M%C3%B6nchengladbach" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Mönchengladbach</span></a>. </p><p>If you're into <a href="https://mastodon.gyptazy.com/tags/opensource" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>opensource</span></a>, <a href="https://mastodon.gyptazy.com/tags/databases" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>databases</span></a> &amp; <a href="https://mastodon.gyptazy.com/tags/PGSQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>PGSQL</span></a> - we're happy to see you :-)</p><p>Date: 2025-06-03<br>SignUp: <a href="https://www.meetup.com/postgresql-user-group-nrw/events/307792609/" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://www.</span><span class="ellipsis">meetup.com/postgresql-user-gro</span><span class="invisible">up-nrw/events/307792609/</span></a></p>
Adam Thompson<p>Hey PostgreSQL users, is there a way to get the *expanded* IPv6 text representation of a v6 inet or cidr data type? Pg does a lovely job of compressing it correctly, but I need it uncompressed.<br>(Why: ".ip6.arpa", sadly. I'm doing DNS work.)</p><p>Exporting to a file and running a standalone utility is _not_ a viable solution in this scenario.</p><p>Feel free to boost for visibility.</p><p><a href="https://bsd.network/tags/pg" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>pg</span></a> <a href="https://bsd.network/tags/pgsql" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>pgsql</span></a> <a href="https://bsd.network/tags/postgres" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>postgres</span></a> <a href="https://bsd.network/tags/ipv6" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>ipv6</span></a></p>
Esparta :ruby:<p>Top Five <a href="https://ruby.social/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>PostgreSQL</span></a> Surprises from <a href="https://ruby.social/tags/Rails" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Rails</span></a> Developers, by Andrew Atkinson<br><a href="https://medium.com/pragmatic-programmers/top-five-postgresql-surprises-from-rails-developers-36d2b8734909" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">medium.com/pragmatic-programme</span><span class="invisible">rs/top-five-postgresql-surprises-from-rails-developers-36d2b8734909</span></a></p><p>1. Covering indexes and how to use them</p><p>2. PostgreSQL data storage in pages and the relationship to query performance</p><p>3. Topics related to storing and accessing ordered data</p><p>4. Why SELECT * is not optimal, and how to enumerate all table columns in queries to help spot opportunities to reduce the columns</p><p>5.Using PostgreSQL for more types of work</p><p><a href="https://ruby.social/tags/ruby" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>ruby</span></a> <a href="https://ruby.social/tags/RoR" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>RoR</span></a> <a href="https://ruby.social/tags/PgSQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>PgSQL</span></a></p>
Jakob Miksch<p><a href="https://mastodon.social/tags/osm2pgsql" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>osm2pgsql</span></a> - the power tool to import <a href="https://mastodon.social/tags/osm" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>osm</span></a> data into <a href="https://mastodon.social/tags/postgis" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>postgis</span></a> - released version 2.0.0<br>Breaking change: <a href="https://mastodon.social/tags/Lua" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Lua</span></a> configuration becomes default and classic <a href="https://mastodon.social/tags/pgsql" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>pgsql</span></a> output is deprecated <br><a href="https://mastodon.social/tags/openstreetmap" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>openstreetmap</span></a> <a href="https://mastodon.social/tags/postgres" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>postgres</span></a> <a href="https://mastodon.social/tags/postgresql" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>postgresql</span></a> <a href="https://mastodon.social/tags/sql" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>sql</span></a> </p><p><a href="https://osm2pgsql.org/news/2024/09/19/release-2.0.0.html" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">osm2pgsql.org/news/2024/09/19/</span><span class="invisible">release-2.0.0.html</span></a></p>
Zergy :verified: :redpanda:<p>Hello PostgreSQL experts. :rp_wave: </p><p>PGHero tell me I have unused indexes in my databses. :rp_trash: <br>Can I safely remove them? :rp_thinking: </p><p>Exemple with the “index_pghero_space_stats_on_database_and_captured_at” index:</p><p><a href="https://mastodon.zergy.net/tags/PGSQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>PGSQL</span></a> <a href="https://mastodon.zergy.net/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>PostgreSQL</span></a> <a href="https://mastodon.zergy.net/tags/Database" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Database</span></a></p>
the_halmaturus<p><span>Need some help to get a PHP / Postgresql thing fixed.<br><br>I am running on debian 12 and have installed postgresql, php and pdo psql. Additionally I created the needed user and database for ulogger.<br><br>I can connect with the user / pw with dbeaver and see the empty db.<br><br>Unfortunately PHP does not believe it can handle the Postgresql DB and claims in the Error message: "could not find driver"<br><br>Packages installed are:<br>• apt install postgresql <br>• apt install php<br>• apt install php-json<br>• apt install php-fpm/stable<br>• apt install php-pgsql/stable<br>• apt install postgresql postgresql-client<br><br>Any idea what I could have done wrong or which step is missed?<br><br>Thanks in advance, for any help on this question.<br><br></span>​:boosts_ok:​<span><br><br></span><a href="https://firefish.xprmnt42.de/tags/ulogger" rel="nofollow noopener" target="_blank">#ulogger</a><span> </span><a href="https://firefish.xprmnt42.de/tags/php" rel="nofollow noopener" target="_blank">#php</a><span> </span><a href="https://firefish.xprmnt42.de/tags/postgresql" rel="nofollow noopener" target="_blank">#postgresql</a><span> </span><a href="https://firefish.xprmnt42.de/tags/pgsql" rel="nofollow noopener" target="_blank">#pgsql</a><span> </span><a href="https://firefish.xprmnt42.de/tags/helpneeded" rel="nofollow noopener" target="_blank">#helpneeded</a></p>
Elan Hasson<p>Had a great first experience with <a href="https://publicsquare.global/tags/CloudNativePG" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>CloudNativePG</span></a>!</p><p><a href="https://publicsquare.global/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>PostgreSQL</span></a> <a href="https://publicsquare.global/tags/PGSQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>PGSQL</span></a><br><a href="https://cloudnative-pg.io/" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="">cloudnative-pg.io/</span><span class="invisible"></span></a></p>