#postgresql
[ Google Cloud’s AlloyDB Omni lets you run its PostgreSQL-compatible database anywhere | TechCrunch ]
https://techcrunch.com/2023/03/29/google-cloud-launches-alloydb-omni-a-downloadable-version-of-its-postgresql-compatible-database/ #AlloyDB #PostgreSQL #Google
Google ambushes on-prem PostgreSQL with AlloyDB Omni - Google is developing a self-managed and downloadable version of its PostgreSQL-compati... - https://www.infoworld.com/article/3691825/google-ambushes-on-prem-postgresql-with-alloydb-omni.html#tk.rss_all #relationaldatabases #postgresql
Google ambushes on-prem PostgreSQL with AlloyDB Omni
Check it out! 👇
https://www.infoworld.com/article/3691825/google-ambushes-on-prem-postgresql-with-alloydb-omni.html#tk.rss_all
Hayato Kuroda: Using postgres_fdw.parameter_name for advanced monitoring with multiple PostgreSQL servers https://www.postgresql.fastware.com/blog/new-connection-setting-for-advanced-monitoring
#postgres #postgresql
#PostgreSQL Patch of Interest (To Me): Documentation Linking https://www.softwareandbooz.com/ppi-documentation-linking/
My product team at Google just released a downloadable edition of #AlloyDB, its #PostgreSQL-compatible database engine loaded with lots of neat features like an index advisor and a columnar engine and so on and suchlike.
It's in preview! You can install it on any newish RHEL or Debian-like and try it out for free.
https://cloud.google.com/blog/products/databases/run-alloydb-anywhere
I co-authored the docs, by gar.
Google offers modernization path for PostgreSQL with on-premises AlloyDB Omni - Google is developing a self-managed and downloadable version of its PostgreSQL-compati... - https://www.infoworld.com/article/3691825/google-offers-modernization-path-for-postgresql-with-on-premises-alloydb-omni.html#tk.rss_all #relationaldatabases #postgresql
Something to know about #AlloyDBOmni, it's a drop-in replacement for #PostgreSQL! It's 2x faster than out-of-the box PG, and up to 100x faster for analytic queries. Instead of grabbing PG, just grab AlloyDB Omni!
#Google Cloud launches AlloyDB Omni, a downloadable version of its PostgreSQL-compatible database
Google offers modernization path for PostgreSQL with on-premises AlloyDB Omni
Check it out! 👇
https://www.infoworld.com/article/3691825/google-offers-modernization-path-for-postgresql-with-on-premises-alloydb-omni.html#tk.rss_all
Inside logical replication in #PostgreSQL: How it works https://www.postgresql.fastware.com/blog/inside-logical-replication-in-postgresql
Ryan Booz (@ryanbooz ): The Cognitive Load of Licensing https://www.softwareandbooz.com/the-cognitive-load-of-licensing/
#postgres #postgresql
Michael Paquier: Postgres 16 highlight - File inclusions in pg_hba.conf and pg_ident.conf https://paquier.xyz/postgresql-2/postgres-16-hba-ident-include/
#postgres #postgresql
Want to connect to a Google Cloud SQL PostgreSQL instance with a service account?
Sad that .NET isn't supported?
No worries, I got you:
https://esg.dev/posts/using-gcp-iam-with-pgsql/
#Postgres 15 highlight - Custom WAL Resource Managers https://paquier.xyz/postgresql-2/postgres-15-custom-rmgr/ #postgresql
Craig Kerstiens: Is your Postgres ready for production? https://www.crunchydata.com/blog/is-your-postgres-ready-for-production
#postgres #postgresql
#til #postgresql can prevent overlapping time ranges for things like representing booking times without any application code.
System roles – what, why, how? – select * from depesz; https://www.depesz.com/2023/03/14/system-roles-what-why-how/ #postgresql
Best #postgresql website I know of https://pgtune.leopard.in.ua/
Pavlo Golub: New old “debug_parallel_query” setting in PostgreSQL 16 https://www.cybertec-postgresql.com/en/debug_parallel_query-setting-postgresql-16/
#postgres #postgresql
Andreas 'ads' Scherbaum (@ascherbaum): Chris Ellis https://postgresql.life/post/chris_ellis/
#postgres #postgresql
PostgreSQL Person of the Week interview with: Chris Ellis (@intrbiz)
#PostgreSQL #PostgresFriends
https://postgresql.life/post/chris_ellis/
Join our team, lead by the great @edarchis to work on THE open source solution for health insurance, openIMIS, used more and more across the world.
https://www.bluesquarehub.com/blog/vacancies/backend-developer-2/
I would totally apply for that job if I was not already working there :-)
Binance is hiring Backend Engineer (Golang/Rust)
🔧 #dapp #golang #node #postgresql #rust #sql #python #graphql #blockchain #web3 #aws #azure #docker #gcp #kubernetes #mongodb #redis
🌎 Remote; Asia
⏰ Full-time
💰 $100k - $205k (Estimate)
🏢 Binance
Job details https://jobsfordevelopers.com/jobs/backend-engineer-golang-rust-at-binance-aug-23-2022-a7b438?utm_source=mastodon.world&ref=mastodon.world
#jobalert #jobsearch #hiring
Bad CHECK constraints in #PostgreSQL - CYBERTEC https://www.cybertec-postgresql.com/en/bad-check-constraints-postgresql/
Interview with: Vincent Picavet | #PostgreSQL Person of the Week https://postgresql.life/post/vincent_picavet/
#Lldap v0.4.2 released, adds support for #MySQL , #MariaDB and #PostgreSQL



