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
