Re: Getting started with first user.

From: Raymond O'Donnell <rod(at)iol(dot)ie>
To: Agnar Renolen <agnar(dot)renolen(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Getting started with first user.
Date: 2018-01-09 16:32:01
Message-ID: 4a784095-414e-65f5-f24c-1c5d883fa5b8@iol.ie
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 09/01/18 09:48, Agnar Renolen wrote:
> 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"

You need to specify the host as well, to force a TCP/IP connection:

createuser -U postgres -h localhost me

The default pg_hba.conf on Debian uses a Unix socket and peer
authentication, hence the error you're seeing.

Ray.

--
Raymond O'Donnell :: Galway :: Ireland
rod(at)iol(dot)ie

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Vitaliy Garnashevich 2018-01-09 16:43:31 Re: Number of rows returned by Sort node
Previous Message Alvaro Herrera 2018-01-09 16:23:57 Re: RES: help with generation_series in pg10