Bash automation for PostgreSQL

misconfigured with my PostgreSQL syntax. If you find a bug in LinuxHA, please submit a bug report to bugs.launchpad.net/linuxha/+filebug. Kind regards, Travis Bean

RE: Request for official clarification on SQL parameter parsing changes in PostgreSQL 15 and 16

Dear Tom, Laurenz, and Dominique, Thank you all very much for your helpful and detailed explanations. Your insights clarified the behavior change in PostgreSQL 15 perfectly, and I now have a clear understanding of the issue I was encountering. I really appreciate your time and support. Best

Re: Request for official clarification on SQL parameter parsing changes in PostgreSQL 15 and 16

Laurenz Albe writes: > On Thu, 2025-04-17 at 05:17 +, 王　博 wrote: >> 1. In PostgreSQL 15 and later: >>    The following SQL causes a syntax error unless a space is added after the >> `?`: >> SELECT * FROM table WHERE a = ?AND b = 123; >>    → Adding a s

Re: Request for official clarification on SQL parameter parsing changes in PostgreSQL 15 and 16

On Thu, 2025-04-17 at 05:17 +, 王　博 wrote: > We have encountered unexpected SQL parsing errors during application upgrades > from > PostgreSQL 14 to 15 and 16, related to the use of JDBC-style parameter > placeholders (`?`) in our legacy applications. >   > Specifically: >

Re: Request for official clarification on SQL parameter parsing changes in PostgreSQL 15 and 16

On Thu, Apr 17, 2025 at 11:13 AM 王　博 wrote: > Hello PostgreSQL Community, > We have encountered unexpected SQL parsing errors during application upgrades > from PostgreSQL 14 to 15 and 16, related to the use of JDBC-style parameter > placeholders (`?`) in our legacy applicat

Request for official clarification on SQL parameter parsing changes in PostgreSQL 15 and 16

Hello PostgreSQL Community, We have encountered unexpected SQL parsing errors during application upgrades from PostgreSQL 14 to 15 and 16, related to the use of JDBC-style parameter placeholders (`?`) in our legacy applications. Specifically: 1. In PostgreSQL 15 and later: The following

Re: Best Tool for PostgreSQL Auditing and Storing Audit Logs Separately

On Wed, Apr 16, 2025 at 03:53:53PM -0400, Ron Johnson wrote: > On Wed, Apr 16, 2025 at 3:42 PM Nico Williams wrote: > > I would care about what happened. To know what happened I'd have to see > > either only audit logs for committed transactions, or also see the > > COMMIT and ROLLBACK statements

Re: Best Tool for PostgreSQL Auditing and Storing Audit Logs Separately

On Wed, Apr 16, 2025 at 3:42 PM Nico Williams wrote: > On Wed, Apr 16, 2025 at 02:43:59PM -0400, Ron Johnson wrote: > > You'll have to bring that up with the PgAudit maintainer. Note, though, > > that the purpose of PgAudit is not "recreate the database from audit > logs"; > > it's "what Auditor

Re: Best Tool for PostgreSQL Auditing and Storing Audit Logs Separately

On Wed, Apr 16, 2025 at 02:43:59PM -0400, Ron Johnson wrote: > You'll have to bring that up with the PgAudit maintainer. Note, though, > that the purpose of PgAudit is not "recreate the database from audit logs"; > it's "what Auditors care about". In my experience, auditors do not care > about CO

Re: Best Tool for PostgreSQL Auditing and Storing Audit Logs Separately

>>> >>> One issue we have with pgaudit is that it prints AUDIT records even if >>> the xaction gets rollbacked, how do you alleviate that ? >>> >>> >>> yours, >>> >>> Kenan Çiftçi >>> >>> On Tue, Apr 15, 2025 at 1:

Re: Best Tool for PostgreSQL Auditing and Storing Audit Logs Separately

e that ? yours, Kenan Çiftçi On Tue, Apr 15, 2025 at 1:44 PM vijay patil wrote: Hi All, We are exploring auditing solutions for our PostgreSQL database and are considering using |pgaudit| for this purpose. However,

Re: Best Tool for PostgreSQL Auditing and Storing Audit Logs Separately

gt;> yours, >> >> Kenan Çiftçi >> >> On Tue, Apr 15, 2025 at 1:44 PM vijay patil >> wrote: >> >>> Hi All, >>> >>> We are exploring auditing solutions for our PostgreSQL database and are >>> considering using p

