Re: PostgreSQL 15.10 update corrective action for ATTACH PARTITION/DETACH PARTITION

Hello, Belatedly, I came back to this issue in the release notes. Here's a query for correctly reporting the problem and not reporting the cases where there isn't a problem: SELECT conrelid::pg_catalog.regclass AS "constrained table", conname AS constraint, confrelid::pg_catalog.re

Re: PostgreSQL 15.10 update corrective action for ATTACH PARTITION/DETACH PARTITION

Alvaro Herrera writes: > I'm going to fix the query in the release notes for all past branches > now, to avoid confusing people upgrading in the future ... hopefully not > many, but I don't think it's going to be zero people. OK, thanks. regards, tom lane

Re: Postgresql 18beta1 and SPI changes

PostgreSQL 17, I only got minor compilation problems that I managed to resolve fairly easily. However this didn't prove to be the case with PostgreSQL 18beta1, it proved harder to compile and as my fears were verified, it has serious problems. My question : is 18's SPI stabilized ? Can I start w

Re: Postgresql 18beta1 and SPI changes

Dear All, Dear Tom On 5/11/25 16:20, Tom Lane wrote: Achilleas Mantzios writes: We use are own version of DBmirror, we run our replication in a highly fine grained manner. So every upgrade I have to make the code compile and test. Up to PostgreSQL 17, I only got minor compilation problems

Re: Updating to PostgreSQL 17.5

Hi Tom, > On 11 May 2025, at 21:36, Tom Lane wrote: > > Sorry --- it means BRIN indexes that use one of the "xxx_bloom_ops" opclasses. > > https://www.postgresql.org/docs/current/brin.html#BRIN-BUILTIN-OPCLASSES Ah, so that'd reduce my monster query to: select concat ('reindex index "', s

Re: Updating to PostgreSQL 17.5

