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