Re: Best Tool for PostgreSQL Auditing and Storing Audit Logs Separately

gets rollbacked, how do you alleviate that ? yours, Kenan Çiftçi On Tue, Apr 15, 2025 at 1:44 PM vijay patil wrote: Hi All, We are exploring auditing solutions for our PostgreSQL database and are considering using |pgaudit| for this purpose. Howeve

Re: Best Tool for PostgreSQL Auditing and Storing Audit Logs Separately

t; > yours, > > Kenan Çiftçi > > On Tue, Apr 15, 2025 at 1:44 PM vijay patil > wrote: > >> Hi All, >> >> We are exploring auditing solutions for our PostgreSQL database and are >> considering using pgaudit for this purpose. However, we have a few

Re: Best Tool for PostgreSQL Auditing and Storing Audit Logs Separately

do you alleviate that ? yours, Kenan Çiftçi On Tue, Apr 15, 2025 at 1:44 PM vijay patil wrote: Hi All, We are exploring auditing solutions for our PostgreSQL database and are considering using |pgaudit| for this purpose. However, we have a few questions: 1

Re: Best Tool for PostgreSQL Auditing and Storing Audit Logs Separately

> yours, > > Kenan Çiftçi > > On Tue, Apr 15, 2025 at 1:44 PM vijay patil > wrote: > >> Hi All, >> >> We are exploring auditing solutions for our PostgreSQL database and are >> considering using pgaudit for this purpose. However, we have a few >>

Best Tool for PostgreSQL Auditing and Storing Audit Logs Separately

Hi All, We are exploring auditing solutions for our PostgreSQL database and are considering using pgaudit for this purpose. However, we have a few questions: 1. *What is the best tool for auditing PostgreSQL databases?* - We are specifically looking for a solution that offers

Re: Best Tool for PostgreSQL Auditing and Storing Audit Logs Separately

