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 ;)
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 |