Getting started with first user.

From: Agnar Renolen <agnar(dot)renolen(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Getting started with first user.
Date: 2018-01-09 09:48:04
Message-ID: CABE_MPz9M0XSkuzQdKSWh0=Mcs4T6JCy8UQ6n2j4aahY9_=b9A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2018-01-09 10:01:25 Re: help with generation_series in pg10
Previous Message David G. Johnston 2018-01-09 05:42:43 Re: help with generation_series in pg10