On Thursday, December 12, 2024, PG Doc comments form <
noreply@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.
