The following bug has been logged on the website:
Bug reference: 14553
Logged by: Clive Boughton
Email address: clive@the-boughtons.net
PostgreSQL version: 9.5.6
Operating system: Fedora 25
Description:
I've installed (what I downloaded as PG9.6) PG9.5.6 onto Fedora 25. All
seemed to go OK, but when I went to test 'CREATEDB" I received the
following:
"createdb: could not connect to database postgres: FATAL: role
"my-Fedora-username" does not exist".
I tried to follow the instructions in the PG User Manual - NOTHING
WORKED!!
Ultimately, I realised that as part of the setup of postgres the
documentation that came with the download specified using "system intidb"
and "systemctl start postgresql.service" but the "systemctl" command
doesn't showup when searching the manual. The manual instead mentions
"pg_ctl" which I tried after stopping postgres with "systemctl". The pg_ctl
start command failed with the suggestion that there was no specified
datadir. I restarted postgres with systemctl and then tried to stop it with
pg_ctl. This resulted in a message to the affect that I could do that as
root (which I was logged in as). SO WHAT IS GOING ON?? or more likely "WHAT
HAVE I DONE" I have found the manual to be very confusing on the topic o f
installation. BTW, I deliberately did not attempt to do an install from
source - that brought with it a whole heap of other (largely hidden issues
concerning other software that PG uses.
CVB
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
