From: | Schmid Andreas <Andreas(dot)Schmid(at)bd(dot)so(dot)ch> |
---|---|
To: | "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org> |
Subject: | createuser: How to specify a database to connect to |
Date: | 2017-03-13 15:29:48 |
Message-ID: | 11fbd835426e49ff9909911c7d376272@bd.so.ch |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi
I'm trying to add a new DB user with the following command from my client machine:
createuser -h my.host.name -U mysuperusername --pwprompt newusername
I'm getting the following message:
createuser: could not connect to database postgres: FATAL: no pg_hba.conf entry for host "10.0.0.1", user "mysuperusername", database "postgres", SSL on
Now, it's true that our pg_hba.conf doesn't allow access to the postgres database. We did this intentionally, as usually no one needs to connect to this database.
So I tried to do
export PGDATABASE=sogis
before the createuser command. But no success. Does anyone know of another way to achieve what I'm trying?
I whish to do it with createuser rather than with the SQL command CREATE USER because this way I can avoid the password for the new user to show up anywhere in the history.
I'm on 9.2 on Ubuntu 14.04.
Thank you very much,
Andi
From | Date | Subject | |
---|---|---|---|
Next Message | Guillaume Lelarge | 2017-03-13 15:44:19 | Re: createuser: How to specify a database to connect to |
Previous Message | David G. Johnston | 2017-03-13 15:09:15 | Re: How to define the limit length for numeric type? |