Hi, I want to create a PostgreSQL db. So I did the following: $ su - # su - postgres $ pg_ctl initdb -D /var/lib/pgsql/data $ exit # systemctl start postgresql # exit $ createdb mydb createdb: could not connect to database template1: FATAL: role "user" does not exist I don't understand this since /var/lib/pgsql/data/pg_hba.conf has these lines: # TYPE DATABASE USER ADDRESS METHOD local all all trust host all all 127.0.0.1/32 trust host all all ::1/128 trust Shouldn't the local line take care of my permissions? What am I doing wrong? TIA, -- Suvayu Open source is the future. It sets us free. -- 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
