Re: Documentation for initdb option --waldir

2025-03-29 Thread David G. Johnston
On Saturday, March 29, 2025, Robert Treat wrote: > On Thu, Mar 27, 2025 at 5:57 PM David G. Johnston > wrote: > > On Thu, Mar 27, 2025 at 2:28 PM Robert Treat wrote: > >> On Thu, Mar 27, 2025 at 12:06 PM David G. Johnston > >> wrote: > >> > I expanded upon the material regarding using differen

Re: Documentation for initdb option --waldir

2025-03-29 Thread Laurenz Albe
On Sat, 2025-03-29 at 10:26 -0400, Robert Treat wrote: > "Best practice is to create a directory within the mount-point > directory that is owned by the PostgreSQL user, and then create the > data directory within that. This avoids permissions problems,..." > > Which I do remember having tried to

Re: Documentation for initdb option --waldir

2025-03-29 Thread David G. Johnston
On Saturday, March 29, 2025, Gurjeet Singh wrote: > On Sat Mar 29, 2025 at 9:26 AM PDT, Laurenz Albe wrote: > > > On the other hand, PostgreSQL will protest if the directory isn't > > empty... > > Specifically, initdb will complain if the directory it's trying to > initialize is not empty. > For

Re: Documentation for initdb option --waldir

2025-03-29 Thread Gurjeet Singh
On Sat Mar 29, 2025 at 9:26 AM PDT, Laurenz Albe wrote: > On the other hand, PostgreSQL will protest if the directory isn't > empty... Specifically, initdb will complain if the directory it's trying to initialize is not empty. Best regards, Gurjeet http://Gurje.et

Re: Documentation for initdb option --waldir

2025-03-29 Thread Gurjeet Singh
On Sat Mar 29, 2025 at 7:26 AM PDT, Robert Treat wrote: > On Thu, Mar 27, 2025 at 5:57 PM David G. Johnston > wrote: >> On Thu, Mar 27, 2025 at 2:28 PM Robert Treat wrote: >>> On Thu, Mar 27, 2025 at 12:06 PM David G. Johnston >>> wrote: >>> > I expanded upon the material regarding using differe

Re: Documentation for initdb option --waldir

2025-03-29 Thread Robert Treat
On Sat, Mar 29, 2025 at 10:58 AM David G. Johnston wrote: > > On Saturday, March 29, 2025, Robert Treat wrote: >> >> On Thu, Mar 27, 2025 at 5:57 PM David G. Johnston >> wrote: >> > On Thu, Mar 27, 2025 at 2:28 PM Robert Treat wrote: >> >> On Thu, Mar 27, 2025 at 12:06 PM David G. Johnston >> >

Re: Creating first database

2025-03-29 Thread Gurjeet Singh
On Sat Mar 29, 2025 at 6:56 AM PDT, Tom Lane wrote: > PG Doc comments form writes: >> In the Getting Started section of the documentation which would be used by a >> new user immediately after installing PostgreSQL, the user is asked to run >> $ createdb mydb >> If the database is correctly instal

Re: Creating first database

2025-03-29 Thread David G. Johnston
On Friday, March 28, 2025, PG Doc comments form wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/17/tutorial-createdb.html > Description: > > In the Getting Started section of the documentation which would be used by > a > new

Re: Documentation for initdb option --waldir

2025-03-29 Thread Robert Treat
On Thu, Mar 27, 2025 at 5:57 PM David G. Johnston wrote: > On Thu, Mar 27, 2025 at 2:28 PM Robert Treat wrote: >> On Thu, Mar 27, 2025 at 12:06 PM David G. Johnston >> wrote: >> > I expanded upon the material regarding using different file systems and >> > disks. >> > >> > I would like to add a

Re: Creating first database

2025-03-29 Thread Tom Lane
PG Doc comments form writes: > In the Getting Started section of the documentation which would be used by a > new user immediately after installing PostgreSQL, the user is asked to run > $ createdb mydb > If the database is correctly installed, this first command to be run by the > new user inevit

Creating first database

2025-03-29 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/tutorial-createdb.html Description: In the Getting Started section of the documentation which would be used by a new user immediately after installing PostgreSQL, the user is asked to run

Re: Ambiguity in IS JSON description and logic

2025-03-29 Thread noname stranger
Hello Kirk, Thank you for your answer and detailed explanation. You are absolutely right, I made a mistake in my reasoning. On the other hand, some ambiguity exists. It is a perfect idea to clarify what WITHOUT UNIQUE KEYS means. Such clarification could help with understanding the logic of IS JS