Masthash

#postgresql

Ferdinando Simonetti
24 minutes ago

[ 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

IT News
2 hours ago

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

Planet PostgreSQL (Unofficial)
5 hours ago

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

Dougas J Hunley
10 hours ago

#PostgreSQL Patch of Interest (To Me): Documentation Linking https://www.softwareandbooz.com/ppi-documentation-linking/

Oli
11 hours ago

Oh #PostgreSQL, you're the best relational database 🥰

jmac
15 hours ago

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.

#Postgres #databases #TechWriting

IT News
15 hours ago

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

GabeWeiss
16 hours ago

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!

https://cloud.google.com/alloydb/omni

Planet PostgreSQL (Unofficial)
1 day ago

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

ESG
1 day ago

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/

#CSharp #GCP #PostgreSQL

Dougas J Hunley
1 day ago
Planet PostgreSQL (Unofficial)
2 days ago
Dickson Tan
2 days ago

#til #postgresql can prevent overlapping time ranges for things like representing booking times without any application code.

https://sqlfordevs.com/non-overlapping-time-ranges

Dougas J Hunley
2 days ago

System roles – what, why, how? – select * from depesz; https://www.depesz.com/2023/03/14/system-roles-what-why-how/ #postgresql

Ludovic
2 days ago
Planet PostgreSQL (Unofficial)
2 days ago

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 Scherbaum
2 days ago

PostgreSQL Person of the Week interview with: Chris Ellis (@intrbiz)

#PostgreSQL #PostgresFriends
https://postgresql.life/post/chris_ellis/

Martin De Wulf
2 days ago

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 :-)

#software #development #python #django #react #postgresql

Dougas J Hunley
3 days ago

Interview with: Vincent Picavet | #PostgreSQL Person of the Week https://postgresql.life/post/vincent_picavet/

Lenz Grimmer
3 days ago

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.

#Percona #OpenSource #Databases

https://www.percona.com/blog/release-roundup-march-27-2023/

Jobs for Developers
3 days ago

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

Jobs for Developers
3 days ago

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

Jobs for Developers
3 days ago

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

Federico Campoli :postgresql:
4 days ago

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

Jobs for Developers
4 days ago

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

Sowiszcze
4 days ago

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.

Jobs for Developers
4 days ago

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

TheSteve0
5 days ago
Jobs for Developers
5 days ago

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

Robyn :antifa:
6 days ago

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. 🙈

#followerpower

Output von sealtert -l "*" | less
# semanage fcontext -a -t FILE_TYPE 'data'
where FILE_TYPE is one of the following: cluster_var_run_t, faillog_t, krb5_host_rcache_t, postgresql_db_t, postgresql_log_t, postgresql_tmp_t, postgresql_var_run_t, tmp_t, tmpfs_t, var_lib_t, var_lock_t, var_log_t, var_run_t.
Then execute:
restorecon -v 'data'
Screenshot vom Browser

Cannot open env file /var/lib/postgresql/incoming/2023-03-24-17.04.13-538066504/environment: No such file or directory at /home/popreport/production/www/cgi-bin/entry.pl line 363.
[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
PostgresFM
6 days ago

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

📺 https://youtu.be/kiHnZ5Phprk

#postgresql #postgres

Screenshots of Michael and Nikolay mid-recording, the episode title "psql vs GUIs" against a pink backround with an elephant wearing sunglasses. Of course.

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

Lars Wikman
6 days ago

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

TheSteve0
6 days ago

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.

RDN
6 days ago

@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.

#Databases #FOSS

Lenz Grimmer
1 week ago

#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/

Anthony Nowocien
1 week ago

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.

@pgDayParis

Sarah Haïm-Lubczanski  

Sarah Haim-Lubczanski talk during pgday.paris about improving the documentation.
Elan Hasson
1 week ago
adamghill
1 week ago

`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?

1 week ago

#PostgreSQL with #EDN support would be huge!

#clojure

Rafael Caricio :rust:
1 week ago

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.

https://github.com/rafaelcaricio/backie

#RustLang #Tokio #Backie #Diesel #PostgreSQL

Logo of the Backie project. Backie is an open-source project for async background tasks in Rust. The logo is a cute bicycle and a cute hermit on the back rack. The hermit has a Rust turbofish operator tattoo.
Viss
1 week ago

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

#BashTricks #ShellTricks #ssh #postgresql

Renato Losio
2 weeks ago

Amazon Aurora PostgreSQL Adds Write-Through Cache to Improve Logical Replication Performance

https://www.infoq.com/news/2023/03/aws-aurora-write-through-cache/

#aws #aurora #database #postgresql #performance

Pamela Fox
2 weeks ago

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!

Assaf
2 weeks ago

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)

Kingsley Uyi Idehen
2 weeks ago

@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.

Curtis "Ovid" Poe
2 weeks ago

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.

#perl #soap #oracle #postgresql

https://ovid.github.io/articles/project-500.html

Paolo Melchiorre
2 weeks ago

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/

CC @sixfeetup @pythonwebconf

#PWC2023 #Django #PostgreSQL #Python #Web #Conference

Paolo Melchiorre and Laura Stephens at Python Web Conference 2023
Django with PostgreSQL SuperPowers first slide
Slide with Django Reinhardt at the Aquarium jazz club in New York
Slide with an elephant walking during daytime
pgDay Paris
2 weeks ago

Read the #pgDayParis speaker interview with Magali Milbergue (@MagaliMilbergue)

#PostgreSQL #Conference #Paris

https://2023.pgday.paris/speaker-interviews/magali_milbergue/

David Burke
3 weeks ago

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?

Pamela Fox
3 weeks ago

I'm upping my #Postgresql knowledge thanks to some great talks by Louise Grandjoc:

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

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

Brar Piening
4 weeks ago

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

Claire Giordano ✨
1 month ago

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

https://youtube.com/shorts/M_91z3gMW2A?feature=share

Lars Wikman
1 month ago

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

Christoph Engelbert
1 month ago

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 ❤️🙏

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

Dalibo
1 month ago

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

Lars Wikman
1 month ago

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

domm
1 month ago

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...

Nicola Iarocci
1 month ago

How nice. psql-tips.org is a great repository of, you guessed it, psql (the CLI tool, not the DB itself) tips:

https://psql-tips.org/psql_tips_all.html

#postgresql #database

Gary Lake
1 month ago

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.

#Developer #WebDeveloper #FullStackDeveloper

Lars Wikman
1 month ago

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

David Martínez Martí
1 month ago

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.

https://www.youtube.com/live/NT0l_gvHCp8?feature=share

Christophe
1 month ago

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

João Antunes
1 month ago

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

Grafana dashboard with operational information about a .NET worker service consuming Kafka events
Grafana Tempo integration showing traces from .NET services
Grafana dashboard with operational information from an ASP.NET Core API
Grafana Loki integration, showing logs generated from .NET services

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) 👇

https://vyruss.org/blog/dont-do-this-fosdem-2023.html

#postgres #opensource #database #fosdem2023 #fosdem23

Jason Petersen
2 months ago

@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?

Claire Giordano ✨
2 months ago

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

Karen Jex smiling on stage right before her talk began in the PostgreSQL devroom at FOSDEM

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.

ruud
2 months ago
If you want to see more pictures of the speakers in the #PostgreSQL devroom at #Fosdem2023 , follow @clairegiordano , she is always taking photos as you can see here 😀👋
Claire, Jimmy and Karen