Postgres Pro
Downloads
Home   >   mailing lists

Getting started with first user. - Mailing list pgsql-general

From Agnar Renolen
Subject Getting started with first user.
Date
Msg-id CABE_MPz9M0XSkuzQdKSWh0=Mcs4T6JCy8UQ6n2j4aahY9_=b9A@mail.gmail.com
Whole thread Raw
Responses Re: Getting started with first user.  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: Getting started with first user.  (Jaime Soler <jaime.soler@gmail.com>)
Re: Getting started with first user.  (John McKown <john.archie.mckown@gmail.com>)
Re: Getting started with first user.  (Raymond O'Donnell <rod@iol.ie>)
List pgsql-general
Tree view
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?

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: help with generation_series in pg10
Next
From: Alvaro Herrera
Date:
Subject: Re: help with generation_series in pg10