Re: tutorial problem solution requires that problem is already fixed - Mailing list pgsql-docs

From David G. Johnston
Subject Re: tutorial problem solution requires that problem is already fixed
Date
Msg-id CAKFQuwYc0AucrGkdZRjEqJ4kZCGV-QAmHf6nZLq_Svg7zxaokg@mail.gmail.com
Whole thread Raw
In response to tutorial problem solution requires that problem is already fixed  (PG Doc comments form <noreply@postgresql.org>)
List pgsql-docs
On Tue, Feb 15, 2022 at 8:04 AM PG Doc comments form <noreply@postgresql.org> wrote:
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/14/role-attributes.html
Description:

I am reporting my roadblock, so it can be better documented in the future.

I am following this tutorial:
https://www.postgresql.org/docs/14/tutorial-createdb.html
I got the error "createdb: error: connection to server on socket
"/tmp/.s.PGSQL.5432" failed: FATAL:  role "joe" does not exist", so I went
to the chapter 22 "https://www.postgresql.org/docs/14/user-manag.html", then
"https://www.postgresql.org/docs/14/database-roles.html". But from there it
is already an SQL command. How am I supposed to do that if I didn't even
created the database yet? Where should I execute those?

Elsewhere you should have already learned that PostgreSQL solves the bootstrap problem by creating an initial superuser and database during the running of the "initdb" command.  You connect as that user to that database to create your second user (and possibly database).  Both are named "postgres" by default.  Though the documentation mostly concerns itself with compiled-from-source installations; whatever package you installed usually with provide additional information as to how to work with the system immediately after installation.

David J.

pgsql-docs by date:

Previous
From: PG Doc comments form
Date:
Subject: Doc says nothing about wether CREATE OR REPLACE VIEW can change the COLLATION of an existing field
Next
From: "David G. Johnston"
Date:
Subject: Re: Doc says nothing about wether CREATE OR REPLACE VIEW can change the COLLATION of an existing field