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 j
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:
cre
On Tue, Jan 9, 2018 at 3: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 conne
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 :
> 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 tryin
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 postgre
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
