On Tue, Feb 15, 2022 at 8:04 AM PG Doc comments form <nore...@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.
