On Tuesday, July 12, 2022, PG Doc comments form <
noreply@postgresql.org> wrote:
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/14/tutorial-createdb.html
Description:
Hello,
I'm new to postgres so following through the steps in "Chapter 1. Getting
Started".
I was surprised to see that the chapter goes directly from "1.2
Architectural Fundamentals" to "1.3 Creating a Database" with no explanation
of how to start a client application (ex: pgAdmin?) and how to connect to
the local server. In other words, section 1.3 starts off with instructions
for running the command "createdb mydb" but it's not clear where to run
it.
I think readers would benefit for an intermediate step between 1.2 and 1.3
that explains how to start the client software, how to connect to the server
and where to run commands.
Per the conventions chapter it is made clear that thing command being run is an operating system executable in the shell, not an SQL command in some client program.
The only client that will be considered is the command line psql client.
The book as a whole assumes that you installation allows for connections to the postgres database to be done without any command line arguments or even a password, as trust or peer are assumed to work against the local socket. This is what “Getting Started - Installation” is rambling on about.
The purpose here is just to setup a clean database to experiment in so the postgres database doesn’t get polluted.
Hope that clears things up for you.
David J.