Home > mailing lists

Thread: Getting started with first user.

Getting started with first user.

From

Agnar Renolen

Date:

09 January 2018, 15:48:04

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?

Re: Getting started with first user.

From

Adrian Klaver

Date:

09 January 2018, 22:13:59

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


-- 
Adrian Klaver
adrian.klaver@aklaver.com

Re: Getting started with first user.

From

Jaime Soler

Date:

09 January 2018, 22:14:21

please try su postgres -c 'createuser -U postgres me' or change auth method in your pg_hba.conf

2018-01-09 10:48 GMT+01:00 Agnar Renolen <agnar.renolen@gmail.com>:

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?

Re: Getting started with first user.

From

John McKown

Date:

09 January 2018, 22:17:41

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

Re: Getting started with first user.

From

Raymond O'Donnell

Date:

09 January 2018, 22:32:01

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@iol.ie

Re: Getting started with first user.

From

Agnar Renolen

Date:

10 January 2018, 01:20:40

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