Thread: tutorial problem solution requires that problem is already fixed
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?
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.