Re: [GENERAL] createuser: How to specify a database to connect to

> -Ursprüngliche Nachricht- > Von: Adrian Klaver [mailto:adrian.kla...@aklaver.com] > Gesendet: Montag, 13. März 2017 17:28 > An: Tom Lane > Cc: Schmid Andreas; 'pgsql-general@postgresql.org' > Betreff: Re: [GENERAL] createuser: How to specify a database to conn

Re: [GENERAL] createuser: How to specify a database to connect to

On 03/13/2017 09:19 AM, Tom Lane wrote: Adrian Klaver writes: On 03/13/2017 08:52 AM, Tom Lane wrote: If by "history" you're worried about the server-side statement log, this is merest fantasy: the createuser program is not magic, it just constructs and sends a CREATE USER command for you. Yo

Re: [GENERAL] createuser: How to specify a database to connect to

Adrian Klaver writes: > On 03/13/2017 08:52 AM, Tom Lane wrote: >> If by "history" you're worried about the server-side statement log, this >> is merest fantasy: the createuser program is not magic, it just constructs >> and sends a CREATE USER command for you. You'd actually be more secure >> us

Re: [GENERAL] createuser: How to specify a database to connect to

2017-03-13 17:10 GMT+01:00 Tom Lane : > Guillaume Lelarge writes: > > It's not very hard to do. But I really wonder why it's not already done. > I > > fear there was a good idea, but I fail to see which one :) > > The core reason why we haven't complicated createuser in that particular > directio

Re: [GENERAL] createuser: How to specify a database to connect to

Guillaume Lelarge writes: > It's not very hard to do. But I really wonder why it's not already done. I > fear there was a good idea, but I fail to see which one :) The core reason why we haven't complicated createuser in that particular direction is that createuser is only a convenience function

Re: [GENERAL] createuser: How to specify a database to connect to

On 03/13/2017 08:52 AM, Tom Lane wrote: Schmid Andreas writes: 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

Re: [GENERAL] createuser: How to specify a database to connect to

2017-03-13 16:57 GMT+01:00 Adrian Klaver : > On 03/13/2017 08:44 AM, Guillaume Lelarge wrote: > >> 2017-03-13 16:29 GMT+01:00 Schmid Andreas > >: >> >> Hi >> >> I'm trying to add a new DB user with the following command from my >> client machine: >>

Re: [GENERAL] createuser: How to specify a database to connect to

On 03/13/2017 08:44 AM, Guillaume Lelarge wrote: 2017-03-13 16:29 GMT+01:00 Schmid Andreas mailto:andreas.sch...@bd.so.ch>>: 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

Re: [GENERAL] createuser: How to specify a database to connect to

Schmid Andreas writes: > 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

Re: [GENERAL] createuser: How to specify a database to connect to

2017-03-13 16:29 GMT+01:00 Schmid Andreas : > 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 postgr

[GENERAL] createuser: How to specify a database to connect to

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", use