Mastodon

🦇 thomas 🗺️Professionnellement, je commence doucement à me projeter dans l'après CDD, c'est à dire au printemps-été 2026. J'aimerais aller vers <a href="https://mapstodon.space/tags/ClermontFerrand" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#ClermontFerrand</a> pour me rapprocher de gens que j'aime.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.<a href="https://mapstodon.space/tags/PGSQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#PGSQL</a> <a href="https://mapstodon.space/tags/RStats" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#RStats</a> <a href="https://mapstodon.space/tags/Python" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Python</a> <a href="https://mapstodon.space/tags/Flask" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Flask</a> <a href="https://mapstodon.space/tags/QGIS" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#QGIS</a> <a href="https://mapstodon.space/tags/ecologie" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#ecologie</a> <a href="https://mapstodon.space/tags/leaflet" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#leaflet</a> <a href="https://mapstodon.space/tags/geoserver" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#geoserver</a> <a href="https://mapstodon.space/tags/SIG" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#SIG</a> <a href="https://mapstodon.space/tags/logicielLibre" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#logicielLibre</a>

Ludovic :Firefox: :FreeBSD:Installer Dotclear sur FreeBSD 13 <a href="https://ludovic.hirlimann.net/2023/04/installer-dotclear-sur-freebsd-13.html" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://ludovic.hirlimann.net/2023/04/installer-dotclear-sur-freebsd-13.html</a><a href="https://piaille.fr/tags/dotclear" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#dotclear</a> <a href="https://piaille.fr/tags/pgsql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#pgsql</a> <a href="https://piaille.fr/tags/freebsd" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#freebsd</a>

ferricoxideMy search-fu is either really lacking, today, or nobody bothers to set up <a href="https://evil.social/tags/PGSQL" rel="nofollow noopener noreferrer" target="_blank">#PGSQL</a> users with the _bare-minimum_ permissions necessary to successfully run <code>pg_dump</code> against a specific database?

gyptazyI'm happy to announce that we're <a href="https://mastodon.social/@credativde" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@credativde</a> hosting the 5th <a href="https://mastodon.gyptazy.com/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#PostgreSQL</a> User Group meeting in <a href="https://mastodon.gyptazy.com/tags/NRW" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#NRW</a>, <a href="https://mastodon.gyptazy.com/tags/M%C3%B6nchengladbach" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Mönchengladbach</a>. If you're into <a href="https://mastodon.gyptazy.com/tags/opensource" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#opensource</a>, <a href="https://mastodon.gyptazy.com/tags/databases" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#databases</a> & <a href="https://mastodon.gyptazy.com/tags/PGSQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#PGSQL</a> - we're happy to see you :-)Date: 2025-06-03 SignUp: <a href="https://www.meetup.com/postgresql-user-group-nrw/events/307792609/" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://www.meetup.com/postgresql-user-group-nrw/events/307792609/</a>

