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

2025-10-13 Thread Ron Johnson
On Sat, Oct 11, 2025 at 11:21 PM Adrian Klaver wrote: > 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

Enquiry about TDE with PgSQL

2025-10-13 Thread Ashish Mukherjee
Hello, Thank you to the group members for the responses to my previous questions about TDE problems with PgSQL 17. I would like to enquire that based on the anecdotal experience of group members, which TDE solution works best for PgSQL 17 databases. The scenario I have is of a large number of tab

Re: Database in another drive

2025-10-13 Thread Adrian Klaver
On 10/13/25 14:57, Ron Johnson wrote: On Mon, Oct 13, 2025 at 4:19 PM Arbol One > wrote: Is there a way to either create the database or save the data in another drive? I am using Win11, not my choice since 1998, and, not surprisingly, the WinOS had a

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

2025-10-13 Thread Ron Johnson
On Sat, Oct 11, 2025 at 7:11 PM Adrian Klaver wrote: > 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

Re: Database in another drive

2025-10-13 Thread Ron Johnson
On Mon, Oct 13, 2025 at 4:19 PM Arbol One wrote: > Is there a way to either create the database or save the data in another > drive? > > I am using Win11, not my choice since 1998, and, not surprisingly, the > WinOS had a crash; > I've been using Windows on (local, telecommuting) corporate PCs f

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

2025-10-13 Thread Ron Johnson
On Mon, Oct 13, 2025 at 3:19 PM David Barsky wrote: [snip] > 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? E.g., something similar to

Re: Database in another drive

2025-10-13 Thread John McKown
https://www.google.com/search?q=create+postgres+database+on+e%3A&oq=create+postgres+database+on+e%3A&gs_lcrp=EgZjaHJvbWUyBggAEEUYOdIBCTI5MjI0ajBqN6gCD7ACAQ&client=ms-android-google&sourceid=chrome-mobile&ie=UTF-8 On Mon, Oct 13, 2025, 15:19 Arbol One wrote: > Is there a way to either create the

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

2025-10-13 Thread Dominique Devienne
On Mon, Oct 13, 2025 at 4:16 AM Tom Lane wrote: > Rob Sargent writes: > > On 10/12/25 16:10, David Barsky wrote: > >>> Postgres is not an embedded database, if you want that experience then > >>> use a database that is designed to be embedded. > >>> That's fair, especially from an operational sta