Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nJzRb-0001xu-Ct for pgsql-docs@arkaria.postgresql.org; Tue, 15 Feb 2022 15:08:43 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nJzRa-000828-8X for pgsql-docs@arkaria.postgresql.org; Tue, 15 Feb 2022 15:08:42 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nJzRa-00081z-18 for pgsql-docs@lists.postgresql.org; Tue, 15 Feb 2022 15:08:42 +0000 Received: from mail-ua1-x92d.google.com ([2607:f8b0:4864:20::92d]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1nJzRX-0005pU-8f for pgsql-docs@lists.postgresql.org; Tue, 15 Feb 2022 15:08:41 +0000 Received: by mail-ua1-x92d.google.com with SMTP id 103so9974813uag.4 for ; Tue, 15 Feb 2022 07:08:38 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=mime-version:references:in-reply-to:from:date:message-id:subject:to; bh=gC1XbR9puNX+SsCJqlZ+/nl65BKRVe2xshyKletlFWk=; b=iFP2r1nzNEOn5U91UFuilvY2BYFBN0elskNoENb3znq3x2FcO7f53pLiyXXZbAcUfK e+iLj2jY5kA7nHZ21GpsUOLJ/oWSTMO2jQ+XbsOxTR2VMyP5tR9ULeYBg6M3UjxmYF9K 8aT+efJUB8zEm/8vZF4IHAmKnXJephtvJOO4/+NKdtj8ZQUVWIQ+bgjo6arrUqbe7WJA SEY9hKkrrOqmP2GXcdJPXCZE1aKuhuQZPBF364XZ5sSuSLuppTf4Vdjk30XlqS0y/5Tz NO6r74LMyHeYJezG11U617DqsFMBuJn7j0IwGAsXB4C4ORVba6jmPLDNWRIKYlIAGrCC 3WXg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to; bh=gC1XbR9puNX+SsCJqlZ+/nl65BKRVe2xshyKletlFWk=; b=fwkNgNHe5GY1gJuFDZSR1RXu4/syr/5ggEsIEt1TVzFQWIaa3TQdH6RV3vYRJhXH6f 0+JtLfe1EiQSYOx1K+op2Egkx03cNcZBdvo3uhdb9KxKRQTRp5wsMi6HPUOgtRIXui59 FzeJwTvXh1o7cpAZRMHTrHur4UWd9EvjdYsn0Tqu46vt2VfRVrqmuBG3jykeV8Puw9zd XjPtPbtHx6eEkc7wXqeh0g/BBOMJMxCdHcyPzGvkV8lGY7LoXJ/b5ObhRDX83Ck9YGvw AWpzhun//LJBy4v55dIRWUD9bhYqGKK0e5UMOR70f70RvGwKP3ogtihQaLnh/Qt8e+5R daOw== X-Gm-Message-State: AOAM532DCkWq6vHv2V3yT/GBu+7VBPt0iuYrTZgql30mNQO4EnIznLS7 1odgYxxvk0ESQ1bgIp5DNX6Rba8mDH1TaoQqz3s= X-Google-Smtp-Source: ABdhPJx8uqGOxKIBCn2ldNSDzDkdCyrrWC7GPoHXsohUdP2ZJlrbkmFhO2oafc/G/5RpaRFbB6x5/7lxf2014zy/RSQ= X-Received: by 2002:ab0:6c4e:: with SMTP id q14mr1614030uas.128.1644937717392; Tue, 15 Feb 2022 07:08:37 -0800 (PST) MIME-Version: 1.0 References: <164486630810.23318.17510494681949788379@wrigleys.postgresql.org> In-Reply-To: <164486630810.23318.17510494681949788379@wrigleys.postgresql.org> From: "David G. Johnston" Date: Tue, 15 Feb 2022 08:08:19 -0700 Message-ID: Subject: Re: tutorial problem solution requires that problem is already fixed To: germano.thomas@cwi.com.br, Pg Docs Content-Type: multipart/alternative; boundary="00000000000052a82905d80fe813" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --00000000000052a82905d80fe813 Content-Type: text/plain; charset="UTF-8" On Tue, Feb 15, 2022 at 8:04 AM PG Doc comments form 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. --00000000000052a82905d80fe813 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Tue, Feb 15, 2022 at 8:04 AM PG Doc comments form <<= a href=3D"mailto:noreply@postgresql.org">noreply@postgresql.org> wro= te:
The following documentation comment has been lo= gged 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.<= br>
I am following this tutorial:
https://www.postgresql.org/docs/14/tutori= al-createdb.html
I got the error "createdb: error: connection to server on socket
"/tmp/.s.PGSQL.5432" failed: FATAL:=C2=A0 role "joe" do= es 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/datab= ase-roles.html". But from there it
is already an SQL command. How am I supposed to do that if I didn't eve= n
created the database yet? Where should I execute those?

Elsewhere you should have already learned that PostgreSQL so= lves the bootstrap problem by creating an initial superuser and database du= ring the running of the "initdb" command.=C2=A0 You connect as th= at user to that database to create your second user (and possibly database)= .=C2=A0 Both are named "postgres" by default.=C2=A0 Though the do= cumentation 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.
--00000000000052a82905d80fe813--