It’s time for the release roundup; this time, it’s an extensive list!
We've updated Percona Monitoring and Management 2.36, Percona Distributions, Percona Servers, and Percona Backups for #PostgreSQL, #MySQL, and #MongoDB! I'm proud of the teams that helped accomplishing these releases.
DoorDash is hiring Software Engineer - Databases and Messaging
🔧 #kafka #postgresql #redis
🌎 Remote; United States
⏰ Full-time
💰 $136k - $182k
🏢 DoorDash
Job details https://jobsfordevelopers.com/jobs/software-engineer-databases-and-messaging-at-doordash-nov-22-2022-4df68a?utm_source=mastodon.world&ref=mastodon.world
#jobalert #jobsearch #hiring
Jeremy Schneider: Did Postgres Lose My Data? https://ardentperf.com/2023/03/26/did-postgres-lose-my-data/
#postgres #postgresql
DoorDash is hiring Data Engineer
🔧 #python #aws #druid #gcp #postgresql #sql
🌎 Atlanta, United States; Austin, United States; Chicago, United States; Los Angeles, United States; New York City, United States; Pittsburgh, United States; San Francisco, United States; Seattle, United States; Washington D.C., United States
⏰ Full-time
💰 $90k - $230k (Estimate)
🏢 DoorDash
Job details https://jobsfordevelopers.com/jobs/data-engineer-at-doordash-nov-22-2022-18f6c2?utm_source=mastodon.world&ref=mastodon.world
#jobalert #jobsearch #hiring
DoorDash is hiring Software Engineer - Storage Infrastructure
🔧 #golang #kotlin #python #kafka #postgresql #redis
🌎 Remote; United States
⏰ Full-time
💰 $136k - $182k
🏢 DoorDash
Job details https://jobsfordevelopers.com/jobs/software-engineer-storage-infrastructure-at-doordash-nov-22-2022-1b0cb9?utm_source=mastodon.world&ref=mastodon.world
#jobalert #jobsearch #hiring
The long overdue release of pg_chameleon is now out.
Check the release notes for the bugfixes and improvements
https://github.com/the4thdoctor/pg_chameleon/releases/tag/v2.0.19
#mysql #mariadb #postgresql #python #replica #migration #pgchameleon
DoorDash is hiring BI Engineer
🔧 #java #python #postgresql #sql
🌎 New York City, United States; San Francisco, United States; Seattle, United States
⏰ Full-time
💰 $90k - $225k (Estimate)
🏢 DoorDash
Job details https://jobsfordevelopers.com/jobs/bi-engineer-at-doordash-nov-22-2022-f5dc66?utm_source=mastodon.world&ref=mastodon.world
#jobalert #jobsearch #hiring
Remember this?
So it was a freaking lie.
This time, #Sidekiq ate so much RAM, system decided to kill #PostgreSQL. That wouldn't have surprised me, if it wasn't a VM with 4 gigs of memory, while the most resource-intensive service running there (besides Mastodon) is a barely used #Discord #bot written in #Python.
I reduced Sidekiq processes count to 16 (from 25), and will monitor the situation.
WalletConnect is hiring Full-Stack Javascript Engineer
🔧 #javascript #typescript #react #blockchain #cryptocurrency #web3 #aws #postgresql
🌎 Remote; New York, United States
⏰ Full-time
💰 $90k - $210k (Estimate)
🏢 WalletConnect
Job details https://jobsfordevelopers.com/jobs/full-stack-javascript-engineer-at-walletconnect-com-aug-3-2022-34b88a?utm_source=mastodon.world&ref=mastodon.world
#jobalert #jobsearch #hiring
DoorDash is hiring Software Engineer - Databases and Messaging
🔧 #kafka #postgresql #redis
🌎 Remote; United States
⏰ Full-time
💰 $136k - $182k
🏢 DoorDash
Job details https://jobsfordevelopers.com/jobs/software-engineer-databases-and-messaging-at-doordash-nov-22-2022-4df68a?utm_source=mastodon.world&ref=mastodon.world
#jobalert #jobsearch #hiring
David Z: Setup an all-in-one Ceph Storage Cluster on one machine https://www.highgo.ca/2023/03/24/setup-an-all-in-one-ceph-storage-cluster-on-one-machine/
#postgres #postgresql
Leute...ich bin der Verzweiflung nahe. 😭
Welcher FILE_TYPE ist denn für #postgresql der richtige? Wo schlägt man sowas nach?
Ich habe ein cgi-bin Verzeichnis, wo Apache ein Perl Skript liest und ausliefert.
Im Webformular wird eine Datei hochgeladen.
Und im Verzeichnis /var/lib/postgresql/incoming kann der User postgres nicht zugreifen.
Die ACL sind richtig gesetzt aber #SELINUX fehlt noch was. 🙈
Ziehe die Seite von Debian zu CentOS um. Daher das SELinux. 🙈


