Re: tutorial problem solution requires that problem is already fixed

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: germano(dot)thomas(at)cwi(dot)com(dot)br, Pg Docs <pgsql-docs(at)lists(dot)postgresql(dot)org>
Subject: Re: tutorial problem solution requires that problem is already fixed
Date: 2022-02-15 15:08:19
Message-ID: CAKFQuwYc0AucrGkdZRjEqJ4kZCGV-QAmHf6nZLq_Svg7zxaokg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

On Tue, Feb 15, 2022 at 8:04 AM PG Doc comments form <noreply(at)postgresql(dot)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.

In response to

Browse pgsql-docs by date

  From Date Subject
Next Message David G. Johnston 2022-02-15 15:10:00 Re: Doc says nothing about wether CREATE OR REPLACE VIEW can change the COLLATION of an existing field
Previous Message PG Doc comments form 2022-02-15 08:29:39 Doc says nothing about wether CREATE OR REPLACE VIEW can change the COLLATION of an existing field