Paul Foerster writes: > the release notes for PostgreSQL 17.5 > (https://www.postgresql.org/docs/17/release-17-5.html) state: > "Also, if you have any BRIN bloom indexes, it may be advisable to reindex > them after updating." > I don't know what exactly that m

Updating to PostgreSQL 17.5

Hi, the release notes for PostgreSQL 17.5 (https://www.postgresql.org/docs/17/release-17-5.html) state: "Also, if you have any BRIN bloom indexes, it may be advisable to reindex them after updating." I don't know what exactly that means. So I read about BRIN and BLOOM indexes

Re: Postgresql 18beta1 and SPI changes

Achilleas Mantzios writes: > We use are own version of DBmirror, we run our replication in a highly > fine grained manner. So every upgrade I have to make the code compile > and test. Up to PostgreSQL 17, I only got minor compilation problems > that I managed to resolve fairly eas

Postgresql 18beta1 and SPI changes

Dear members We use are own version of DBmirror, we run our replication in a highly fine grained manner. So every upgrade I have to make the code compile and test. Up to PostgreSQL 17, I only got minor compilation problems that I managed to resolve fairly easily. However this didn't pro

Re: Issue Launching PostgreSQL on MacBook M4 – Error -10669‏

https://www.postgresql.org/download/macosx/, personally I'd > give Postgres.app a. try or the installation via Homebrew (A bit less easy > than the GUI app) > > Philipp > > On Thu, May 8, 2025, at 8:17 PM, איתי זרחוביץ wrote: > > ,Hello > I have a MacBook with an M4 ch

Re: Issue Launching PostgreSQL on MacBook M4 – Error -10669‏

There's multiple ways recommended on > https://www.postgresql.org/download/macosx/, personally I'd > give Postgres.app a. try or the installation via Homebrew (A bit less easy > than the GUI app) > > Philipp > > On Thu, May 8, 2025, at 8:17 PM, איתי זרחוביץ wrote: &

Re: Looking for pgbench Benchmark Results Across PostgreSQL Versions

sults Across PostgreSQL Versions Hi everyone, I’ve been searching for a website that provides pgbench results for different PostgreSQL versions, from 11 to 18, including the latest beta or alpha releases. Does anyone know of such a site? Thanks!

Re: Looking for pgbench Benchmark Results Across PostgreSQL Versions

> On 8 May 2025, at 22:07, Özkan Pakdil wrote: > > Hi everyone, > I’ve been searching for a website that provides pgbench results for different > PostgreSQL versions, from 11 to 18, including the latest beta or alpha > releases. > Does anyone know of such a site? There

Re: Issue Launching PostgreSQL on MacBook M4 – Error -10669‏

u doing to see this error message? >>>> >>>> There's multiple ways recommended on >>>> https://www.postgresql.org/download/macosx/, personally I'd give >>>> Postgres.app a. try or the installation via Homebrew (A bit less easy than >&

Re: Issue Launching PostgreSQL on MacBook M4 – Error -10669‏

oing to see this error message? >> >> There's multiple ways recommended on >> https://www.postgresql.org/download/macosx/, personally I'd give >> Postgres.app a. try or the installation via Homebrew (A bit less easy than >> the GUI app) >> &

Re: Issue Launching PostgreSQL on MacBook M4 – Error -10669‏

Homebrew (A bit less easy than the GUI app) Philipp On Thu, May 8, 2025, at 8:17 PM, איתי זרחוביץ wrote: > ,Hello > I have a MacBook with an M4 chip. I tried installing PostgreSQL version 17.5, > but after the > installation, I received the following error > _LSOpenURLsWithComplet

Looking for pgbench Benchmark Results Across PostgreSQL Versions

Hi everyone, I’ve been searching for a website that provides pgbench results for different PostgreSQL versions, from 11 to 18, including the latest beta or alpha releases. Does anyone know of such a site? Thanks!

Re: Issue Launching PostgreSQL on MacBook M4 – Error -10669

On 5/8/25 12:41, איתי זרחוביץ wrote: You need to remember to hit Reply All so the list is included in the conversation. Ccing list I tried before a hour to download Try now and see what happens. Also try the postgres.app link I posted previously. -- Adrian Klaver adrian.kla...@aklaver

Re: Issue Launching PostgreSQL on MacBook M4 – Error -10669

On 5/8/25 12:02, איתי זרחוביץ wrote: Reply to list also: Ccing list. I tried to download from this link: https://www.enterprisedb.com/downloads/postgres-postgresql-downloads <https://www.enterprisedb.com/downloads/postgres-postgresql-downloads> and than i got the

Re: Issue Launching PostgreSQL on MacBook M4 – Error -10669

On 5/8/25 05:17, איתי זרחוביץ wrote: ,Hello I have a MacBook with an M4 chip. I tried installing PostgreSQL version 17.5, but after the installation, I received the following error | _LSOpenURLsWithCompletionHandler() failed with error -10669 (1) .and the application fails to launch A

Re: EDB Download for PostgreSQL 17.5 is broken

Hi Ertan Correct Version 17.5.0 is being downloaded and it may be a cache issue. Regards Kashif Zeeshan EDB On Thu, May 8, 2025 at 9:29 PM Ertan Küçükoglu wrote: > Hello, > > I am just writing here with the hope that there are some EDB contacts here. > > The 17.5 version Windows x86-64 downloa

Re: EDB Download for PostgreSQL 17.5 is broken

563> and this is actually getting you a 17.4-2 download. When I click on the link I above I get 17.5-1. When I click through from here: https://www.enterprisedb.com/downloads/postgres-postgresql-downloads I get 17.4-2. Looks like some sort of caching issue. Thanks & Regards, Ertan

EDB Download for PostgreSQL 17.5 is broken

Hello, I am just writing here with the hope that there are some EDB contacts here. The 17.5 version Windows x86-64 download link on EDB is https://sbp.enterprisedb.com/getfile.jsp?fileid=1259563 and this is actually getting you a 17.4-2 download. Thanks & Regards, Ertan

Re: SQL ERROR subquery uses ungrouped column in PostgreSQL

On Thu, 1 May 2025 at 00:29, PALAYRET Jacques wrote: > => In the subquery, the semantic analysis of the query considers the column " > dat " instead of the expression " to_char(dat,'mm') ", which is actually > a grouped column. > Is this normal? How can I simply resolve the problem? Calcula

SQL ERROR subquery uses ungrouped column in PostgreSQL

Hello, I have an unexpected error in my following query (of course, the query has been simplified here to request help): SELECT num_poste, to_char(dat, 'MM')::integer dat, CASE FLOOR((TO_NUMBER(TO_CHAR(dat,'DD'),'99')-1)/10) WHEN 0 THEN 1 WHEN 1 THEN 2 ELSE 3 END::smallint AS num_decade

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

  1   2   3   4   5   6   7   8   9   10   >