![[root@popreport2 ~]# getfacl /home/popreport/production/popreport/www/cgi-bin/entry.pl /var/lib/postgresql/incoming/
getfacl: Removing leading '/' from absolute path names
# file: home/popreport/production/popreport/www/cgi-bin/entry.pl
# owner: popreport
# group: apache
user::rwx
group::rwx
other::---
# file: var/lib/postgresql/incoming/
# owner: apache
# group: popreport
user::rwx
group::r-x
other::r-x](https://assets.toot.cafe/cache/media_attachments/files/110/079/163/240/708/376/small/572d37ffd900bedf.png)
New episode: “psql vs GUIs”
This week we discuss command line and graphical user interfaces for Postgres — what they are, some tips and tricks for learning, and what we each use and prefer.
🎙️ https://postgres.fm/episodes/psql-vs-guis

We are excited to welcome @EDBPostgres as a Platinum sponsor of pgconf.de 2023. We could not run this event without our sponsors. #postgresql #pgconfde
Patroni 3.0 & Citus: Scalable, Highly Available #Postgres https://www.citusdata.com/blog/2023/03/06/patroni-3-0-and-citus-scalable-ha-postgres/ #postgresql
F-ing finally. ⚡ 🥫
Some production setbacks doing this one. Wifi interference destroying some of the audio. Lots of reshooting. Thumbnail is 💯
I think the demo and concept is really good and I hope you check it out if you are interested in #sqlite and/or #postgresql :) It do both.
Thanks to @electric for sponsoring my shenanigans.
https://www.youtube.com/watch?v=_U5Z8AQy0hc
#myelixirstatus
Hey #PostgreSQL peeps - what is the best "fully loaded" #Postgres container available right now.
I want extensions like PostGIS and pl/python or pl/r already in the container image.
Looking to use it local app development, NOT in kube.
I maintained one when I was at #CrunchyData but I think they no longer maintain it and I can't find it in DockerHub.
@lenzgr
Three more uniquely valuable reasons to use #PostgreSQL:
1. It supports multiple pathways between tables, including converging relationships;
2. Creating custom data types and custom aggregate functions is easy;
3. The #PostGIS package provides a rich set of tools for storing and working with geospatial data.
#PostgreSQL stands out as one of the most popular databases due to its scalability, reliability, flexibility, security, and community support. Here are some reasons why it is a top choice for enterprise-level databases.
#OpenSource #Databases #Percona
https://www.percona.com/blog/why-postgresql-is-a-top-choice-for-enterprise-level-databases/
Everyone is tapping each other on the back on how good the #PostgreSQL documentation is. @mereteresa has some other opinions and there are ways to improve it. It's extensive but lacks tutorials, easier ways to navigate... for example.

Copying Rows Between #PostgreSQL Databases | End Point Dev https://www.endpointdev.com/blog/2013/11/copying-rows-between-postgresql/
`TrigramSimilarity` in #django is pretty rad, but I wonder if enough people know about it?
https://old.reddit.com/r/django/comments/11ul1er/what_is_the_best_way_to_match_partial_words_while/ has a lot of other random solutions which seem a lot more complicated (unless you aren't using #postgresql, I suppose).
https://docs.djangoproject.com/en/4.1/ref/contrib/postgres/search/#trigram-similarity gives a short example, but I maybe a longer article would be useful?
@rafaelcaricio Okay, Software Names really went out of control...
#Backie makes sense for a #backend service and #PostgreSQL is just the #Postgres #SQL database but WTH is #Tokio and #Diesel?
#PostgreSQL with #EDN support would be huge!
Isn't this the cutest logo ever? :blobcatheart:
It was created by a real artist (not AI generated) for my new project, Backie.
Backie is a background task processing crate for Rust applications with Tokio, Diesel, and PostgreSQL.

redteamers take note, if your c2 can't handle moving whole directories very well.
usually works like a champ in places where they don't look at the network stack much or at all, or employs folks who openly say networking doesnt matter
Amazon Aurora PostgreSQL Adds Write-Through Cache to Improve Logical Replication Performance
https://www.infoq.com/news/2023/03/aws-aurora-write-through-cache/
PostgreSQL Logical Replication Explained
Link: https://www.postgresql.fastware.com/blog/inside-logical-replication-in-postgresql
Discussion: https://news.ycombinator.com/item?id=35203571
I'll be speaking on April 18th at #CitusCon about deploying PostgreSQL to Azure using infrastructure-as-code.
https://www.citusdata.com/cituscon/2023/schedule/#am-session-fox
Let me know ahead of time if you have questions I should answer. I deploy a lot of PG, but am not a PG expert myself. Looking forward to learning more #Postgresql from all the other talks!

Plato - “Airtable for your database” https://www.plato.io/
Plato lets you access your #PostgreSQL or #MySQL database with a UI that feels like Airtable. It’s smooth and delightful to use.
The target audience here seems to be ops teams and customer support, etc anyone that needs easy access to database records (not otherwise available, ad-hoc changes, etc).
(I have a couple of projects where we synced #RDBMS with Airtable, wish I didn’t have to write that code)

@mariusor @steve @helge @Mastodon @obale @fsf Yes, of course!
I don't understand why standards are always afflicted by this notion that generic interoperable implementations aren't possible.
Eons ago, we (@openlink) started this journey with #ODBC; where similar sentiments where echoed. Today, @Mastodon is hard-wired to #PostgreSQL which is a fundamental architectural flaw -- despite it said #DBMS being #OpenSource.
Similar issues play out with other standards, unfortunately.
Ever wonder what it's like being a software consultant? One of the projects I'm most proud of was when a client needed their system to scale from 39 transactions per second to 500+.
The catch: we had two weeks to do it.
Updated: Quick Reference Commands
Added 2 new knowledge base articles
https://www.adamsdesk.com/posts/quick-reference-commands/
#linux #sql #mysql #postgresql #AlpineLinux #git #docker #sqlite #ArchLinux #fedora #pihole #regex
Paul Ramsey (@pwramsey): Easy PostgreSQL Time Bins https://www.crunchydata.com/blog/easy-postgresql-time-bins
#postgres #postgresql
I just gave my talk "Django with PostgreSQL superpowers" during the third day of the Python Web Conf 2023 organized by SixFeetUp 🎉
Thanks to Laura Stephens for assisting me during the talk 🙏
Find all the information about my talk and also the slides on my website 👇
https://www.paulox.net/2023/03/15/python-web-conf-2023/




Things DBs Don't Do - But Should
https://www.thenile.dev/blog/things-dbs-dont-do
Discussions: https://discu.eu/q/https://www.thenile.dev/blog/things-dbs-dont-do
Read the #pgDayParis speaker interview with Magali Milbergue (@MagaliMilbergue)
#PostgreSQL #Conference #Paris
https://2023.pgday.paris/speaker-interviews/magali_milbergue/
I'm impressed by how fast #digitalocean managed #postgresql can upgrade from 14 to 15. It seemed to take a few seconds for a 200GB DB. I'm not paying for fail-over replicas. How is that possible? I thought that kind of quick cut-over required a slow replication process. Perhaps there is a secret replica behind the scenes. Why can't #aws RDS do this?
I'm upping my #Postgresql knowledge thanks to some great talks by Louise Grandjoc:
Today Roji released #Npgsql 8.0.0-preview.1.
At the moment there are not many visible features added but Nikita, Nino and also Shay have have been hacking away with native AOT and reducing Npgsql's binary size, so if you're using AOT and care about binary size, it's probably worth to have some initial look at it and give feedback.
#dotNET
#PostgreSQL
So as the clock ticks and we get closer to Citus Con: An Event for Postgres 2023, it seemed fitting to release my video monologue as a YouTube #Short.
It's about the often misspelled, often mispronounced Postgres and Citus databases.
Hope y'all enjoy it and that it brings a smile to your day.
Please please boost, to help more people get a kick out of this.
#PostgreSQL #CitusCon #Citus #Postgres #YouTube #video #humor
Another Electric SQL stream tomorrow at 15.00 sweden time.
Expect Elixir, SQLite and audacious goals. Supported by @electric ⚡️
https://youtube.com/live/LOR_ReuAfWU?feature=share
#elixir #sqlite #postgresql #postgres
My #JFokus talk "PostgreSQL, The Time-Series Database You Actually Want" about #timeseries on #PostgreSQL (and why #TimescaleDB is the convenience you're actually looking for) is online ❤️🙏
New blog post: Download live #Railway database to localhost.
https://dev.to/michalbryxi/download-railway-database-to-localhost-124e
#Postgresql #Docker #RubyOnRails #dotenv #scripting #development #DX
Couvrez-vous, notre #DBA Christophe déballe tout sur la commande FREEZE, une variante de VACUUM pas très connue => https://dali.bo/202302_vacuum-freeze
#PostgreSQL #SGBD

Live in 6 minutes. Electric SQL, Elixir and if we feel frisky. Deployment. Towards Fly?
https://youtube.com/live/y71uOUPXioA?feature=share
#elixir #sqlite #postgresql
Spend half of the day fixing a weird connection issue between a #Perl API backend running in podman on an Azure clown server and a #PostgreSQL DB running on another server. The connection worked for a bit, then stopped. Solution: on_connect_do => 'SET tcp_keepalives_idle = 60'; It seems that the Azure network would terminate idle TCP connections, and as the service in question was not getting a lot of requests (being in dev), this happend quite a lot. Not how I planned to spend my afternoon...
How nice. psql-tips.org is a great repository of, you guessed it, psql (the CLI tool, not the DB itself) tips:
Absolutely, continually blown away by #supabase
$25 for just hosted #PostgreSQL , #auth for 100k MAU, and email support is brilliant.
The fact it's also a fully formed #BaaS/#Firebase alternative with far less lock in is a bonus.
Working on my SQL chops has been the smartest thing I've done in a loooong time.
It's a great joy to get to do occasional open source work for hire. Even better when done in the open.
Thanks to the Electric SQL folks there will be a livestream on Tuesday the 21st and another one Friday the 24th.
Link is here:
https://youtube.com/live/uGNgAiLj0SM?feature=share
Electric SQL syncs SQLite and Postgres using the BEAM. You bet I'll make it do Elixir.
#elixir #erlang #sql #sqlite #postgresql
I just did a stream about #postgresql and #pgadmin and turns out that I forgot everything in just 6 years. Had to look up how to do an UPDATE command.
David E. Wheeler: Hello Mastodon 🐘 https://blog.pgxn.org/post/709635160523620352/hello-mastodon
#postgres #postgresql
Something new on my #PostgreSQL blog: "UUIDs vs serials for keys." https://thebuild.com/blog/2023/02/16/uuids-vs-serials-for-keys/
Dealing with an over-microserviced mess... now considering diving into Postgres' Foreign Tables to simplify search accross silos... any experiences? #PostgreSQL #ForeignTables #microservices
https://www.postgresql.org/docs/current/sql-createforeigntable.html
Been playing with getting some fancy dashboards and whatnot going on, with a bunch of metrics, traces and logs, to see how to make a bunch of #DotNet services observable.
Looking good! 😁
Hit some challenges, but for the most part, got things working as I hoped. Now that it's coming together, need to clean things up a bit and write a blog post (or more) on the subject 😅.
Featuring #DotNet, #Kafka, #PostgreSQL, #Grafana, #Tempo, #Loki, #OpenTelemetry




Should you use char, varchar, or text in PostgreSQL?
https://maximorlov.com/char-varchar-text-postgresql/
Discussions: https://discu.eu/q/https://maximorlov.com/char-varchar-text-postgresql/
#database #javascript #nodejs #postgresql #programming #sql #webdev
This is one of those essential bits of detail that's really important when helping customers operate #PostgreSQL databases on a evolving #OpenSource stack.
Collation changes (locale-based sort ordering) in #GNU libc can cause index corruption due to how the system works.
Amazon #RDS and Amazon #Aurora are now able to isolate the collation semantics from the rest of glibc to help customers avoid data corruption or the need to rebuild indexes.
#FreeSoftware #FOSS
https://aws.amazon.com/blogs/database/manage-collation-changes-in-postgresql-on-amazon-aurora-and-amazon-rds/
So last Sunday I gave a #talk called "Don't Do This" at the #FOSDEM #PostgreSQL #devroom and it went mostly all right 😂 (#slides & #video link inside) 👇
@mcc I set up matrix and realized if anyone in my instance tried to follow a larger group, it would knock me over.
But ideally people’d be able to have a private chat with friends _and_ follow #postgresql or whatever and not wreck the friends’ server.
Honest question: is this possible and I just wasn’t noticing how to do it?
The 6th talk is happening now in the PostgreSQL devroom at #FOSDEM, the wonderful @Karenhjex is presenting on “DBA Evolution (the Changing Role of the Database Administrator)”
#Fosdem2023 #PostgreSQL #Postgres #DBA #Photography

Wir suchen im ISC-EJPD (Bundesverwaltung der Schweiz 🇨🇭) einen Senior Datenbank-Spezialist/in #PostgreSQL 🐘.
Wenn Du Interesse hast, mit mir zusammen zu bauen und zu basteln, aber auch einen sauberen 7x24 Betrieb zu gewährleisten, dann melde Dich bitte entweder bei mir oder bei Alain Fuhrer (siehe Link). In letzterem Fall nenne Alain gegenüber bitte meinen Namen.
Wenn Du Fragen hast, beantworte ich sie gerne.
https://jobs.admin.ch/offene-stellen/share/9ca335b4-e6b6-4a68-af54-af8fd460896a
Bitte auch gerne boosten. Merci für die Aufmerksamkeit.