Hi, You can use pgaudit and pgauditlogtofile extension ( https://github.com/fmbiete/pgauditlogtofile) together to write audit logs in a separate file. yours, Kenan Çiftçi On Tue, Apr 15, 2025 at 1:44 PM vijay patil wrote: > Hi All, > > We are exploring auditing solutions for our P

Re: To take backup of Postgresql Database without large objects

On 4/11/25 23:05, David G. Johnston wrote: On Friday, April 11, 2025, Adrian Klaver > wrote: On 4/11/25 22:06, sivapostg...@yahoo.com wrote: Either my command should be wrong or I'm missing something. This w

Re: To take backup of Postgresql Database without large objects

Thanks for the clarification. bytea != large object Happiness Always BKR Sivaprakash On Saturday 12 April, 2025 at 11:36:11 am IST, David G. Johnston wrote: On Friday, April 11, 2025, Adrian Klaver wrote: On 4/11/25 22:06, sivapostg...@yahoo.com wrote: Either my command should be wr

Re: To take backup of Postgresql Database without large objects

On Friday, April 11, 2025, Adrian Klaver wrote: > On 4/11/25 22:06, sivapostg...@yahoo.com wrote: > > Either my command should be wrong or I'm missing something. >> > > This was explained in my post as quoted below. Yeah, the short version. Then you added a long version that just confused the

Re: To take backup of Postgresql Database without large objects

postg...@yahoo.com <mailto:sivapostg...@yahoo.com> wrote: > Hello, > > Using PostgreSQL 15.1, compiled by Visual C++ build 1914, 64-bit in > Windows 10. > > Trying to take backup of a database, using pg_dump, where one table > contains bytea datatype, which I don

Re: To take backup of Postgresql Database without large objects

> On Apr 11, 2025, at 22:34, sivapostg...@yahoo.com wrote: > Then I've misunderstood large objects. Is there document to explain large > objects? Large objects are a relatively old and now little-used feature of PostgreSQL that predates the bytea type: https://www.

Re: To take backup of Postgresql Database without large objects

Thanks.Then I've misunderstood large objects.  Is there document to explain large objects?  We store images in bytea column. Happiness Always BKR Sivaprakash On Saturday 12 April, 2025 at 10:44:21 am IST, David G. Johnston wrote: On Friday, April 11, 2025, sivapostg...@yahoo.com wrot

Re: To take backup of Postgresql Database without large objects

On Friday, April 11, 2025, sivapostg...@yahoo.com wrote: > > > bytea field also included in the backup. > Bytea typed columns are completely separate things than large objects. You cannot exclude individual columns using pg_dump. David J.

Re: To take backup of Postgresql Database without large objects

   The new database contains contents from bytea field also.   Either my command should be wrong or I'm missing something.   Happiness Always BKR Sivaprakash On Friday 11 April, 2025 at 08:31:31 pm IST, Adrian Klaver wrote: On 4/11/25 05:55, sivapostg...@yahoo.com wrote: > Hello, >

Re: To take backup of Postgresql Database without large objects

On Fri, Apr 11, 2025 at 8:56 AM sivapostg...@yahoo.com < sivapostg...@yahoo.com> wrote: > Hello, > > Using PostgreSQL 15.1, compiled by Visual C++ build 1914, 64-bit in > Windows 10. > That's 11 patch releases behind current. > Trying to take backup of a datab

Re: To take backup of Postgresql Database without large objects

On 4/11/25 05:55, sivapostg...@yahoo.com wrote: Hello, Using PostgreSQL 15.1, compiled by Visual C++ build 1914, 64-bit in Windows 10. Trying to take backup of a database, using pg_dump, where one table contains bytea datatype, which I don't want to include in the backup. My comman

Re: To take backup of Postgresql Database without large objects

Hello, Using PostgreSQL 15.1, compiled by Visual C++ build 1914, 64-bit in Windows 10. Trying to take backup of a database, using pg_dump, where one table contains bytea datatype, which I don't want to include in the backup. My command was:"E:\DBBackup\bin\pg_dump.exe"  -h 192.168

Re: pgvector as standard PostgreSQL feature?

sion of the "money" type for > what happens when a type added to core starts becoming ill-supported... and > "money" isn't anywhere near as complex as vector functionality. > > 3. PostgreSQL is designed to have a rich ecosystem of extensions. The > abilit

Re: SQL Server's WITH (NOLOCK) equivalent in PostgreSQL?

On Sun, 2025-03-30 at 22:10 -0700, David G. Johnston wrote: > On Sunday, March 30, 2025, 이현진 wrote: > > Since PostgreSQL uses MVCC, I'm wondering what the best practice is for > > non-blocking reads, > > and whether there's an equivalent to dirty reads

Re: SQL Server's WITH (NOLOCK) equivalent in PostgreSQL?

On Sunday, March 30, 2025, 이현진 wrote: > > Since PostgreSQL uses MVCC, I'm wondering what the best practice is for > non-blocking reads, > and whether there's an equivalent to dirty reads or READ UNCOMMITTED. > https://www.postgresql.org/docs/current/transaction-i

Re: SQL Server's WITH (NOLOCK) equivalent in PostgreSQL?

> On Mar 30, 2025, at 21:44, 이현진 wrote: > Since PostgreSQL uses MVCC, I'm wondering what the best practice is for > non-blocking reads, > and whether there's an equivalent to dirty reads or READ UNCOMMITTED. There are two different questions here. 1. Reads are not bl

SQL Server's WITH (NOLOCK) equivalent in PostgreSQL?

Hi all, I'm trying to understand how to replicate SQL Server's WITH (NOLOCK) behavior in PostgreSQL. Since PostgreSQL uses MVCC, I'm wondering what the best practice is for non-blocking reads, and whether there's an equivalent to dirty reads or READ UNCOMMITTED. Would apprec

Re: How to pass a list of locations (longitude, latitude) to a PostgreSQL/PostGIS stored function?

Thank you all. I would like to use a geometry type, but will it work well with the Npgsql C# packages? >

Re: How to pass a list of locations (longitude, latitude) to a PostgreSQL/PostGIS stored function?

On Tue, 25 Mar 2025 at 19:07, Tom Lane wrote: > Alexander Farber writes: > > Then I am trying to add a function, which would receive a series of > > locations (longitude and latitude pairs in microdegrees) and return a > list > > of lowercase 2-letter country codes, like "de", "pl", "lv": > > >

Re: How to pass a list of locations (longitude, latitude) to a PostgreSQL/PostGIS stored function?

El 25-03-25 a las 18:58, Christoph Berg escribió: Re: Tom Lane You might be best advised to create a composite type like "location (long bigint, lat bigint)" and use an array of that. Or use the geometry types from PostGIS, since you are probably going to do geo lookups on these points anyway

Re: How to pass a list of locations (longitude, latitude) to a PostgreSQL/PostGIS stored function?

Re: Tom Lane > You might be best advised to create a composite > type like "location (long bigint, lat bigint)" and use an array of > that. Or use the geometry types from PostGIS, since you are probably going to do geo lookups on these points anyway. Christoph

Re: How to pass a list of locations (longitude, latitude) to a PostgreSQL/PostGIS stored function?

Alexander Farber writes: > Then I am trying to add a function, which would receive a series of > locations (longitude and latitude pairs in microdegrees) and return a list > of lowercase 2-letter country codes, like "de", "pl", "lv": > CREATE OR REPLACE FUNCTION find_countries(locations BIGIN

How to pass a list of locations (longitude, latitude) to a PostgreSQL/PostGIS stored function?

Hello dear PostgreSQL users I have prepared a https://dbfiddle.uk/vOFXNgns for my question and also list my SQL code below. I have created a countires_boundaries table, which I intend to fill with .poly files provided at Geofabrik: CREATE EXTENSION IF NOT EXISTS postgis; CREATE TABLE

Re: Today Page is not accessible - postgresql-15.spec

On 2025-Mar-24, Adrian Klaver wrote: > On 3/24/25 07:18, Cars Jeeva wrote: > > Hi Team, > > > > I am trying to access the postgresql-15.spec to build the RPM for my > > project but it is not accessible from morning. > > > > /_*https://git.postgresql.org/g

Re: Today Page is not accessible - postgresql-15.spec

On 3/24/25 07:18, Cars Jeeva wrote: Hi Team, I am trying to access the postgresql-15.spec to build the RPM for my project but it is not accessible from morning. /_*https://git.postgresql.org/gitweb/?p=pgrpms.git;a=blob;f=rpm/redhat/main/non-common/postgresql-15/main/postgresql-15.spec;h

Today Page is not accessible - postgresql-15.spec

Hi Team, I am trying to access the postgresql-15.spec to build the RPM for my project but it is not accessible from morning. *https://git.postgresql.org/gitweb/?p=pgrpms.git;a=blob;f=rpm/redhat/main/non-common/postgresql-15/main/postgresql-15.spec;h=7a8b87ec6db538ca115de4fb962709c7a7cebe11;hb

Re: pgvector as standard PostgreSQL feature?

this functionality being available in the PostgreSQL core in the near future (and by "near future," I mean the next five years). 1. You list three different extensions with overlapping functionality, and that's a good sign that there isn't consensus on what the features

Re: pgvector as standard PostgreSQL feature?

stien Flaesch Cc: pgsql-gene...@postgresql.org Subject: Re: pgvector as standard PostgreSQL feature? EXTERNAL: Do not click links or open attachments if you do not recognize the sender. > On Mar 19, 2025, at 07:47, Sebastien Flaesch > wrote: > > Is there a plan to get pgvector's

pgvector as standard PostgreSQL feature?

Hello, I am looking at pgvector, pgvectorscale, pgai extensions. Other DB engines support built-in vector types. Is there a plan to get pgvector's types (vector, halfvec, sparsevec, bit) implemented as native built-in data types like json/jsonb ? Side note: I have some doubts about these type

Re: #1 - Known bug (memory related) with respect to Aurora postgresql 13.16.3

> > > > - Forwarded Message - > *From:* Bharani SV-forum > *To:* pgsql-gene...@postgresql.org > *Cc:* Bharani SV esteembsv-forum > *Sent:* Saturday, March 15, 2025 at 12:18:04 PM EDT > *Subject:* Known bug (memory related) with respect to Aurora postgresql > 13.

Virtual patching software for PostgreSQL

Hi all, I'm looking for an alternative software that does virtual patching for PostgreSQL DB servers to the Trellix Database Security (previously named McAfee Database Security) I'm currently using Appreciate if anyone using something like that can share some info Thanks! Regards, Mike Yeap

Re: Azure Database for PostgreSQL flexible server: password authentication failed

Hi Alex, pt., 28 lut 2025 o 16:05 Alexander Farber napisał(a): > Now the connection from a container in AKS works for me: > > $ psql "postgresql://postgresql:password12345!!@ > 172.21.32.4:5432/postgres?sslmode=require" > psql (17.4, server 16.6) > SSL connectio

Re: Azure Database for PostgreSQL flexible server: password authentication failed

Ah my team mate has spotted the error for me. And it paid off, that he has no experience with PostgreSQL yet :-) Because the admin user for Azure Database for PostgreSQL flexible server is not "postgres" but "postgresql" Now the connection from a container in AKS w

Re: Azure Database for PostgreSQL flexible server: password authentication failed

ipher is TLS_AES_256_GCM_SHA384 Server public key is 2048 bit This TLS version forbids renegotiation. No ALPN negotiated Early data was not sent Verify return code: 0 (ok) --- But then psql fails: $ psql "postgresql://postgres:password12345!!@ 172.21.32.4:5432/postgres?sslmode=require&qu

Azure Database for PostgreSQL flexible server: password authentication failed

Good afternoon, I am using an Azure Database for PostgreSQL flexible server with no public ip. It is connected to a private VNet and I try to access it from an Alpine Linux container with openssl and postgresql-client installed. In Azure portal I have clicked the "Reset password&qu

Re: Azure Database for PostgreSQL flexible server vs other Azure offerings

Thank you for your comments. I have installed "Azure Database for PostgreSQL flexible server" Standard_D4ds_v5 (4 vCores, USD 50.30 per vCore) 128 GiB (USD 0.09 per GiB) High availabilty: Not enabled Resulting in USD 200 / month

Re: AW: AW: PGDG PostgreSQL Debian package: Question on conditions for creation of new cluster

On 2/24/25 05:57, Schmid Andreas wrote: -Ursprüngliche Nachricht- I think that lives here: https://salsa.debian.org/postgresql/postgresql-common Yes, thanks for the hint. The commit which apparently introduced the change is https://salsa.debian.org/postgresql/postgresql-common

AW: AW: PGDG PostgreSQL Debian package: Question on conditions for creation of new cluster

> -Ursprüngliche Nachricht- > I think that lives here: > https://salsa.debian.org/postgresql/postgresql-common Yes, thanks for the hint. The commit which apparently introduced the change is https://salsa.debian.org/postgresql/postgresql-common

Re: Azure Database for PostgreSQL flexible server vs other Azure offerings

omatically assigned) and try it out - there is a free tier for a year to try it out. https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/how-to-deploy-on-azure-free-account maybe you can add it to your PoC there are no 3 options: "Azure Database for PostgreSQL" is just an

