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@lists.fedoraproject.org
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

Reply via email to