On Thursday, December 12, 2024, PG Doc comments form <nore...@postgresql.org> wrote:
> The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/17/tutorial-createdb.html > Description: > > Folowing the online docs @ > https://www.postgresql.org/docs/17/tutorial-createdb.html > it says: "To create a new database, in this example named mydb, you use the > following command: > > $ createdb mydb" > When performing it error comes: > "createdb: error: connection to server on socket > "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL: role "root" does not > exist" > No matter what explanation there is for it, this is supposed to be official > documentation. It MUST be right. > The documentation is required to make some assumptions/requirements regarding the operating context of the examples. Namely, you are running commands as the OS user postgres, and that user can peer authenticate (or trust…) into the default location for where you initdb’d and the cluster (discussed earlier in the documentation). You are running the command as root and thus violating those requirements. IOW, it is correct but has pre-requisites that you haven’t followed. There is no good way to make such an example entirely self-contained and pre-requisite free. But if you’d like to suggest an improvement we are open to making tweaks. David J.