Re: Azure Database for PostgreSQL flexible server vs other Azure offerings

## Alexander Farber (alexander.far...@gmail.com): > - https://azure.microsoft.com/en-us/products/postgresql "Azure Database for > PostgreSQL" - this one scares me be talking about AI that we do not need. > Also it looks more like some abstract product or is it a real setup? T

Azure Database for PostgreSQL flexible server vs other Azure offerings

Good evening, I am trying to convince my team (a small team at a big company) to move from Azure Redis E10 to PostgreSQL, because I am tired of seeing how we (poorly) try to re-invent an SQL database using Redis. My problem is that the team does not want and I am the only one liking SQL

Re: AW: PGDG PostgreSQL Debian package: Question on conditions for creation of new cluster

w checked /usr/share/postgresql-common/maintscripts-functions which is installed by the postgresql-common_273.pgdg24.04+1_all.deb package. This script contains the create_main_cluster() function, which according to a comment "skips if any other cluster already exists". So could it be th

Re: AW: PGDG PostgreSQL Debian package: Question on conditions for creation of new cluster

You should ask on the pgsql-pkg-debian mailing list, that's where the packager is listening. Yours, Laurenz Albe -- *E-Mail Disclaimer* Der Inhalt dieser E-Mail ist ausschliesslich fuer den bezeichneten Adressaten bestimmt. Wenn Sie nicht der vorgesehene Adressat dieser E-Mail oder dessen Ver

