pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feedUnexplained createdb mydb response
2+ messages / 2 participants
[nested] [flat]
* Unexplained createdb mydb response
@ 2019-06-05 02:39 PG Doc comments form <noreply@postgresql.org>
0 siblings, 1 reply; 2+ messages in thread
From: PG Doc comments form @ 2019-06-05 02:39 UTC (permalink / raw)
To: pgsql-docs@lists.postgresql.org; +Cc: rltenney@gmail.com
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/tutorial-createdb.html
Description:
I tried the first example in section 1.3 of the initial tutorial,
createdb mydb
The tutorial says
> If this produces no response then this step was successful and you can
skip over the remainder of this section.
Well, it produces no response, no response at all. It doesn't even return
control to the shell. I have to use ^C to kill it.
If I try
which createdb
I get the response
/cygdrive/c/Program Files/PostgreSQL/11/bin/createdb
so the program is installed.
Any suggestions on what to do would be appreciated.
Thanks.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Unexplained createdb mydb response
@ 2019-06-09 14:55 Tom Lane <tgl@sss.pgh.pa.us>
parent: PG Doc comments form <noreply@postgresql.org>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2019-06-09 14:55 UTC (permalink / raw)
To: rltenney@gmail.com; +Cc: pgsql-docs@lists.postgresql.org
PG Doc comments form <noreply@postgresql.org> writes:
> I tried the first example in section 1.3 of the initial tutorial,
> createdb mydb
> The tutorial says
>> If this produces no response then this step was successful and you can
>> skip over the remainder of this section.
Well, it's right --- the normal behavior is to just do it without
printing anything:
$ createdb mydb
$
Or you might get an error:
$ createdb mydb
createdb: error: database creation failed: ERROR: database "mydb" already exists
$
> Well, it produces no response, no response at all. It doesn't even return
> control to the shell. I have to use ^C to kill it.
That's weird, but I think it's not in-scope for the docs (especially a
tutorial) to explain behavior that shouldn't be happening.
One idea is that you have a firewall or packet filter blocking the
connection attempt. In that case I'd expect createdb to time out and
report a connection failure when it gets no response, but the timeout
is probably a few minutes ... how long did you wait?
Another possibility is that createdb is trying to prompt for a database
password but for some reason the "Password:" prompt is not showing up
on your terminal. That could be a bug, but I'm not familiar enough
with the Cygwin environment to diagnose it.
> Any suggestions on what to do would be appreciated.
You'd probably be better off asking for help about this on the -novice
or -bugs lists than -docs.
regards, tom lane
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2019-06-09 14:55 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2019-06-05 02:39 Unexplained createdb mydb response PG Doc comments form <noreply@postgresql.org>
2019-06-09 14:55 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox