Re: Does Java 8 support drivers 42.2.19 and 42.7.6?

On 10/6/25 01:01, Артем Романюк wrote: Good afternoon! Dear PostgreSQL community. Can I ask the developers if Java 8 officially supports drivers 42.2.19 and 42.7.6? It is important that support is provided fully and without problems. 1) Why not use the latest minor version? 2) "... provided

Re: Option on `postgres` CLI to shutdown when there are no more active connections?

On 10/8/25 12:39, David Barsky wrote: Hiya folks, I'm a bit of a newcomer when it comes to PostgreSQL, so I apologize if this is the wrong mailing list. Anyways, my two questions: 1. Is there any interest in adding a command line option to the `postgres` CLI    that shuts down the PostgreSQ

Re: Alerting on memory use and instance crash

Thank you so much. That helps. I am planning to use pg_stat_get_backend_memory_contexts function something as below by joining this to the pg_stat_activity. Hope this is the right usage. Somehow i am getting an error stating the function doesn't exist but it might be because of the version. I will

JSONB subscripting initializes numeric keys as arrays instead of objects

I'm using PostgreSQL 16+ and working extensively with jsonb columns using JSON subscripting paths (as described here: PostgreSQL docs – jsonb subscripting

Re: Alerting on memory use and instance crash

On Wed, Oct 8, 2025 at 11:42 AM sud wrote: > Hi Experts, > > It's postgres version 16. I have two questions on alerting as below. > > 1)If we want to have alerting on any node/instance that gets crashed :- In > other databases like Oracle the catalog Views like "GV$Instance" used to > give inform

Re: Direct Major Upgrade (13.7 → 17.6) with pg_upgrade: Clarifying the need for Intermediate Minor Fixes/Scripts

On Wed, Oct 1, 2025 at 3:47 AM Vu Le (JData - HN) wrote: > My question is: When performing a direct jump from 13.7 to 17.6 using > pg_upgrade, do I need to manually identify and execute the cumulative extra > works/fixes from ALL the skipped intermediate versions (13.8, 13.9, 14.x, > 15.x, 16.x)?

Re: Are compression requirements needed when building only libraries?

On Thu, 2025-10-09 at 13:10 +0200, Uilian Ries wrote: > Greetings! > > I'm building PostgreSQL 17.5 locally, on Ubuntu 22.04, and using a CPU > architecture x86_64. > > I noted the meson_options.txt file contains a few optional dependencies, like > zstd, zlib, lz4, libxml, and libxslt, which mos

Re: Option on `postgres` CLI to shutdown when there are no more active connections?

