Re: Getting started with first user.

Found out a way out.

Logged in as *root*, and created a password for the *postgres* user.

Then logged in as *postgres* and and ran "createuser -s me".

Then logging in as *me*, ran "createdb"

Agnar

On 09/01/2018 17:13, Adrian Klaver wrote:
> On 01/09/2018 01:48 AM, Agnar Renolen wrote:
>> 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?
>
>
> https://wiki.debian.org/PostgreSql#User_access
>
>