Re: AW: PGDG PostgreSQL Debian package: Question on conditions for creation of new cluster

On 2025-Feb-19, Schmid Andreas wrote: > Maybe there generally is no cluster created if there is one present > already. I now checked > /usr/share/postgresql-common/maintscripts-functions which is installed > by the postgresql-common_273.pgdg24.04+1_all.deb package. This script &g

AW: PGDG PostgreSQL Debian package: Question on conditions for creation of new cluster

> -Ursprüngliche Nachricht- > On Wed, 2025-02-19 at 08:45 +, Schmid Andreas wrote: > > I'm trying to install the postgresql-17 Debian package from PGDG apt > > repo alongside an already existing PostgreSQL 16 installation. So > > there is already a Postgr

Re: PGDG PostgreSQL Debian package: Question on conditions for creation of new cluster

On Wed, 2025-02-19 at 08:45 +, Schmid Andreas wrote: > I'm trying to install the postgresql-17 Debian package from PGDG apt repo > alongside an already existing PostgreSQL 16 installation. So there is > already a PostgreSQL 16 cluster on my machine (which I want to upgrade &

PGDG PostgreSQL Debian package: Question on conditions for creation of new cluster

Hi I'm trying to install the postgresql-17 Debian package from PGDG apt repo alongside an already existing PostgreSQL 16 installation. So there is already a PostgreSQL 16 cluster on my machine (which I want to upgrade to version 17 using the pg_upgrade command later on). If I'm not

