I get the error FATAL role does not exist when doing a rake db:create:all.
The post here asks the same question, except that the answer doesn't work.
Travis CI: FATAL: role does not exist
I get to the postgresql console this way: 'sudo -u postgres psql'
Typing
CREATE ROLE X SUPERUSER
CREATE ROLE X CREATEDB LOGIN
or anything for that matter, at the postgres=# prompt does nothing. Absolutely nothing. It doesn't give me a success or fail message or any acknowledgement message whatsoever.
When I type \du to list roles, only the postgres role is there.
I discovered that much like MySQL, postgresql requires that I use semi colons at the end of a command.
I'm too used to MS SQl not requiring it.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With