Adam ThompsonHey 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. (Why: ".ip6.arpa", sadly. I'm doing DNS work.)Exporting to a file and running a standalone utility is _not_ a viable solution in this scenario.Feel free to boost for visibility.<a href="https://bsd.network/tags/pg" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#pg</a> <a href="https://bsd.network/tags/pgsql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#pgsql</a> <a href="https://bsd.network/tags/postgres" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#postgres</a> <a href="https://bsd.network/tags/ipv6" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#ipv6</a>

Esparta :ruby:Top Five <a href="https://ruby.social/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#PostgreSQL</a> Surprises from <a href="https://ruby.social/tags/Rails" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Rails</a> Developers, by Andrew Atkinson <a href="https://medium.com/pragmatic-programmers/top-five-postgresql-surprises-from-rails-developers-36d2b8734909" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://medium.com/pragmatic-programmers/top-five-postgresql-surprises-from-rails-developers-36d2b8734909</a>1. Covering indexes and how to use them2. PostgreSQL data storage in pages and the relationship to query performance3. Topics related to storing and accessing ordered data4. Why SELECT * is not optimal, and how to enumerate all table columns in queries to help spot opportunities to reduce the columns5.Using PostgreSQL for more types of work<a href="https://ruby.social/tags/ruby" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#ruby</a> <a href="https://ruby.social/tags/RoR" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#RoR</a> <a href="https://ruby.social/tags/PgSQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#PgSQL</a>

Jakob Miksch<a href="https://mastodon.social/tags/osm2pgsql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#osm2pgsql</a> - the power tool to import <a href="https://mastodon.social/tags/osm" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#osm</a> data into <a href="https://mastodon.social/tags/postgis" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#postgis</a> - released version 2.0.0 Breaking change: <a href="https://mastodon.social/tags/Lua" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Lua</a> configuration becomes default and classic <a href="https://mastodon.social/tags/pgsql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#pgsql</a> output is deprecated <a href="https://mastodon.social/tags/openstreetmap" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#openstreetmap</a> <a href="https://mastodon.social/tags/postgres" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#postgres</a> <a href="https://mastodon.social/tags/postgresql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#postgresql</a> <a href="https://mastodon.social/tags/sql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#sql</a> <a href="https://osm2pgsql.org/news/2024/09/19/release-2.0.0.html" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://osm2pgsql.org/news/2024/09/19/release-2.0.0.html</a>

gyptazyI must admit that I have used Veeam the last time back in the days when I created a vCloud product at a hosting company with ESXi 3 if I remember correctly. Was happy to see that it was still pretty straight forward and also happy to see the <a href="https://gyptazy.ch/snac?t=pgsql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#PGSQL</a> integration. I can't say anything regarding Avamar, never used it :)

Zergy :verified: :redpanda:Hello PostgreSQL experts. :rp_wave: PGHero tell me I have unused indexes in my databses. :rp_trash: Can I safely remove them? :rp_thinking: Exemple with the “index_pghero_space_stats_on_database_and_captured_at” index:<a href="https://mastodon.zergy.net/tags/PGSQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#PGSQL</a> <a href="https://mastodon.zergy.net/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#PostgreSQL</a> <a href="https://mastodon.zergy.net/tags/Database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Database</a>

the_halmaturusNeed some help to get a PHP / Postgresql thing fixed. I am running on debian 12 and have installed postgresql, php and pdo psql. Additionally I created the needed user and database for ulogger. I can connect with the user / pw with dbeaver and see the empty db. Unfortunately PHP does not believe it can handle the Postgresql DB and claims in the Error message: "could not find driver" Packages installed are: • apt install postgresql • apt install php • apt install php-json • apt install php-fpm/stable • apt install php-pgsql/stable • apt install postgresql postgresql-client Any idea what I could have done wrong or which step is missed? Thanks in advance, for any help on this question. :boosts_ok: <a href="https://firefish.xprmnt42.de/tags/ulogger" rel="nofollow noopener noreferrer" target="_blank">#ulogger</a> <a href="https://firefish.xprmnt42.de/tags/php" rel="nofollow noopener noreferrer" target="_blank">#php</a> <a href="https://firefish.xprmnt42.de/tags/postgresql" rel="nofollow noopener noreferrer" target="_blank">#postgresql</a> <a href="https://firefish.xprmnt42.de/tags/pgsql" rel="nofollow noopener noreferrer" target="_blank">#pgsql</a> <a href="https://firefish.xprmnt42.de/tags/helpneeded" rel="nofollow noopener noreferrer" target="_blank">#helpneeded</a>

Elan HassonHad a great first experience with <a href="https://publicsquare.global/tags/CloudNativePG" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#CloudNativePG</a>!<a href="https://publicsquare.global/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#PostgreSQL</a> <a href="https://publicsquare.global/tags/PGSQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#PGSQL</a> <a href="https://cloudnative-pg.io/" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://cloudnative-pg.io/</a>

Mike ElstonI know my Dunning Kruger effect is high on this. But why hasnt someone built a MSSQL to PGSQL so you could replace MSSQL with PGSQL and client apps would be none the wiser. (im talking basic queries, not all features) <a href="https://kzoo.to/tags/dev" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#dev</a> <a href="https://kzoo.to/tags/mssql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#mssql</a> <a href="https://kzoo.to/tags/pgsql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#pgsql</a>

ngoomie :important_guy: :genderqueer_paw:does anyone know if there's a way to have postgres save different DBs to different locations? it's not a thing i need right now, but i've come 🤏 this close to needing to install other pgsql stuff on my server, and i'd prefer atm to keep my storage drive that has my akkoma DB to be literally just akkoma stuff when i've looked this information up before i've just found information on moving your whole pgsql data directory, which i already know how to do :do_boost: <a class="hashtag" href="https://pl.hyperboreal.zone/tag/postgresql" rel="nofollow noopener noreferrer" target="_blank">#postgreSQL</a> <a class="hashtag" href="https://pl.hyperboreal.zone/tag/postgres" rel="nofollow noopener noreferrer" target="_blank">#postgres</a> <a class="hashtag" href="https://pl.hyperboreal.zone/tag/pgsql" rel="nofollow noopener noreferrer" target="_blank">#pgsql</a> <a class="hashtag" href="https://pl.hyperboreal.zone/tag/sysadmin" rel="nofollow noopener noreferrer" target="_blank">#sysadmin</a>

deltatuxJust migrated my <a class="hashtag" href="https://tuxz.one/tag/akkoma" rel="nofollow noopener noreferrer" target="_blank">#Akkoma</a> instance over to <a class="hashtag" href="https://tuxz.one/tag/oraclecloud" rel="nofollow noopener noreferrer" target="_blank">#OracleCloud</a> after moving my projects around. Took nearly 4 hours to restore my <a class="hashtag" href="https://tuxz.one/tag/postgresql" rel="nofollow noopener noreferrer" target="_blank">#PostgreSQL</a> <a class="hashtag" href="https://tuxz.one/tag/database" rel="nofollow noopener noreferrer" target="_blank">#database</a> from my <a class="hashtag" href="https://tuxz.one/tag/pgdump" rel="nofollow noopener noreferrer" target="_blank">#pgdump</a> as the number of posts have gone up considerably for the past month. Would this eventually mean in the future it could take a day to restore a <a class="hashtag" href="https://tuxz.one/tag/pgsql" rel="nofollow noopener noreferrer" target="_blank">#pgsql</a> database? I sure hope not 😕... <a class="hashtag" href="https://tuxz.one/tag/fediadmin" rel="nofollow noopener noreferrer" target="_blank">#fediadmin</a>

Jared 🇦🇺🏳️‍🌈⚧️👽<a href="https://cloudisland.nz/@aurynn" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@aurynn</a> <a href="https://cloudisland.nz/@xssfox" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@xssfox</a> <a href="https://mastodon.nz/@thomasbeagle" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@thomasbeagle</a> <a href="https://social.artemai.art/@artemai" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@artemai</a> both my <a href="https://social.artemai.art/tags/pixelfed" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#pixelfed</a> and <a href="https://social.artemai.art/tags/mastodon" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#mastodon</a> instances are docker-compose + env file; <a href="https://social.artemai.art/tags/pgsql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#pgsql</a> is on a separate cluster. Not sharing <a href="https://social.artemai.art/tags/redis" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#redis</a> currently (sometime soon). Rest of our cluster is <a href="https://social.artemai.art/tags/rtx3080s" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#rtx3080s</a> from a mining rig we aquired for <a href="https://social.artemai.art/tags/ml" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#ml</a> inference.

blubSehr interessante Folge zu <a href="https://norden.social/tags/Datenbanken" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Datenbanken</a> allgemein und sprachunabhängig. Viel gelernt.<a href="https://python-podcast.de/show/PostgreSQL-und-MariaDB/" rel="nofollow noopener noreferrer" target="_blank">https://python-podcast.de/show/PostgreSQL-und-MariaDB/</a><a href="https://norden.social/tags/postgres" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#postgres</a> <a href="https://norden.social/tags/pgsql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#pgsql</a> <a href="https://norden.social/tags/mariadb" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#mariadb</a> <a href="https://norden.social/tags/mysql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#mysql</a> <a href="https://norden.social/tags/sql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#sql</a> <a href="https://norden.social/tags/dbms" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#dbms</a> <a href="https://norden.social/tags/nosql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#nosql</a> <a href="https://norden.social/tags/c" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#c</a> <a href="https://norden.social/tags/cpp" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#cpp</a> <a href="https://norden.social/tags/podcast" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#podcast</a>

Ludovic Hirlimannça vaut quoi <a href="https://docs.postgresql.fr/10/app-vacuumdb.html" rel="nofollow noopener noreferrer" target="_blank">https://docs.postgresql.fr/10/app-vacuumdb.html</a> ? <a href="https://mamot.fr/tags/noob" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#noob</a> <a href="https://mamot.fr/tags/pgsql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#pgsql</a>

SoosyzeJe viens de découvrir Devilbox 😈 , une pile dockerized pour faciliter le développement en <a href="https://mamot.fr/tags/PHP" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#PHP</a>.<a href="http://devilbox.org/" rel="nofollow noopener noreferrer" target="_blank">http://devilbox.org/</a>Il prend en charge <a href="https://mamot.fr/tags/apache" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#apache</a> <a href="https://mamot.fr/tags/nginx" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#nginx</a> <a href="https://mamot.fr/tags/mysql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#mysql</a> <a href="https://mamot.fr/tags/mariadb" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#mariadb</a> <a href="https://mamot.fr/tags/perconadb" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#perconadb</a> <a href="https://mamot.fr/tags/PgSQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#PgSQL</a> <a href="https://mamot.fr/tags/redis" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#redis</a> <a href="https://mamot.fr/tags/memcached" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#memcached</a> et <a href="https://mamot.fr/tags/mongodb" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#mongodb</a> ...Franchement bien sympa comme projet 😀

adi 🖥️⌨️🔐📷⛺📡🛰📻Did anyone experienced slow connection <a href="https://mastodon.xyz/tags/javascript" class="mention hashtag" rel="tag">#javascript</a> to <a href="https://mastodon.xyz/tags/php" class="mention hashtag" rel="tag">#php</a> to <a href="https://mastodon.xyz/tags/posrgresql" class="mention hashtag" rel="tag">#posrgresql</a>. It takes up to 5sec to respond post request and I know it's not the <a href="https://mastodon.xyz/tags/pgsql" class="mention hashtag" rel="tag">#pgsql</a> because the same query on <a href="https://mastodon.xyz/tags/pgadmin" class="mention hashtag" rel="tag">#pgadmin</a> takes 120ms

Ludovic HirlimannWondering if <a href="https://www.postgresql.org/docs/8.3/textsearch.html" rel="nofollow noopener noreferrer" target="_blank">https://www.postgresql.org/docs/8.3/textsearch.html</a> is used in @dotclear when pg is used for the backend. Didn't find anything in the source. <a href="https://mamot.fr/tags/dotclear" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#dotclear</a> <a href="https://mamot.fr/tags/pgsql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#pgsql</a>

Recent searches

Search options

Administered by:

Server stats:

#pgsql