Re: The performance issues caused by upgrading PostgreSQL to version 16.3.

On 2/16/25 23:55, 馬 騰飛 wrote: Dear PostgreSQL Community, I hope this message finds you well. I am reaching out to seek your technical assistance regarding a performance issue we encountered after upgrading our PostgreSQL version from 12.19 to 16.3. We have noticed a significant performance

Re: The performance issues caused by upgrading PostgreSQL to version 16.3.

post installing, did you run analyze verbose? -Doron On Mon, Feb 17, 2025 at 4:23 PM Greg Sabino Mullane wrote: > On Mon, Feb 17, 2025 at 2:55 AM 馬 騰飛 wrote: > >> Interestingly, when we isolate the problematic SQL statement and replace >> its parameters with actual values, it executes in just

Re: The performance issues caused by upgrading PostgreSQL to version 16.3.

On Mon, Feb 17, 2025 at 2:55 AM 馬 騰飛 wrote: > Interestingly, when we isolate the problematic SQL statement and replace > its parameters with actual values, it executes in just a few seconds in > pgAdmin. > However, when we run the same SQL query through our application using > Npgsql, it takes ov

Re: The performance issues caused by upgrading PostgreSQL to version 16.3.

On Mon, Feb 17, 2025 at 2:55 AM 馬 騰飛 wrote: > Dear PostgreSQL Community, > > I hope this message finds you well. I am reaching out to seek your > technical assistance regarding a performance issue we encountered after > upgrading our PostgreSQL version from 12.19 to 16.3. >

Re: The performance issues caused by upgrading PostgreSQL to version 16.3.

On Mon, 2025-02-17 at 07:55 +, 馬　騰飛 wrote: > I am reaching out to seek your technical assistance regarding a performance > issue we encountered after upgrading our PostgreSQL version from 12.19 to > 16.3. > We have noticed a significant performance problem with a specific SQL qu

The performance issues caused by upgrading PostgreSQL to version 16.3.

Dear PostgreSQL Community, I hope this message finds you well. I am reaching out to seek your technical assistance regarding a performance issue we encountered after upgrading our PostgreSQL version from 12.19 to 16.3. We have noticed a significant performance problem with a specific SQL query

Re: Understanding ALTER DEFAULT PRIVILEGES Behavior in PostgreSQL

On Tue, Feb 4, 2025 at 1:50 PM Ayush Vatsa wrote: > Also, what would be the best way to ensure that, by default, no roles > (except the function owner) have any privileges on new functions created in > my protected schema? > Create them in another schema altogether, then move it to my_schema once

Re: Understanding ALTER DEFAULT PRIVILEGES Behavior in PostgreSQL

On Tuesday, February 4, 2025, Ayush Vatsa wrote: > > postgres=# ALTER DEFAULT PRIVILEGES IN SCHEMA my_schema REVOKE EXECUTE ON > FUNCTIONS FROM PUBLIC; > ALTER DEFAULT PRIVILEGES > As the documentation explains: Default privileges that are specified per-schema are added to whatever the global de

Understanding ALTER DEFAULT PRIVILEGES Behavior in PostgreSQL

Hello PostgreSQL Community, I was experimenting with default privileges in PostgreSQL and came across a behavior I didn’t fully understand. I would appreciate any insights on this. I wanted to ensure that, by default, no roles had EXECUTE privileges on functions created in my schema. To achieve

Re: Postgresql database terminates abruptly with too many open files error

On 2025-01-15 11:42:30 +, Sri Mrudula Attili wrote: > The max_connections =200 and max_files_per_process =1000 as you mentioned. > > So should a max_files_per_process =500 helps? > > > I could see from the number of connections to the databaseis not exceeding > 20. But still these 20 are cau

