PostgreSQL

20 March 2025 10:19

Hi everyone, we have recently migrated one of our oracle db to EPAS postgres.. there is a remote oracle db which access data through db links.. problem now is, due to case sensitivity, we have to use “schema_name”.”owner_name” everytime to access data.. we had to make changes in 600*+ places to overcome this..

PostgreSQL

19 March 2025 08:27

https://www.postgresql.org/docs/current/routine-vacuuming.html

PostgreSQL

19 March 2025 08:27

VACUUM releases space for new tuples to be written without bloating the table even further. However, the disk space used will be the same

PostgreSQL

19 March 2025 08:19

Or, since I'm a computer anarchist, I would also use a proxmox cluster 🫣

PostgreSQL

19 March 2025 08:06

Someone will say patroni, someone will say pgpool II, some repmgr, some PAF. You better ask what you need, not best. Easiest to set up is PAF, most used in the industry is Patroni, load balancing etc features are with pgpool II

PostgreSQL

19 March 2025 07:30

Hi all, can anyone tell me which open tool is best for automatic failover of postgres?

PostgreSQL

18 March 2025 18:17

Can anyone explain me why the old implementation introduce a problem.🤔 After reading many articles I still feel difficult to understanding what's happended with the old implementation.

PostgreSQL

17 March 2025 23:58

PostgreSQL Person of the Week interview with: Emma Saroyan

https://postgresql.life/post/emma_saroyan/

PostgreSQL

17 March 2025 14:45

That depends on how you deployed or installed PostgreSQL.

PostgreSQL

17 March 2025 14:25

You would also need to update any systems that you have PostgreSQL client library / command line applications installed on. AFAIK

PostgreSQL

17 March 2025 14:11

Thanks for confirmation

PostgreSQL

17 March 2025 13:42

Is it required to upgrade to the higher versions .Please anyone confirm on it.

PostgreSQL

17 March 2025 13:41

regarding PostgreSQL .
 
Kindly go through the vulnerability note and let us know the impact in any postgres Db
 
Software Affected
*    PostgreSQL 17 versions prior to 17.3
*    PostgreSQL 16 versions prior to 16.7
*    PostgreSQL 15 versions prior to 15.11
*    PostgreSQL 14 versions prior to 14.16
*    PostgreSQL 13 versions prior to 13.19
Overview
A vulnerability has been reported PostgreSQL which could allow an attacker to execute arbitrary code on the target system.
Target Audience :
All organizations using PostgreSQL applications.
Impact Assessment :
Potential risk of unauthorized access to sensitive information, data manipulation, denial of service.
Description
PostgreSQL is an open-source, object-relational database management system (ORDBMS) that is widely used for managing and storing structured data.
This vulnerability exists in PostgreSQL due to improper neutralization of quoting syntax in libpq functions (PQescapeLiteral(), PQescapeIdentifier(), PQescapeString(), and PQescapeStringConn()) and command-line utilities. An attacker could exploit this vulnerability by injecting malicious SQL statements.
Successful exploitation of this vulnerability could allow the attacker to execute arbitrary code, gain access to sensitive information on the target system.
Solution
Apply appropriate updates as mentioned by the vendor :
https://www.postgresql.org/support/security/CVE-2025-1094/
Vendor Information
PostgreSQL
https://www.postgresql.org/support/security/CVE-2025-1094/
References
PostgreSQL
https://www.postgresql.org/support/security/CVE-2025-1094/
CVE Name
CVE-2024-1094
 

PostgreSQL

14 March 2025 22:47

maybe set slots conf to false in patroni solves but what can be the reason

PostgreSQL

14 March 2025 22:43

Get faster network & replicas. The replay is still single threaded AFAIK, every Hz and IOPS counts.

PostgreSQL

19 March 2025 09:13

Which is PAF, essentially. You certainly don't want to use the out-of-the-box resource handlers...

PostgreSQL

19 March 2025 08:27

If you want to delete tuples and have the space released to the OS, you will need to use FULL VACUUM

PostgreSQL

19 March 2025 08:23

Is autovaccum process just clear the dead tuples or along with that it releases space back to os also?

PostgreSQL

19 March 2025 08:18

Somebody will also suggest pacemaker

PostgreSQL

19 March 2025 08:03

In Patroni, pgpool-ll and pmgr, which one is best and easy to configure and maintain?

PostgreSQL

18 March 2025 19:28

Us? Please consider having professional service for your databases. No one can answer here how your environment is affected by the CVEs. And you are asking people to do an analysis for you, for free.

PostgreSQL

18 March 2025 11:20

Hi, I am looking for blockchain developers and interface developers, as well as beta testers, write in private messages

PostgreSQL

17 March 2025 15:01

Please seek postgresql commercial support for this kind of instructions. Else, read the documentation on postgresql websites

PostgreSQL

17 March 2025 14:26

How to perform it ? Please let us know

PostgreSQL

17 March 2025 14:22

You need to apply the latest minor update for whichever major version you are running. Eg: 17.3 to 17.4

PostgreSQL

17 March 2025 13:54

yes, you need upgrade minotrversion

PostgreSQL

17 March 2025 13:41

Hi could anyone reply to the above vulnerability?

PostgreSQL

16 March 2025 18:53

Has anyone read pragmatic programmer ?

PostgreSQL

14 March 2025 22:45

but there is no any lag on replicas

PostgreSQL

14 March 2025 22:30

maybe remove the rep slot and configure auto vaccum..