Postgres Pro
Downloads
Home   >   mailing lists

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

From John McKown
Subject Re: Getting started with first user.
Date
Msg-id CAAJSdjj-G+=x6PZ5Wutp_TbykjEWaUpMj75EN4tsurOk5GENug@mail.gmail.com
Whole thread Raw
In response to Getting started with first user.  (Agnar Renolen <agnar.renolen@gmail.com>)
List pgsql-general
Tree view
On Tue, Jan 9, 2018 at 3:48 AM, Agnar Renolen <agnar.renolen@gmail.com> 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?

​It's been a long time for me, but as I recall, I did something like:

me$ sudo su - # change to root
root# su - postgres # change to postgres user
postgres$​ createuser -s me #create "me"
postgres$ exit # go back to root
root# exit # go back to me
me$ createdb me # create my default database

In /var/lib/pgsql/data/pg_hba.conf , I have lines like:

# TYPE  DATABASE        USER            ADDRESS                 METHOD

# "local" is for Unix domain socket connections only
local   all             all                                     trust 
# IPv4 local connections:
host    all             all             127.0.0.1/32            trust
# IPv6 local connections:
host    all             all             ::1/128                 trust


 



--
I have a theory that it's impossible to prove anything, but I can't prove it.

Maranatha! <><
John McKown

pgsql-general by date:

Previous
From: Márcio A. Sepp
Date:
Subject: RES: help with generation_series in pg10
Next
From: Alvaro Herrera
Date:
Subject: Re: RES: help with generation_series in pg10