Re: Postgresql database terminates abruptly with too many open files error

-- Forwarded message - From: Sri Mrudula Attili Date: Wed, 15 Jan, 2025, 17:12 Subject: Re: Postgresql database terminates abruptly with too many open files error To: Tom Lane Cc: Hello Tom, The max_connections =200 and max_files_per_process =1000 as you mentioned. So

Re: Intermittent errors when fetching cursor rows on PostgreSQL 16

Il 15/01/25 17:03, Adrian Klaver ha scritto: On 1/14/25 23:46, Enrico Schenone wrote: Which environment did you run the recent prolonged test against? The first one: Distinct application server and DB server on distinct subnets. Is that the same as where you saw the errors? Yes. *Enric

Re: Intermittent errors when fetching cursor rows on PostgreSQL 16

On 1/14/25 23:46, Enrico Schenone wrote: Which environment did you run the recent prolonged test against? The first one: Distinct application server and DB server on distinct subnets. Is that the same as where you saw the errors? *Enrico Schenone* Software Architect -- Adrian Klaver adr

Re: Postgresql database terminates abruptly with too many open files error

quota. Thanks, Sri On 14/01/2025 14:19, Tom Lane wrote: Sri Mrudula Attili writes:  We have a postgresql VDB(virtual database- Delphix) that keeps terminating due "to too many open files". What do you have max_connections set to, and how many actually-live server processes

Re: Intermittent errors when fetching cursor rows on PostgreSQL 16

ected on firewall, no memory/disk/network failure     detected by "nmon" tool)   * Distinct application server and DB server on same subnet (no firewall)   * Same server for PostgreSQL and applications " In all those cases are the various servers all running completely

Re: Fwd: Lock in postgreSQL

, Jan 14, 2025 at 12:50 AM Subject: Lock in postgreSQL To: pgsql-generallists.postgresql.org , PostgreSQL ODBC list Hi, ALL, https://www.postgresql.org/docs/current/functions-admin.html#FUNCTIONS-ADVISORY-LOCKS There is an explanation about a promissory lock functions(). I have 2 questions about

Fwd: Lock in postgreSQL

Hi, ALL, This concern both libpq and DBC API. Hopefully I can get answers on both. Than yu. -- Forwarded message - From: Igor Korot Date: Tue, Jan 14, 2025 at 12:50 AM Subject: Lock in postgreSQL To: pgsql-generallists.postgresql.org , PostgreSQL ODBC list Hi, ALL, https

Re: Intermittent errors when fetching cursor rows on PostgreSQL 16

ilure     detected by "nmon" tool)   * Distinct application server and DB server on same subnet (no firewall)   * Same server for PostgreSQL and applications " In all those cases are the various servers all running completely within the providers infrastructure? No, the second pr

Re: Postgresql database terminates abruptly with too many open files error

Sri Mrudula Attili writes: >  We have a postgresql VDB(virtual database- Delphix) that keeps > terminating due "to too many open files". What do you have max_connections set to, and how many actually-live server processes are there typically? > The number of allowed openfi

Re: Postgresql database terminates abruptly with too many open files error

On Tue, Jan 14, 2025 at 7:58 AM Sri Mrudula Attili wrote: > Hello Team, > > We have a postgresql VDB(virtual database- Delphix) that keeps > terminating due "to too many open files". > > Below are few alerts that we could see from the postgresql.log > > &g

Re: Postgresql database terminates abruptly with too many open files error

Hello, Have you checked something like lsof to see open file descriptors to see? Cheers, frank Am 14.01.25 um 13:58 schrieb Sri Mrudula Attili: Hello Team,  We have a postgresql VDB(virtual database- Delphix) that keeps terminating due "to too many open files". Below are few a

Postgresql database terminates abruptly with too many open files error

Hello Team,  We have a postgresql VDB(virtual database- Delphix) that keeps terminating due "to too many open files". Below are few alerts that we could see from the postgresql.log < 2025-01-14 11:37:20.724 GMT >LOG:  out of file descriptors: Too many open files in sys

Re: About PostgreSQL Query Plan

Hello, Okay, thank you very much, Mr. David, for your support and the information, Eşref To: Eşref Halıcıoğlu (esref.halicio...@primeit.com.tr);Cc: pgsql-general@lists.postgresql.org;Subject: About PostgreSQL Query Plan;14.01.2025, 13:09, "David Rowley" :On Tue, 14 Jan

