public inbox for [email protected]
help / color / mirror / Atom feedtutorial problem solution requires that problem is already fixed
2+ messages / 2 participants
[nested] [flat]
* tutorial problem solution requires that problem is already fixed
@ 2022-02-14 19:18 PG Doc comments form <[email protected]>
2022-02-15 15:08 ` Re: tutorial problem solution requires that problem is already fixed David G. Johnston <[email protected]>
0 siblings, 1 reply; 2+ messages in thread
From: PG Doc comments form @ 2022-02-14 19:18 UTC (permalink / raw)
To: [email protected]; +Cc: [email protected]
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?
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: tutorial problem solution requires that problem is already fixed
2022-02-14 19:18 tutorial problem solution requires that problem is already fixed PG Doc comments form <[email protected]>
@ 2022-02-15 15:08 ` David G. Johnston <[email protected]>
0 siblings, 0 replies; 2+ messages in thread
From: David G. Johnston @ 2022-02-15 15:08 UTC (permalink / raw)
To: [email protected]; Pg Docs <[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.
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2022-02-15 15:08 UTC | newest]
Thread overview: 2+ messages (download: mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2022-02-14 19:18 tutorial problem solution requires that problem is already fixed PG Doc comments form <[email protected]>
2022-02-15 15:08 ` David G. Johnston <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox