How to Install Concourse CI on #Ubuntu #VPS Here is a detailed step-by-step guide on how to install Concourse CI on Ubuntu VPS, complete with setup instructions for the Concourse web UI, worker, and #PostgreSQL backend database.
READ ALSO: Advantages of Ubuntu VPS Servers for Your Business

What is Concourse CI?
Concourse CI is a modern, open-source continuous integration and continuous delivery (CI/CD) ...
Continued https://blog.radwebhosting.com/how-to-install-concourse-ci-on-ubuntu-vps/?utm_source=mastodon&utm_medium=social&utm_campaign=mastodon.social #letsencrypt #selfhosting #concourseci #selfhosted

10 Steps to Protect Your #VPS Against SQL Injection
This article provides a guide discussing how to protect your VPS against SQL injection.
What is SQL Injection?
SQL Injection is a type of cyber attack where an attacker inserts or “injects” malicious SQL code into a query through input fields, URLs, or other data entry points. If the application doesn't properly validate or sanitize the input, the ...
Continued https://blog.radwebhosting.com/how-to-protect-your-vps-against-sql-injection/?utm_source=mastodon&utm_medium=social&utm_campaign=mastodon.social #sqlinjection #postgresql #vpsguide #mariadb

SSD-Powered #cPanel Web #Hosting – Up to 25x Faster SSD-Powered cPanel Web Hosting by Rad Web Hosting
Built for Performance. Backed by Reliability. Ready to Scale.
Developers, sysadmins, and power users—we built this for you. Our SSD-powered cPanel hosting is engineered on high-availability ...
Continued https://blog.radwebhosting.com/ssd-powered-cpanel-web-hosting-up-to-25x-faster/?utm_source=mastodon&utm_medium=social&utm_campaign=mastodon.social #letsencrypt #phpmyadmin #mariadb #litespeed #cloudlinux #postgresql #phppgadmin #wpcli #laravel #csf #softaculous #joomla #webhosting

Wait #postgresql 18 has OAuth authz? https://www.postgresql.org/docs/18/auth-oauth.html

What if your #PostgreSQL cluster is running, and the demo app is generating traffic — but there's no visibility into the health of the #Kubernetes cluster, services, or applications? https://t.ly/lYDc6

Daniil Bazhenov shows you how to set up #Coroot in a #GitOps setup using #ArgoCD to gain complete observability, and stay in control of your system health.

Multi-Version Concurrency Control (MVCC) in #PostgreSQL: Learning PostgreSQL with Grant https://www.red-gate.com/simple-talk/databases/postgresql/multi-version-concurrency-control-mvcc-in-postgresql-learning-postgresql-with-grant/

#PostgreSQL 18 Beta 2 Released!
https://www.postgresql.org/about/news/postgresql-18-beta-2-released-3103/

Join us on Tuesday, August 12th at Noon PDT for "Gathering of the Herd - SF PUG Celebrates World Elephant Day!” with Federico Campoli and Stacey Haysler!

https://www.meetup.com/postgresql-1/events/309042260/?eventOrigin=group_events_list

@PostgreSQL #PostgreSQL #postgres #meetup

PostgreSQL 新系統檢視：檢查 DSM 登錄分配
➤ 更方便的共享記憶體管理與監控
✤ https://tselai.com/pg-dsm-registry-allocations
這篇文章介紹了 PostgreSQL 中動態共享記憶體（DSM）登錄的新功能和系統檢視。新的 `GetNamedDSA()` 和 `GetNamedDSHash()` 函數簡化了 DSM 登錄中動態共享區域（DSA）和動態共享雜湊表（dshash）的分配。作者同時貢獻了新的 `pg_dsm_registry_allocations` 系統檢視，允許使用者檢查 DSM 登錄中的記憶體分配情況，包括擴充功能所使用的分配。
+ 哇，這對開發 PostgreSQL 擴充功能的人來說真是個好消息！以前處理共享記憶體分配一直很麻煩，現在有了更簡潔的方式，還有可以監控的視圖，簡直太棒了！
+ 雖然要等到 PostgreSQL 19 才能用，但這看起來真的很實用。如果我現在需要用到，可以直接套用 patch 嗎？作者願意提供協助真是太好了。
#PostgreSQL #數據庫 #開發

System View for Inspecting DSM Registry Allocations in PostgreSQL

https://tselai.com/pg-dsm-registry-allocations

#postgresql Do not expose port 5432 to the public Internet https://thebuild.com/blog/2025/04/02/do-not-expose-port-5432-to-the-public-internet/

Collaboration is key when it comes to creating a diverse and inclusive community. The members of our Diversity Committee are constantly working towards the goal of a vibrant and collaborative community.

https://postgresql.us/diversity/

#JeRecrute un•e ingénieur•e data/backend #Python / #PostgreSQL pour Ecobalyse, la startup d’État qui calcule combien coûtent à la planète les mer^Wtrucs qu'on achète

PS: ça va faire super malpoli/yolo mais je me casse en vacances ce soir et j'ai vraiment besoin d'un gros break donc je laisse mes adorables collègues dont @vjousse vous filer toutes les infos complémentaires dont vous auriez besoin (désolé copain cœur sur tes mentions)

https://www.welcometothejungle.com/fr/companies/communaute-beta-gouv/jobs/data-back-end-pour-ecobalyse-mte-ademe_paris

Upgraded a PostgreSQL server from Debian 12 to 13, and got hit by this bug:

https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=960789

resutling in the new postgresql version running with the wrong configuration after running pg_upgradecluster.

PGDay Napoli 2025: La Prima Edizione è Qui!

Il 25 settembre a Napoli ospiteremo il PGDay Napoli, la conferenza imperdibile per gli appassionati di PostgreSQL! Un'occasione unica per incontrare esperti internazionali, scoprire le ultime novità e fare networking.

Il programma è online e le registrazioni sono aperte. Non perdere questa opportunità!

https://2025.pgdaynapoli.org/

Come see Priyanka Chatterjee talk about "All about Common Vulnerabilities and exposures in PostgreSQL"!

#awesome #postgresql #conference #pgday #pgdaynapoli

https://www.postgresql.eu/events/pgdaynapoli2025/sessions/session/6731-all-about-common-vulnerabilities-and-exposures-in-postgresql/

How we discovered, and recovered from, Postgres corruption on the matrix.org homeserver

#database #matrix #postgresql

https://matrix.org/blog/2025/07/postgres-corruption-postmortem/

its amazin how #pgbounce can reduce the direct connections to #postgresql improving the responses and reducing error like: too many clients already

Phân tích sự cố sập database PostgreSQL của Matrix.org năm 2025, cách phát hiện lỗi và quy trình phục hồi.
#PostgreSQL #Database #Matrix #Debug #Vietnamese #Lỗi #Cơ sở dữ liệu

https://matrix.org/blog/2025/07/postgres-corruption-postmortem/