Re: About PostgreSQL Query Plan

On Tue, 14 Jan 2025 at 03:45, Eşref Halıcıoğlu wrote: > I do not fully understand the logic of this issue. I would be very grateful > if you can share information on the subject. > > The query plan is as follows. > > Update on "test_table1" tt1 (cost=0.13..159112.84 rows=0 width=0) > Update on

Re: Intermittent errors when fetching cursor rows on PostgreSQL 16

ified against the Postgresql log. The only component not under my control is the Provider's Infrastructure, but  the infrastructure admin ensured me that no operation at all has been made. I beleave him because it is a reliable tecnician end a well known person. In your OP you stated: &

Re: About PostgreSQL Query Plan

would be very grateful if you could help me. Thank you, Eşref Halıcıoğlu To: Eşref Halıcıoğlu (esref.halicio...@primeit.com.tr);Cc: pgsql-general@lists.postgresql.org;Subject: About PostgreSQL Query Plan;13.01.2025, 19:56, "hubert depesz lubaczewski" :On Mon, Jan 13, 2025 at

Re: About PostgreSQL Query Plan

;))  ->  Index Scan using partitiontable_2024_12_pkey on "PartitionTable_2024_12" t4  (cost=0.43..4.34 rows=1 width=38) (never executed)    Index Cond: (("Col1" = tmp."Col2") AND ("Col3" >= (CURRENT_DATE - '3 mons'::interval))

Re: Intermittent errors when fetching cursor rows on PostgreSQL 16

for a week, and again no error at all. No setup was changed nor servers was rebooted, nor infrastructure has been upgraded during the test period. You are absolutely sure about the above? I can say Yes. All test operations has been logged and verified against the Postgresql log. The only comp

Re: About PostgreSQL Query Plan

On Mon, Jan 13, 2025 at 08:01:56PM +0300, Eşref Halıcıoğlu wrote: > Yes, you are right; it seems that only 4 batches had data changes. However, > the query also accessed other batches and then removed > them again. What could be the reason for this and how can it be solved? >   > Obviously, I woul

Re: Intermittent errors when fetching cursor rows on PostgreSQL 16

No setup was changed nor servers was rebooted, nor infrastructure has been upgraded during the test period. You are absolutely sure about the above? I can say Yes. All test operations has been logged and verified against the Postgresql log. The only component not under my control is the Provi

Re: About PostgreSQL Query Plan

On Mon, Jan 13, 2025 at 07:48:09PM +0300, Eşref Halıcıoğlu wrote: > Hello, >   > Yes, you are right; this query is not a SELECT, it is an UPDATE query, there > was a mistake in expressing it here. The columns I want > to update here only operate on data from the last 3 months time interval. >   >

Re: Intermittent errors when fetching cursor rows on PostgreSQL 16

On 1/13/25 00:45, Enrico Schenone wrote: Hello, Adrian. As I said days ago, I have arranged a kind of stress test in production environment. I wrote a program that loads a temporary table, loads 2049 rows into them from a baseline_table and finally declare two nested cursors. The first cursor i

Re: About PostgreSQL Query Plan

On Mon, Jan 13, 2025 at 05:26:09PM +0300, Eşref Halıcıoğlu wrote: > Hello, >   > I have a query in PostgreSQL and I want this query to retrieve only data from > the last 3 months. However, when I examine the query > plan, I see that all partitions are listed. Please note that your

About PostgreSQL Query Plan

Hello, I have a query in PostgreSQL and I want this query to retrieve only data from the last 3 months. However, when I examine the query plan, I see that all partitions are listed. This raises a few questions in my mind:Are all partitions really being accessed, or only the partitions of the last

Re: Intermittent errors when fetching cursor rows on PostgreSQL 16

Hello, Adrian. As I said days ago, I have arranged a kind of stress test in production environment. I wrote a program that loads a temporary table, loads 2049 rows into them from a baseline_table and finally declare two nested cursors. The first cursor is on the temp table as parent while the se

Re: name difference of rpm packages of postgresql-private-devel-16.6.z

On Mon, 2024-12-30 at 16:53 +0530, Ravi Dave wrote: > Out of curiosity, I wanted to know the meaning of "private" in  > postgresql-private-devel-16.6. > rpm package name. Ideally, I saw postgresql-devel-* rpm packages, so I want > to know if there > is any specific reas

  1   2   3   4   5   6   7   8   9   10   >