> "Testing" db interaction in a faked, circumscribed > only-my-stuff-is-there world is folly. Certainly each db developer > needs their own instance of the database (on their own box or a > server). And it needs to be kept current with both DDL and domain meta > data changes (see things like flyway

Re: PostgreSQL 18 not available for Noble?

On 9/28/25 14:04, Ray O'Donnell wrote: On 28 September 2025 21:54:01 Adrian Klaver wrote: On 9/28/25 13:46, Ray O'Donnell wrote: Hi all, As per $subject - is PG 18 not available for Ubuntu Noble (24.04)? According to the below it is: https://www.postgresql.org/download/linux/ubuntu/

Re: Option on `postgres` CLI to shutdown when there are no more active connections?

On Mon, Oct 13, 2025 at 9:19 PM David Barsky wrote: > > SQLite is fantastic, but it's type-system and lock-model are too > > restrictive, > > for a general DB. Similar to David, I think PostgreSQL is close to my ideal > > above, yet still far-enough (and perhaps unwilling enough, as a community)

Re: Alerting on memory use and instance crash

On Wed, Oct 8, 2025 at 2:58 PM sud wrote: [snip] > Do you mean in normal Postgres it's alway a single instance/memory and > single storage attached? then I also do not see any such cluster level > views in aws aurora postgres too? > Yup. > Pardon if it's a silly one to ask. > A Google for "wh

Re: Option on `postgres` CLI to shutdown when there are no more active connections?

On 10/12/25 16:10, David Barsky wrote: > stop mode shuts down the server that is running in the specified data > > directory. Three different shutdown methods can be selected with the -m > > option. “Smart” mode disallows new connections, then waits for all > existing > clients to disconnect

Re: Can't create a table with vector type as a non-super user

mrudula attili writes: > But a non super user (a read write user of the database) is not able to > create a table with vector type and keeps getting the below error. > CREATE TABLE items (id bigserial PRIMARY KEY, embedding vector(3)) > [2025-09-30 09:22:29] [42704] ERROR: type "vector" does not

Re: PostgreSQL 18 not available for Noble?

On 28/09/2025 22:17, Adrian Klaver wrote: On 9/28/25 14:04, Ray O'Donnell wrote: On 28 September 2025 21:54:01 Adrian Klaver wrote: On 9/28/25 13:46, Ray O'Donnell wrote: Hi all, As per $subject - is PG 18 not available for Ubuntu Noble (24.04)? According to the below it is: https:/

High latency and profiling

Hello. Hope this email will keep the formatting this time.. I was notified about high latency on one of our PostgreSQL clusters. This latency is observed from the application and has been increasing. There is no indication about the exact database as the application uses several DBs, but the l

Re: Alerting on memory use and instance crash

On 10/8/25 08:42, sud wrote: Hi Experts, It's postgres version 16. I have two questions on alerting as below. 1)If we want to have alerting on any node/instance that gets crashed :- In other databases like Oracle the catalog Views like "GV$Instance" used to give information on whether the ins

Re: Downgrade pgsql 17 to pgsql 12 question

On Tue, Sep 30, 2025 at 3:47 AM Laurenz Albe wrote: > On Tue, 2025-09-30 at 13:53 +0530, Ashish Mukherjee wrote: > > Now the consideration is to use some other encryption option for the > > database which will work fine on pgsql 17. Cybertec's technology is > > one route, the other is EDB. I am h

Re: Alerting on memory use and instance crash

Thank you. The other question I had was , are there any pg_* views using which, we are able to see which session/connection is using the highest amount of memory? I don't see any such columns in pg_stats_activity. On Thu, Oct 9, 2025 at 12:37 AM Ron Johnson wrote: > On Wed, Oct 8, 2025 at 2:58 

Re: Option on `postgres` CLI to shutdown when there are no more active connections?

Dominique Devienne writes: > On Mon, Oct 13, 2025 at 5:08 PM Ron Johnson wrote: >> Shared memory means that I can stomp all over you, and you can't stop me. >> That's the antithesis of ACID. > SHM is how SQLite in WAL mode coordinates access to the same DB from > several connections. So if it'

Re: Option on `postgres` CLI to shutdown when there are no more active connections?

Greg Sabino Mullane writes: > On Mon, Oct 13, 2025 at 3:19 PM David Barsky wrote: >> Anyways, I'll try to get at what motivated this whole discussion: would >> there be community opposition to adding a CLI flag that'd exit/shutdown all >> Postgres processes once all pending connections close? >

High latency and profiling

Hello. I was notified about high latency on one of our PostgreSQL clusters. This latency is observed from the application and has been increasing. There is no indication about the exact database as the application uses several DBs, but the largest and most used is 'mydb'. So, a couple of months

Re: Quick questions about postgres name?

On 2025-Sep-23, Tom Lane wrote: > "Dan Mahoney (Gushi)" writes: > > It makes mention of the original professor who spearheaded the project > > under a DARPA grant, but it would probably do well to know where the name > > came from. > > You should read Joe Hellerstein's recollections [1]. But

Re: Upgrade & Rollback plan: My customer requests rollback via old-version standby (13 ↔ 17) — need community advice

On Sat, Oct 11, 2025 at 11:02:43PM +0700, Vu Le (JData - HN) wrote: > Thank you very much, Laurenz. > After reading several sources, I can confirm that this approach is > indeed not feasible at all. > I’m planning to prepare a short proposal and report to the customer, > focusing on the major risks

Re: Upgrade & Rollback plan: My customer requests rollback via old-version standby (13 ↔ 17) — need community advice

On Sat, 2025-10-11 at 23:02 +0700, Vu Le (JData - HN) wrote: > If possible, could you please share any additional best practices or > important considerations apart from testing the new version in a > staging environment? All I can think of is: - Always keep a backup around. - Read the "Migratio

Re: Downgrade pgsql 17 to pgsql 12 question

Hello Ashish Mukherjee, Did you get a chance to disable JIT related parameters after PG 17 upgrade ? If your database size in TB , try to consider pglogical bi directional replication. you will have 17.x version and 12.x version. if you ran in to any issue you can always switch back to old versi

Re: Option on `postgres` CLI to shutdown when there are no more active connections?

On 10/11/25 19:56, Ron Johnson wrote: On Sat, Oct 11, 2025 at 7:11 PM Adrian Klaver > wrote: I think OP is looking for AUTO_CLOSE, like SQL Server (and Rdb/VMS before it).  Its only real utility is OP's use-case: a Windows desktop running local testing. Fr

Re: Option on `postgres` CLI to shutdown when there are no more active connections?

On Mon, Oct 13, 2025 at 5:37 PM Tom Lane wrote: > Dominique Devienne writes: > > On Mon, Oct 13, 2025 at 5:08 PM Ron Johnson wrote: > >> Shared memory means that I can stomp all over you, and you can't stop me. > >> That's the antithesis of ACID. > > > SHM is how SQLite in WAL mode coordinates

Re: Enquiry about TDE with PgSQL

On Fri, Oct 17, 2025 at 12:49 AM Ron Johnson wrote: But filesystem encryption still means that validly logged-in users see the > unencrypted data. That's great for a laptop that might get stolen, or for > drives that are discarded without being wiped, but are no protection > against hackers who

Re: Option on `postgres` CLI to shutdown when there are no more active connections?

On October 14, 2025 9:40:45 PM UTC, David Barsky wrote: >> If testing is all scripted, then why not put "pg_ctl stop" at the end of >the script? > >Sorry for the delay. > >It’s _mostly_ scripted, but two major reasons: > >1. If that script is cancelled or interrupted for any reason, it’s possib

Re: Must to have and good to have extensions

On 10/17/25 08:20, veem v wrote: Hello Experts, I am comparatively new to postgres database and we are starting to use on premise postgres and also AWS aurora postgres for our applications. I know there are many extensions which are kind of additional features which by default do not come with

Postgre and AIO

This is more of a question of capability and to make me understand how exactly AIO work in Postgres. Now that AIO landed in v18, I was thinking of a use case which has annoyed me sometimes, which is inserting lots of data into a table with many indices. What I am specifically “complaining” is

Must to have and good to have extensions

Hello Experts, I am comparatively new to postgres database and we are starting to use on premise postgres and also AWS aurora postgres for our applications. I know there are many extensions which are kind of additional features which by default do not come with the installations. There are many suc

Re: executing Linux commands from the PostgreSQL server

Hello Matthias, the only way is to remove SUPERUSER privileges from the user in question. ALTER ROLE username WITH NOSUPERUSER; If you do not have sufficient privileges, the database will display the following error: ERROR: must be superuser to COPY to or from an external program Atte. JRBM El

Re: Enquiry about TDE with PgSQL

Am 2025-10-17 15:12, schrieb Greg Sabino Mullane: On Fri, Oct 17, 2025 at 12:49 AM Ron Johnson wrote: But filesystem encryption still means that validly logged-in users see the unencrypted data. That's great for a laptop that might get stolen, or for drives that are discarded without being wi

Re: Enquiry about TDE with PgSQL

On Fri, Oct 17, 2025 at 3:01 AM Laurenz Albe wrote: > On Fri, 2025-10-17 at 00:49 -0400, Ron Johnson wrote: > > On Thu, Oct 16, 2025 at 6:05 PM Greg Sabino Mullane > wrote: > > > > > > TDE, on the other hand, is a very complex and difficult thing to add > into Postgres. > > > > TDE was added to