More clarification on createdb command

From: PG Doc comments form <noreply(at)postgresql(dot)org>
To: pgsql-docs(at)lists(dot)postgresql(dot)org
Cc: geetha021970(at)gmail(dot)com
Subject: More clarification on createdb command
Date: 2018-12-01 17:04:58
Message-ID: 154368389812.1294.572150972873739473@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/11/tutorial-createdb.html
Description:

When I first followed the command, I first couldn't understand which shell
to execute this in - the psql shell or the normal command line. Although a
small point, specifying this could make life easier. :)

Another thing I noticed is that when I followed this on my Windows 10, it
asks for a password. My laptop is just a stand-alone, and isn't connected to
any LAN. During the installation, the only password it asks for the postgres
superuser. When I try entering that password, I get an error -
createdb: could not connect to database template1: FATAL: password
authentication failed for user "HP",
where the name of my laptop is HP.
To rectify this issue, I had to make a new user in the pgAdmin (at least, I
initially used pgAdmin, but later realized that it could be done using SQL
itself on the command prompt). I don't know any workaround for this issue,
but maybe specifying that could be more helpful for beginners like me ;)

Browse pgsql-docs by date

  From Date Subject
Next Message Maksim Milyutin 2018-12-03 15:18:30 Typo in description of replay_lag attribute in pg_stat_replication view
Previous Message PG Doc comments form 2018-12-01 17:02:29 More clarification on createdb command