Re: Getting started with first user.

[Jaime Soler <jaime.soler@xxxxxxxxx>]

please try su postgres -c 'createuser -U postgres me' or change auth method in your pg_hba.conf

2018-01-09 10:48 GMT+01:00 Agnar Renolen <agnar.renolen@xxxxxxxxx>:

I have just installed PostGIS (Postgres9.6) on a Debian server using apt-get.

But I have problems doing anything:

I installed as root, but trying doing things as my local user "me"

me> createuser me

createuser: could not connect to database postgres: FATAL: role "me" does not exist

Then, trying the same as root, but gettinge the same result.

root> createuser me
createuser: could not connect to database postgres: FATAL: role "root" does not exist

Then trying with the -U postgres option.

root> createuser -U postgres me
createuser: could not connect to database postgres: FATAL: Peer authentication failed for user "postgres"

How do I get started?