public inbox for [email protected]
help / color / mirror / Atom feedFrom: David G. Johnston <[email protected]>
To: [email protected]
To: Pg Docs <[email protected]>
Subject: Re: tutorial problem solution requires that problem is already fixed
Date: Tue, 15 Feb 2022 08:08:19 -0700
Message-ID: <CAKFQuwYc0AucrGkdZRjEqJ4kZCGV-QAmHf6nZLq_Svg7zxaokg@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
On Tue, Feb 15, 2022 at 8:04 AM PG Doc comments form <[email protected]>
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.
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: tutorial problem solution requires that problem is already fixed
In-Reply-To: <CAKFQuwYc0AucrGkdZRjEqJ4kZCGV-QAmHf6nZLq_Svg7zxaokg@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox