Sorry for the very OT about postgres, (only claim to fame is it's on
Feora 19), but I've been on this all day and am lost, searched
StackOverflow, Postgresql pages, etc, and I am no further. I hope a psql
database admin can explain.
I have a postgres database: registration_test owned by postgres UTF8,
Access privileges =Tc/postgres, postgres=CTc/postgres, tester=CTc/postgres
Role named tester to which out of desperation I gave superuser privileges.
When I run rails command - rake test /test/mailers/notifier_test.rb I
get error:
PG::InsufficientPrivilege: ERROR: must be owner of database
registration_test
Apparently it cannot drop and recreate the database.
Rails4 database.yml
test:
adapter: postgresql
database: registration_test
encoding: unicode
pool: 5
username:
password:
Same yml, privileges, etc as development and production and they work well.
pg_hba.conf:
local all postgres 127.0.0.1/32 @authmethodhost@
local all tester 127.0.0.1/32 @authmethodhost@
Also cannot find info on what CTc/postgres means, some privileges have
C*T*c*/postgres, couldn't find info on that either.
Have restarted and reloaded postgres.
Help is greatly appreciated, thank you in advance.
Roger
--
users mailing list
users@xxxxxxxxxxxxxxxxxxxxxxx
To unsubscribe or change subscription options:
https://admin.fedoraproject.org/mailman/listinfo/users
Fedora Code of Conduct: http://fedoraproject.org/code-of-conduct
Guidelines: http://fedoraproject.org/wiki/Mailing_list_guidelines
Have a question? Ask away: http://ask.fedoraproject.org
